matching reference for auto-reconciling one bank statement payroll line and multiple transactions?
Hello
I have a requirement where the ERP receives the bank statement (MT940) for payroll as one bulk payment, while the payroll system transactions are integrated into Cash Management per employee payment.
As a result, there is one bank statement line (e.g., total amount of 1M) and multiple system transaction lines whose total equals 1M. The requirement is to run the auto-reconciliation process on these transactions. The system transaction lines contain individual reference numbers per employee payment.
I can't find reference for matching criteria to match 1 to many transactions.
Thanks