More than 1 additional reporting currency

edmasto

I have a need for more than one additional reporting currency in Nav 4.0. I don't want to use consolidations as a "work around". When I need to generate financial info in a currency that is NOT the LCY or an additional reporting currency, what are the ramifications behind simply changing the additional reporting currency when needed?

bbrown

The ACY values are calculated at time of posting and stored on the ledger records. You could add additional ACY fields to handle more currencies.

ara3n

If you change the additional reporting currency, a batch job will appear.
Running this batch job will cause the program to recalculate already posted general ledger entries in the new additional reporting currency.

This will lock everybody out of the system. I would recomment getting a backup and restore in a different company or database and run this when you need to report in different currency.

You could aslo follow bbrown advise.

Another option could be to change the report to print in a different currency at runtime. Probably the least intrusive and easiest solution.

bbrown

Another option could be to change the report to print in a different currency at runtime

You would need to maintain the historical currency conversion rates so that you could calculate each entry when running the report. This calculation might have a sizable performance impact on some reports.

Kowa

Sometimes additional rounding G/L entries are inserted just to maintain the correct balance in the additional reporting currency fields. This e.g. happens if the smallest currency unit of the additional reporting currency is worth less than the LCY smallest unit. If the additional reporting currency is changed over and over again I would expect some rounding issues which can't be easily resolved.

vivektaurian

Hi,

I think u have to specify some figures in the Appl Rounding Precesion field on the rounding tab of the currency card.