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.
Has anybody figured this one out? It would be very useful to us. Thanks in advance.
-Matt S.