The issue is that the Customer exchange adjustment report generated after running the exchange adjustment totally incorrect ‘Balance as at’ figures for certain customers.
Analyzed one of the Customers as follows
Listed the customers open transactions
Ran a simulation of the exchange adjustment . Correct balance appeared
Identified the exchange amounts that will be posted to the Forex Unrealized Loss A/C and Trade Receivables
Ran the Customer Adjustment.
Compared the Customer exchange report’s balance of the customer with the customers aging report and Customer outstanding balance.
Thee customer I checked for had only ONE open transaction ( As per Customer details → Balance → Open transactions) , but it was nothing was displayed for the customers transactions in Exchange adjustment when the ‘Show Open only’ checkbox was selected.
Note: The ledger postings were correct after this exercise ( Good!)
Since we cannot reprint the customer exchange adjustment report , is there any other way to access it ? ( Table ?)
Also I did not run the Batch job for Customer adjustments. Will running this adjust the already settled transactions or just the open transactions ?
Found the root cause. The report is not wrong after all!
The Exchange report shows the summation of all the customer’s transactions in the customers currency only. This excludes any settlements made for an invoice with a different currency. For Eg :- if an invoice was issued in CNY but settled in USD , then that particular invoice amount will be taken up in the summation for CNY currency in the report. The report sums of these transactions plus the open amount.
Trust this will assist if you all have a similar issue with this report in future.