You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cash management 23A, unable to reconcile bank statement 1-Multiple and Multiple-Multiple

edited Apr 13, 2023 10:11AM in Payables, Payments & Cash Management 1 comment

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!