My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
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 = [];…