Camt.054 customer payment matching logic

(0) Share

Report

Posted on by CU06051631-1

Hello all,

We are considering cash application using Advanced bank or Customer payment journal import function. We will be using camt.054, although we could also get other formats, if needed. We ran few tests and all the configuration is in place, but no matching successful.

Can someone expand a bit on the built-in matching logic if there's any, when importing into Customer payment journal? Is it trying to match based on customer bank account? Or purely customer invoice? Or does the file actually have to have the customer account number and data staged like if it was a data migration?

If using Advanced bank rec to import the customer payments as a camt.054 statement, does any know how the "In" operator work in the reconciliation matching rule?