Currently, Navision W1/3.70 has only 1 “Additional Reporting Currency”. Is it possible to add and use a second Additional Reporting Currency, in the system? A third? And how can I do that, without spoiling the system performance and database size? Thanks
you can do that but you will have to drill through a lot of navision code , actually the reporting currency values are stored in the tables as an additional column and this coulm is used when we select the option to report by the reporting currency, when we change the reporting currency the report processes all the values in LCY and converts them into the Reporting currency these values are updated in the columns different values, so if you wish to add more reporting currencies you will need to add additional column to all the GL tables used for Reporting Currency and then add the code to update these column in the Set Reporting Currency report. A better choice would be to have the desired report customized you can prompt the user to select a reporting currency and then do the currency conversion in the report itself using the currency conversion codeunits present - i hope i sound of some help to you
Dear Santosh Singh, Thank you for you prompt reply. You mentioned that: A better choice would be to have the desired report customized, you can prompt the user to select a reporting currency and then do the currency conversion in the report itself using the currency conversion codeunits present Will that do the calculation, with the currency of the posting date, or the currency of the workdate? If workdate, that won’t help.
The date is a parameter of the currency conversion functions, so you can use whichever one you want.
I would have to disagree that this can be done. When Posting, Navision checks that all the entries balance in both the base and additional currencies. If these entries don’t balance, then the post won’t complete. This is internal Navision code, so we can’t add a second currency here. It might be possible (read foolish) to change all of the code aside from this to add another currency field, but this would still be a huge undertaking.
quote:
Originally posted by chrisk
I would have to disagree that this can be done. When Posting, Navision checks that all the entries balance in both the base and additional currencies. If these entries don’t balance, then the post won’t complete. This is internal Navision code, so we can’t add a second currency here. It might be possible (read foolish) to change all of the code aside from this to add another currency field, but this would still be a huge undertaking.
Why impossible?? You don’t need changing the posting code. You just need modify the reports/forms where you are needing to check the values on other additional currencies for adding the value conversion between the different currencies you’re wanting to have. You don’t need changing any data at all, but just showing the values stored on the different other currencies where that information is needed.
There is a huge difference between adding a second Additional Reporting Currency and showing the G/L in a different Currency on a Report/Form. Adding a Second ARC (which is what I was referring to) does require a change to Posting Routines.
HI Please think why are you mainly looking at the Additional currency … 1. If you really need it based on the currency rate at the time of posting then better to calculate and add into the new field on the ledger entries. 2. If you need it based on the Currency table then calculate when ever you run the report this may slow down the report if the volume of transactions are high.
Esat, Perhaps a clearer understanding of requirements is needed before we can help you evaluate the merits of the technical solutions. What information and why and when do you need to see data in another currency?