Cash management 23A, unable to reconcile bank statement 1-Multiple and Multiple-Multiple
Summary:
unable to reconcile Statements field "structured payment reference" with payment fields "Payment File Reference" and "Logical Group Number" (only Logical Group Numbering seems available for grouping).
Content (required):
I have following cases, 1 stmt line -> 2 System Payments + 2stm lines -> 32 system payments,
I have on Statements field "structured payment reference" I group by and I have system trx side (payments) fields "Payment File Reference" and "Logical Group Number", as only Logical Group Numbering is available for grouping.
I set matching rule to like: "t.Logical Group Number" like '%S.structured payment reference%" but Oracle do not reconcile
who can explain me what are the database table fields mapped to the reconciliation fields?