Finance | Project Operations, Human Resources, ...

Import Customer Payments with Camt.054 file- payment status received for all transactions

(0) Share

Report

Posted on by Community Member

Hi,

I'm currently working with customer payments and will import payments from the bank with the Camt. 054 format.

I have created a new customer payment journal > selected import payments > selected my method of payment set up with camt 054 format > Browsed my Camt file and set the parameters "Import incorrect records" and "Settle transactions" to yes.

Then, all payments are imported to my journal. However, all lines (both transactions settled to an invoice and transactions without an invoice match) gets the payment status "received".

I have previously worked with the the BGMax format, and when using that format settled transactions gets payment status "Approved" while the unmatched transactions gets status "received". Hence, you can easily seperate settled from unsettled transactions and it is easy to see which transactions you manually need to handle.

Is there any setup I have missed to get different statuses on settled and not settled transactions when using camt.054 format, or is this just the way Camt.054 works?

Also, when using the BGMax format you get an import report when all transactions have been imported to the journal with a description of each imported transaction (if the transaction is ok or if it does not get a match and why it doesn't get a match). I can't find any similar report when importing the Camt054 file. Does anyone know if a similar report can be found in D365?

Thanks in advance!

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Emma4,

Please check setup for Return format status mapping on Account payable > Setup > Payment setup > Return format status mapping:

Usually customer payment file that created by Bank have "RCVD" (i.e. <Cd>RCDT</Cd>) as status so you can set payment status on customer method of payment to "Received" so you can post the customer payment journal

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Alireza,

Thanks for your reponse.

Unfortunatley there is no RCVD code in my file from the bank, so even though I tried to set up the codes in return format status mapping it didn't work.

I do know about the payment status setup in the method of payment. However this doesn't solve my problem since I do not want to post my journal with status received. I want to be able to differentiate between the payments depending on its payment status. I want as little manual handling of the imported payments as possible, and therefore I would need to be able to see which payments that are settled to an invoice and hence are approved in my world, and which invoices that are not settled and therefore needs manual handling.

Hope this clarifies my issue.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Emma4,

Which is the status for payment in the file ((i.e. <Cd>RCDT</Cd>) ?

It is important to check that how your Bank generate these Camt054C files , either with received or approved status. If you want to import the as approved status, you can ask the bank to update these file with approved status.

Was this reply helpful? Yes No
Hermann Schonfeldt 10 on at

Like (0)

Report

Hi

We experience the same problem as Emma describes. The bank is in no position to set the status of incoming payment. The matching of incoming payments and open invoices must be done in D365. Indeed, the matching works fine using the ISO20022 Camt.054.Credit file, however, the status ought to be set to approved, rather than recieved, for all successfully matched payments. As Emma mentioned above, this worked fine with the previous format BGMax in Sweden.

Regards,
Hermann Schönfeldt
Implema

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Hermann,

It is up to bank that how they formulate the Camt054C file. You can either use Received or Approved status as you mentioned. Some Banks send status <Cd>RCDT</Cd> (Received) per payment reference.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Please check dynfotech.com/.../ for more info about ISO20022 payment files-

Was this reply helpful? Yes No