Bank Reconciliation - Trying to change configuration to automatically reconcile one-to-many trans in
Here is the situation:
External Transaction captures one transaction for 1000 USD for example on a given date
Bank statement comes with two transactions, one for 300 and the other for 700 on the same date and with the same reference.
Is there any way that I can change the Reconciliation Rules to match the two transactions from the bank statement to automatically match the one external transaction for 1000 USD, and avoid the "Amount not Equals" exception?
I appreciate any quick guide on the topic.