Is there a foreign exchange gains and losses report available?
As a global company, with entities using +50 currencies, we'd like to see a report to understand what is generating the foreign exchange gains and losses at the GL consolidated ledger.
The report should include information from GL such as period, ledger, date, full concatenated segments, net entered, document currency, net accounted, ledger currency, JE description, Batch number, source, category. The option to drill down to the invoice, supplier, customer, etc from the subledger that created the amount would be ideal.
At the moment, this analysis is very time consuming by extracting data from GL, and I understand there could be a more efficient way to report on this data.