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…

Hello @User_O7R0O, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated.

Hello @Ma. Angela Beatrice Mendoza-Oracle, Good day and thank you for posting this new thread! Hello everyone! We kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello @Vismay Barot, Good day. This looks like a question that would be better answered by our community members. Tagging here some of our active contributors in case they have any insights. @Tigran Shahnazaryan @Tiru Chembeti @GauravAgrawal @John Griffin @Chelsea Jacobs @Dext3r @Sakshi_Garg Hey everyone! If you have any…

Hello @User_CXCRJ, Good day! Were you able to check the suggestion from @Dext3r? If you still need assistance, please let us know. Thanks!

Hello @PaulFleetwood, Good day. It is not possible to connect with NetSuite via REST integration without using Token-Based Authentication.

Hello @User_SCYT4, Yes, that is correct.

Hello @rgonz-mhi, This is currently filed for enhancement under Enhancement 619787 Support for File attachment in Invoice Group Record Communication Tab via SuiteScript. To support this Enhancement, you can cast your vote on the SuiteIdeas page by following the instructions provided in SuiteAnswers Article: 10054: Voting…

Hello @nag_m, Good day! Following up on this thread in case you missed my previous comment. Let me know if you need further assistance. Thank you

Hello @Dane Muchillas, Good day! Were you able to check the comment from Aljan?

Hello @nag_m, Good day. Vendor Prepayment Record should be included in the transaction table. If you are unable to find the records there, please double-check your permissions for the role you are using to pull the data by navigating to Setup > Users/Roles > Manage Roles > Edit the integration role being used. Make sure…

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

Hello @User_SCYT4, Good day. You can use a RESTlet script to attach a record to another, provided that it is a supported link type. For more information, you can visit SuiteAnswers Article record.attach(options). I hope this helps!

Hi @User_S3GJE, Good day. Can you confirm if the same error occurs when running the script from another application?

Hello @Dane Muchillas, Good day. Following up on case you missed the response from @Aljan Patrick Mendoza-Oracle. Let us know if you need any further assistance. Thanks!

Hello @User_14Q68, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated.

Hello @User_YDOW7, Good day and thank you for reaching out to the NetSuite Support Community! Hello everyone, we would love to have your insights regarding this concern. Your assistance is highly appreciated!