BeyondERP.Newsletter
Menu

Setup step on the Return format error codes page · Accounts payable

Set up Return format error codes

Lists the ISO 20022 status reason codes and descriptions used to interpret errors in pain.002 return files from the bank.

Business process
Defining payment policies in Dynamics 365 Finance
Menu item
BankReturnFormatErrorCodes_W
Main table
BankReturnFormatErrorCodes_W
Data entity
BankReturnFormatErrorCodesEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page for the error codes and descriptions used when importing ISO 20022 pain.002 payment status return messages.
What you do hereUse this page to set up pain.002 error codes in line with the external ISO 20022 status reason codes, as a prerequisite for importing bank return messages into the vendor payment transfer journal.
ExampleYou set up codes such as AC01 IncorrectAccountNumber and AC04 ClosedAccountNumber so rejected payments returned by the bank show the reason.
Return format error codes page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Return format error codes1 screen

Lists the ISO 20022 status reason codes and descriptions used to interpret errors in pain.002 return files from the bank.

  1. Screen 1

    Create the return format error code

    Go to Accounts payable > Payment setup > Return format error codes

    1. Select New
    2. Enter BEAT-ERR as the error code
    3. Enter the Description and Name
    DescriptionRejected payment
    NameRejected by bank
    Create the return format error code (zoomed on the outlined fields)
    Show the full screenCreate the return format error code
    page title tab to open what to set or check

How to use it

  1. Go to Accounts payable > Payment setup > Return format error codes.
  2. Select New to add a row.
  3. Enter the Code, the Description and the Name.
  4. Select a row and select Edit to change it, or select Delete to remove it.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
CodeThe ISO 20022 status reason code from the bank, such as AC01, with its name.Microsoft Learn Code
DescriptionA short description of the error code.Checked in Dynamics 365Rejected paymentDescription
NameThe name of the error code.Checked in Dynamics 365Rejected by bankName

Test checklist

  1. Add AC01 to AC06 with their ISO names.
  2. Import a test pain.002 file with an AC04 rejection via Payment transfers > Return file - vendor.
  3. Check the payment line shows the error code and description.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Return format error codesThe external ISO 20022 status reason codes with their names, for example AC01 IncorrectAccountNumber and AC04 ClosedAccountNumberLearn requires pain.002 error codes to follow the external ISO 20022 status reason codes before return files are imported.Importing pain.002 files before the ISO20022 pain.002 ER configuration is imported and selected as Return format configuration on the vendor method of payment.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Codes are read when a return file is imported, so changes affect later imports.
Technical architect

6Technical

Menu itemBankReturnFormatErrorCodes_W Checked in Dynamics 365
FormBankReturnFormatErrorCodes_W Checked in Dynamics 365
TableBankReturnFormatErrorCodes_WShown as “Return format error codes” in Record infoKey field: CodeChecked in Dynamics 365
Data entitiesBankReturnFormatErrorCodesEntityReturn format error codes Microsoft data model
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BankReturnFormatErrorCodes_W
Integrate withBankReturnFormatErrorCodesEntity data entity Microsoft data model
Data migrationBankReturnFormatErrorCodesEntity (Return format error codes): loaded for each company.Microsoft Learn
Table definitionBankReturnFormatErrorCodes_W columns and relations Microsoft data model
Everyone

8Sources