Foreign Exchange in Sage Line 50 Professional is a very useful tool. However, if you make a mistake with the exchange rates it can be difficult to identify same and hence almost impossible to correct.
We have designed a report that lists all the FX transcations with the base currency amount and the exchange rate that was used for same. By reviewing this report you will quickly be able to identify any “rogue” exchange rates and hence the probable issues that you are having.
I have attached a sample of this report as a PDF, to view select this link Audit Trail with Foreign Exchange (you will be asked about viruses etc but all is OK, so select)
When loaded to your Sage you can view as a PDF or an Excel sheet and when in Excel you can easily sort by the exchange rate and then zone in on the exceptions which are invariably the issue.
If you require this report then simply contact me at alison@compuland.ie and we can arrange same.
PS. If you require other reports then please contact us with your requirements.