Oracle Fusion Cash Management – One-to-Many Reconciliation
Summary:
Hi All,
We have a requirement to reconcile one bank statement line against multiple GL journal transactions.
For example, the bank statement has a $1,000 transaction, while the system has multiple journals with the same date, journal batch, and reconciliation reference:
Journal 1 – $500
Journal 2 – $500
Journal 3 – $300
Journal 4 – $200
We need to reconcile only Journal 1 + Journal 2 = $1,000, rather than all transactions matching the criteria.
Is there a way that can identify the correct combination based on the total amount? If not, what additional journal attributes or configuration would you recommend to handle this scenario?
Thanks.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):