Francesca Nicole Mendoza-Oracle Gold Crown

Hello @Inna Gerasimchik, Good day. We have received feedback from our engineers today. The SuiteApp for Singapore will not work for Iceland subsidiaries. The feature to implement this is currently on limited availability. If this is urgent, please reach out to your Account Manager to connect you with the engineering team,…

Hello @User_SCYT4, Good day! Following up on this thread in case you missed my previous comment. Thanks!

Hello @Inna Gerasimchik, Good day. I've already reached out to our experts regarding your concern. I'll get back to you as soon as I get a response from them. Thanks!

Hello @User_SCYT4, Good day. Upon checking, is1099Eligible is still not listed among the available fields for SuiteQL in the Records Catalog.

Hi @Philly_NS, Good day! Following up on this thread in case you missed my previous comment.

Hello @Judy Perry, Good day. Status field is listed as a read-only field in this Oracle Help Center Documentation: Therefore modifying the status field directly is not possible.

Happy to help!

Hello @Ashoka_Sanjapu, Good day! Following up on this in case you missed my previous comment. Thanks!

Hello @PatrickConrad, Good day and thank you for posting in the NetSuite Support Community! Hello everyone! We would love to hear your any insights regarding this concern. Your efforts and contributions are highly appreciated.

Hello @Ashoka_Sanjapu, Good day. It should be every Day 1 of every 1 month. The count for month indicates the interval in between the instances. With this in mind, choosing "every 12 months" would mean it will run once a year. I hope this helps!

Hello @User_TQMLE, Good day and thank you for posting in the NetSuite Support Community! Our team and fellow members are here to collaborate and provide insights that may help.

Hi @PaulFleetwood, Good day. You can use the table InvtItemPriceHistory to get the quantity value and use the itemquantityid field as the foreign key. Here's a sample query: SELECT * FROM InvtItemPriceHistory I hope this helps!

Hello @Philly_NS, Good day. It is possible to create Purchase Orders from Sales Orders in NetSuite. This can be done via UI, and via SuiteScript. By setting the createpo field to 'dropship' via Script, NetSuite will automatically create a Purchase Order linked to the Sales Order Item. For more information, you can visit…

Hello @Judy Perry, Good day. SuiteScript mimics the behavior in NetSuite UI for scenarios like this. In your case, if it has been disabled by the system by default, then it is also not allowed to be modified via script. These processes are in place to preserve data integrity and ensure the right steps are followed. A Pick…

Thanks for letting us know, @Shubham_Singh!

Hello @User_VD7L5, Thank you for posting here in the NetSuite Support Community! Hi everyone! Has anyone encountered a similar situation where the payment notification email does not send to vendors, despite the setup appearing complete? Any advice, especially regarding the DMARC/DKIM configuration or additional feature…

Hello @Philly_NS, Good day. Were you able to validate if you are encountering the same errors when creating the PO via NetSuite UI?

Hello @Shubham_Singh, Since SuiteQL is used in SuiteAnalytics Connect and SuiteScript, you can either install a third party application such as DB Visualizer, Power BI and the likes. Alternatively, you can also install the SuiteQL Query Tool, from Tim Dietrich. If you opt for the SuiteQL Query Tool, there is an option to…

Hi @Judy Perry, Good day! Upon checking, the enum for the Pick Task Status for 'Done' is 'COMPLETED'. For future reference, you could open a record in Edit Mode, and access the browser dev tools. Then input nlapiGetFieldValue(<fieldid>). This returns the enum or internal ID of the field. I hope this helps!

Hello @Shubham_Singh, Yes. Using Map/Reduce Script is more ideal if you have to do this regularly, as it would automate the process. But the downside is having to spend time to develop the script which might take longer initially. Running a query manually via SuiteAnalytics Connect is good for a one-time task. This is more…

Hello @User_GX4AA, Good day and thank you for posting in the NetSuite Support Community! Hi everyone, Has anyone else encountered this error? If so, we’d love to hear your insights. Your input will be greatly appreciated by the community.

If this is a one-time thing and you would like to do it manually, I suppose you could also run the query and create the CSV file yourself. Here are the steps: Write a Query SELECT * FROM systemnote WHERE date >= TO_DATE('2015-01-01','YYYY-MM-DD') ORDER BY date; Adjust the filter to cover your date range. You can also use…

Hello @Shubham_Singh, Good day. Since the volume is quite vast, even for SuiteAnalytics Connect, it might be best to run a query segmented into parts. i.e. by date range or by transaction types. You can also run a Map/Reduce Script with SuiteScript's N/suiteql and N/file module to generate files in the File Cabinet. You…

Hello @User_6G058, Thank you for here in the NetSuite Support Community. To everyone, Has anyone else experienced similar issues with mass update failures or unexpected criteria being added automatically? Any insights or troubleshooting steps would be greatly appreciated. We look forward to your input!

Hello @asj_irecon, Thank you for raising this concern and providing a clear description of your configuration and the results observed. To the community, If you have encountered a similar scenario or have recommendations regarding transaction numbering behavior with CSV imports, please feel free to share your insights.…

Hello @GSONI, Good day! No worries. Thanks for letting us know. We're glad that it is now resolved.

Hello @GSONI, Good day. Following up on this thread in case you missed my previous comment. Thank you.

Hello @GSONI, Can you provide a sample SOAP Request of the affected record? We'd like to test it on our test environment and troubleshoot the possible cause.

Hello @User_SCYT4, Good day. I have already exhausted all the options but there does not seem to be a way to attach the purchase order record to the case record's Related Records subtab without using NetSuite UI. As a possible workaround, you could create a custom field with List/Record type that will catch the value of…

Hello @GSONI, Good day. How are you exporting the data from Expensify to NetSuite? Are you using any REST/SOAP integrations or SuiteApp? If you're using the SuiteApp, there could be specific rules in place that are configured via Workflow or Script where the tax code mapping would only work for specific role types. In this…