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?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,849 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU06051631-1,
In Camt.054 (Debit and Credit), there are several mappings from EndToEndId to RmtInf for structured payments. In addition, there is matching logic based on creditor name to identify the customer in Camt.054C, in cases where the transaction cannot be found via Invoice ID or Payment ID.

I suggest to import Camt053 Extended as Camt054.

For more info about ISO200200, you can follow my blog ISO20022 – DynFOTech

Was this reply helpful? Yes No