Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.