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
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Please note that on Friday, January 9, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 60 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
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 = [];…