BeyondERP.Newsletter
Menu

Setup step on the Return format status mapping page · Accounts payable

Set up Return format status mapping

Maps the status codes in pain.002 return files (for example RJCT, ACCP, ACSP) to the payment statuses used on vendor payment journal lines.

Business process
Defining payment policies in Dynamics 365 Finance
Menu item
VendPaymReconciliationReturnStatus_W
Main table
VendPaymReconciliationReturnStatus_W
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 that maps ISO 20022 pain.002 return statuses to vendor payment journal statuses.
What you do hereIt is used so that imported bank status return messages update vendor payments to the matching payment status.
ExampleYou map RJCT to Rejected, ACCP to Accepted and ACSP to Received before importing pain.002 status return files.
Return format status mapping 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 status mapping1 screen

Maps the status codes in pain.002 return files (for example RJCT, ACCP, ACSP) to the payment statuses used on vendor payment journal lines.

  1. Screen 1

    Map the return status to a payment status

    Go to Accounts payable > Payment setup > Return format status mapping

    1. Select New
    2. Enter the Description
    3. Set Payment status and Return status
    DescriptionPayment rejected
    Payment statusRejected
    Return statusBEAT-REJEC
    Map the return status to a payment status (zoomed on the outlined fields)
    Show the full screenMap the return status to a payment status
    page title tab to open what to set or check

How to use it

  1. Go to Accounts payable > Payment setup > Return format status mapping.
  2. Select New to add a row.
  3. Enter the Description, choose the Payment status and enter the Return status.
  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
Return statusThe pain.002 status from the bank, such as RJCT, ACCP or ACSP, mapped to a payment status such as Rejected, Accepted or Received.Microsoft Learn REJECTReturnStatus
DescriptionA short description of the return status.Checked in Dynamics 365Payment rejectedDescription
Payment statusRejectedPaymentStatus

Test checklist

  1. Map RJCT, ACCP and ACSP as above.
  2. Generate an ISO 20022 credit transfer for two vendor payments.
  3. Import a pain.002 file that accepts one and rejects the other.
  4. Check the payment statuses show Accepted and Rejected.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Return format status mappingRJCT to Rejected, ACCP to Accepted, ACSP to ReceivedThis is the mapping Learn shows between pain.002 return statuses and vendor payment journal statuses.Not activating the generic electronic return format on the method of payment, so the import can't update payment statuses.
Solution architect

5Design impact

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

6Technical

Menu itemVendPaymReconciliationReturnStatus_W Checked in Dynamics 365
FormVendPaymReconciliationReturnStatus_W Checked in Dynamics 365
TableVendPaymReconciliationReturnStatus_WShown as “Return format status mapping” in Record infoKey field: RecIdChecked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=VendPaymReconciliationReturnStatus_W
Table definitionVendPaymReconciliationReturnStatus_W columns and relations Microsoft data model
Everyone

8Sources