Can you tell me if it is possible to do currency conversions in Jet Reports without activating multi currency via Jet Data Manager?
I have designed a report and want to convert Non Vendor currencies into the Vendor Account currency.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello -
Without having multiple currencies enabled within your data source, the only option I know of with Jet Essentials would be to compute the values you want based on some conversion rate.
Given that such currency conversion rates change on a daily basis, you would either need to keep track of them over time (and use those based on your posting dates) - or create a report that only reports overall values "as of" a particular date (which, of course, would not be overly accurate). -
Jet Reports Historic Posts I use the currency exchange rate table from Nav to pull out the applicable exchange rate for the currency and posting date (ours change monthly) and do the calculations on a line by line basis.
Please sign in to leave a comment.