Hi @JohanvL , You may use sample syntax below for Inventory Number Search: <searchRecord xsi:type='listAcct:InventoryNumberSearchAdvanced' savedSearchId='1'/> You can also check Schema Browser for the available list of searches in SOAP Web Service. I hope this helps. -Mikko

Hi @JJ Lucarelli , May I ask if you have tried this on other database aside from MS SQL(e.g MS Excel/Access) and if the result is the same? Also, you can compare the data extracted on the odbc and with the Saved Search on the UI. -Mikko

Hi @Bryan Carroll , sometimes, there are dependencies with regard to tax code. E.g when changing shipping address, tax code became blank and item should be chosen first to edit the tax code. See article for reference. You may want to consider the native functionality of NetSuite with regard to tax code. I would suggest try…

Hi @JohanvL , the article Test Credit Card Numbers, is not about ACH processing. If you want to test credit card numbers, you may want to use the sample CC on the article instead of using random numbers for testing. -Mikko

The Allocation Schedule is not exposed on the old data source. The only related columns for this are is_allocation(from transaction_lines) and joining transaction_line_book_map to transaction_lines on transaction_id and transaction_line_id. -Mikko

Hi @User_GONYI , Welcome to NS Support Community and thank you for posting! Our gurus/members will check this for you and get back with more information. To everyone, feel free to share your insights. -Mikko

Hi @Ammar , Thank you for posting in the community! Our gurus/members will look into your concern and get back with more information. Hi @Jack Daryl Espiel-Oracle /@Joahnna Given Uy-Oracle /@Jack Daryl Espiel-Oracle@Kristoffer Viray-Oracle , Any tips to share? To everyone, feel free to comment your thoughts. -Mikko

Hi @PaulFleetwood , you can get client IP address in the request.headers. However, be aware that the data contained within the Suitelet will be less secure when it is allowed to be accessed (via Suitelet execution) without login. See sample syntax: You can make use of this sample for your "whitelist" IP address. Let me…

Have you checked the article and see if this answers your question? -Mikko

Hi @srussell , could you confirm if you are working on Saved Search? What field are you working on? E.g Custom/Standard/What is the data type of the field. This article may also help in casting boolean to other data types. -Mikko

Hi @User_9WGXW , we appreciate if you share the issue number so that if other members experience the same, they could reach to support team and include the issue number. I also suggest to continue coordinating with the support team and provide enough information that might increase urgency level. E.g how does the issue…

Hi @Michael Shparber , You can query OA_tables with table names like 'allocationSchedule%' or 'AllocationSchedule%' to get the available table in your account since there are several tables related to Allocation Schedule. For example, the weight you referring can be obtained by querying AllocationScheduleDestination table.…

For the text part, this is a backend process by the system and as you can see in ODBC the field status only shows until the first part which does not include the "Created from Revenue Recognition Schedule". For the logic. the articles Generating Revenue Recognition Journal Entries and Scheduling Revenue Recognition Journal…

Thank you for providing additional information. This could be a potential defect and it is best to continue coordinating with the support team and providing other information how this is affecting your business on the day to day basis. -Mikko

Hi @Dirk Nieuwkamp , Thank you for posting again in the community! Please wait while the gurus/members look into your concern and get back with more information. Hi @Patrick Fresnosa-Oracle /@Micah Timbol-Oracle , care to share ideas? To everyone, feel free to share your thoughts. -Mikko

Hi Chris @HertsChris , Thank you for posting in the community! Please allow some time for the gurus/members to check on your question and update the thread for any findings. To everyone, feel free to share your knowledge. -Mikko

Hi Imelda @ImeldaSanchez , Thank you for posting in the community! Our gurus/members will look into your concern and get back with more information. Hi @Joy Noreen Magoling-Oracle /@Ivy Lopez-Oracle , any ideas to share? To everyone, feel free to comment your insights. -Mikko

Hi @Dirk Nieuwkamp , Thank you for posting again in the community! Please allow the gurus/members to check this for you and update the thread for any findings. Hi @Jack Daryl Espiel-Oracle /@Kristoffer Viray-Oracle /@Joahnna Given Uy-Oracle /@Michelle Jabanes-Oracle , any ideas to share? To everyone, feel free to share…

Hi @corey.hermanson , could you provide the case number? Could you also check if the SuiteAnalytics Connect is still enabled in your account(Navigate to Setup -> Company -> View Billing Information) Using Administrator Role in the UI. Check the Add-On Modules subtab and look for SuiteAnalytics Connect. Additionally, what…

Hi @Jeff Dickens , Have you tried doing this on a simple form and not on assistant?(For testing to isolate if the problem only encountered on the assistant object) See article for reference. The result should look like this: The total computed by the API should appear next on the Sublist. -Mikko

Hi @Nivz-Oracle NetSuite-Oracle , did we answer your concern? -Mikko

Hi @dsato , do you still receive the error? -Mikko

Do you still encounter the error, @Eklon Eleuterio ? -Mikko

Aside from memo field on the line, I don't see any direct link to a field that will determine journal entry was created from revenue recognition schedule. However, what I can think on top of my head is to create a custom body field(E.g checkbox). Then, you can create a Saved Search based from the Revenue Recognition Plan…

Hi @Nic Mitcham , @MathewB is correct, you need the SuiteAnalytics Connect before you can connect NetSuite to 3rd party integration. Upon further testing, I was able to connect my NetSuite to Tableau Desktop(Latest version. Available on their download) using NetSuite2.com data source and the Connection is (Other…

Hi @User_5V3JK , you are correct that the 3 SuiteCloud Plus License are available in your account thus you can set 45 integration concurrency. The Current Used Qty. in the billing information are the users who have marked as "Concurrent Web Services User". See article for reference. Hopefully this answers your question…

Hi @User_SZ0C3 , this article could help you with your concern. Let us know if this answer your question. -Mikko

Hi @MathewB , may I ask what data source the Tableau using? E.g NetSuite.com/NetSuite2.com? -Mikko

Hi Benoit, did we answer your concern? -Mikko

Hi @Nivz-Oracle NetSuite-Oracle , you are correct that UTF-8 is the supported encoding scheme. There is no available information about supporting UTF-16 for the upcoming releases. However, there are several enhancement like #235990 SSS> nlapiStringToXML> Support greater unicode encoding such as UTF-16 to handle BOM that…