ISO20022 Payment in D365FO for Norway – Part 8 (Import Camt.054C file)

Camt.054 Credit notification (Camt.054C; Norwegian: innbetalingsfil) is an electronic service that bank delivers to corporations for handling of incoming payments. Camt.54C can be imported in D365FO and perform automatic reconciliation process. Once you have activated a legal entity’s customer method of payment with GER config for import format configuration, you can import Camt.054C files.

One Camt054D file must have debit information on additional information tag and a value for “DEBIT” on DebitCreditIndicator (CdtDbtInd)

Note: Customer will generate Pain001 file for bank either in “Structured” or “Unstructured” format.

Note: Bank will generate Pain002 and Camt054 files for the customer from the Pain001 file.

A structured Pain001 file can include either payment ID or invoice number (or both) and unstructured file have just a free text for as invoice information. Camt054D file should have following values the same as Pain001 file:

<PmtInfId>

PaymentInformationIdentification – A unique value including payment number.

<InstrId>

InstructionIdentification – A unique value including payment journal line voucher number date time.

<EndToEndId>

EndToEndIdentification – A unique value including payment journal line voucher number and RecId

< AmtDtls >

AmountDetails – Payment journal line amount and currency.

<Cdtr>

Creditor – Creditor name and address.

<CdtrAcct>

CreditorAccount – Creditor bank account number or IBAN.

<RmtInf>

<Strd>

RemittanceInformation (Structured) – Invoice number or payment id.

<Ustrd>

RemittanceInformation (Unstructured) – A free text for payment information.

There is a sequence by D365FO to identify customer transaction and customer account id when a user import Camt054C file as follows:

Payment ID / KID – SCOR

There will be matching against customer transaction table (CustTrans.PaymID)

Invoice ID – CINV

There will be matching against customer transaction table (CustTrans.PaymID)

Note: Payment ID and Invoice ID information only exist in structured formats. There will be either payment ID or Invoice ID in the Camt054C file.

Customer name – Dbtr

There will be matching against customer name to find customer account ID via Name field (DirPartyTable.Name)

Customer bank account – DbtrAcct

There will be matching against customer bank account or IBAN to find customer account ID (CustBankAccount.BankIBAN)

Once you have received Camt054C file from bank (either manually from NetBank or via integration), it can be imported into D365FO from Account receivable > Payments > Customer payment journal and create a new payment journal. Then click on “Lines” and import payment file by Functions > Import payments.

Then choose payment method that you have used for importing payment file.

Note: Payment method needs to be associated to Camt054 as import format configuration.

On next form, choose bank account and upload Camt054 file.

Note: Add an error customer account to assign unknown payment to this account once customer account not existed and will replace with the error account (i.e., If the invoice Id/payment ID or customer or customer bank account does not exist in the solution)

Note: You need to add payment fee (Fee ID) if charges amount is present in camt.054C file.

Note: Activate “Import incorrect records” to import wrong payments bank account number in the file does not associate with the selected one on bank account field.

Note: Activate “Settle transaction” to find customer invoices and settle them against the customer payments via invoice number/payment ID.

Once you click on “OK”, the file gets imported, payment status will be updated to “Received”:

After you have controlled the journal (e.g., check the journal balance), you can either post the journal manually or in via batch.

Note: You need to define the return status on (Account payable > Setup > Payment setup > Return format status mapping) so the payment status get updated to “Received” for actual payments.