Bank Statement Lines are not reconciling because of diffrent Exchange rate
Hi,
We are using cash management for Reconciling a Payment. But for those payment where the transactional currency is different from the Functional currency, lines are not getting reconciled.
As an example,
Functional Currency: USD
--------- Bank Statement Details-----------------
Transactional Currency: AED
Transaction amount(AED):2320.81
Exchange Rate Type : User
Exchange Rate: .7841
Converted amount (USD) : 1819.75
Exchange Date: Statement Creation Date
--------- Bank Statement Details-----------------
---------Details in Sub-ledger--------------------
Transaction Amount:2320.81
Base Amount:1804.54
Exchange Rate Type: Corporate
Exchange Rate Date: Transaction Date
Exchange Rate: 0.7775503
---------Details in Sub-ledger--------------------
In setup, I have put tolerance as 0.
Ideally this line should be reconciled automatically, but these lines are not getting reconciled. But as expected, in this case a Gain/Loss amount should be appeared when I run the create accounting after reconciling the payment.