My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Comments
-
Hi Nicole, I finally managed to create the work order and then transform it into an assembly build, see code in attachment. I think this is the only way to create an Assembly Build via Suitescript, and I hope this will help the community. You can notice I managed to create the Assembly with one component having a quantity…
-
Hi Nicole, Thank you for your return. No same error with line = 1, it seems the sublist is static, and therefore not accessible via suitescript. I am now trying to create a workorder, seems the sublist is more editable... I will keep you posted if my try is successful. Regards, Julien,
-
Hi Clarisa, OK perfect, it answers my question for the saved search and the script, thanks a lot! Thanks, Regards, Julien,
-
Hi Joahnna, The GL impact in local currency is as below: The saved search or the script returns below values: if we divide (14889.47 / 1448.85) or (12408 / 1207038) we find an fx rate of 10.27. The problem is that the SEK/EUR fx rate is 10.97 and is very different from 10.27. Regards, Julien,
-
Hi Joahnna, No, no error with the script, but amounts are not ok. "The problem is that values seem to be in EUR and I have hard way to find amounts in local currency. When I use the fx rate it does not match the local amount in the UI." Regards, Julien,
-
Hi Joahnna, OK thanks, I misunderstood your answer, so maybe you have a way to export GL impact in local currency? Regards, Julien,
-
Hi Joahnna, Can you please clarify what is not supported: export of GL impact in local currency or restrict view to specific subsidiary? Regards, Julien,
-
In the UI there is a way to get GL impact in local currency by restricting the view to a specific subsidiary, but I am not sure it is doable by script.
-
You can export fx rate via Suitescript: const getFxRate = () => { var currSearch = search.create({ type: "currencyrate", filters: [ ["basecurrency", "anyof", "8"], "AND", ["transactioncurrency", "anyof", "10"], "AND", ["effectivedate", "on", "today"], ], columns: ["exchangeRate", ] }); var res = [];…
-
You can export fx rate via Suitescript: const getFxRate = () => { var currSearch = search.create({ type: "currencyrate", filters: [ ["basecurrency", "anyof", "8"], "AND", ["transactioncurrency", "anyof", "10"], "AND", ["effectivedate", "on", "today"], ], columns: ["exchangeRate", ] }); var res = [];…