Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Is it possible to update consolidated exchange rates by script....
This may sound excessively lazy, but I would like to have a scheduled script update my consolidated exchange rate table.
I like the idea of using the the "calculate" button's result (the weighted average of each of the transactions in the period) because this seems like the most meaningful and accurate number to me. However, people are constantly running consolidated reports all of the place and bitching that rate is not correctly set.
Could I write a scheduled script to "click" the auto-calculate button for each "subsidiary to parent" on a daily basis? Keep in mind we only have two foreign subsidiaries that don't use USD as their base currency.
0