Unable to reconcile a bank statement line with a foreign currency external transaction
Summary:
We are unable to reconcile a bank statement line with a foreign currency external transaction
Content (please ensure you mask any confidential information):
We have a bank account set up in EUR Currency and the Multi Currency Bank Account flag is enabled at bank account level. We created an External Transaction in GBP and trying to manually match against the EUR Statement line, but the reconciliation is failing with the error "Amount difference exceeds the manual amount tolerance. Reconciliation isn't allowed. (CE-660223)". It seems the failure is because system is comparing the EUR statement line amount against the GBP external transaction amount without considering the FX Rate and EUR Conversion. We have 10% tolerance rule for manual reconciliation attached to the bank account,