BeyondERP.Newsletter
Menu

Setup page · Accounts payable

Payment format code sets

A setup page for payment format codes that some Accounts payable methods of payment need, mostly ISO 20022 methods of payment.

Used by
Accounts payable manager, Auditor, Accounting manager and 2 more roles
Business process
Defining payment policies in Dynamics 365 Finance
Menu item
PaymentFormatCodeSets_W
Main table
PaymentFormatCodeSets_W
Data entity
PaymentFormatCodeEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page for payment format codes that some Accounts payable methods of payment need, mostly ISO 20022 methods of payment.
What you do hereUse this page to set up codes that are added as extra tags to payment transactions during payment processing.
ExampleFor example, an ISO 20022 credit transfer method of payment might need a code such as Service type = SLEV.
Payment format code sets 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 Payment format code sets1 screen

Maintains the code sets (service level, category purpose, charge bearer, local instrument) used to tag ISO 20022 payment transactions during payment processing.

  1. Screen 1

    Create the payment format code

    Go to Accounts payable > Payment setup > Payment format code sets

    1. Select New
    2. Choose Service level
    3. Enter the Code and Description
    1CodeBEAT
    DescriptionNot bank approved
    Create the payment format code (zoomed on the outlined fields)
    Show the full screenCreate the payment format code
    page title tab to open what to set or check

How to use it

  1. Go to Accounts payable > Payment setup > Payment format code sets.
  2. Select New to add a row.
  3. Choose the Type and enter the Code and the Description.
  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 code that identifies the payment format code set.Checked in Dynamics 365Code
DescriptionA short description of the payment format code set.Checked in Dynamics 365Not bank approvedDescription

Test checklist

  1. Create service level SLEV and set it on an ISO 20022 method of payment.
  2. Create a payment journal with no header codes and add a line; check SLEV is on the line.
  3. Set a different code on a journal header and add a line; check the header value is used.
  4. Generate the payment file and check the tag is in the XML.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Payment format code setsThe codes your bank's ISO 20022 format requires (for example Service level SLEV), with defaults on the method of payment and overrides on the payment journal header only when neededNew payment journal lines take payment codes from the journal header first and otherwise from the method of payment.Changing codes on the method of payment while the journal header already has values: header values win on new lines.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Codes can be changed at any time; they default onto new payment journal lines only. Microsoft Learn
If you change it laterNew payment journal lines take payment codes from the journal header first; if none are set there, they come from the method of payment. Microsoft Learn
Technical architect

6Technical

Menu itemPaymentFormatCodeSets_W Checked in Dynamics 365
FormPaymentFormatCodeSets_W Checked in Dynamics 365
TablePaymentFormatCodeSets_WShown as “Payment format code sets” in Record infoKey field: CodeChecked in Dynamics 365
Data entitiesPaymentFormatCodeEntityPayment format code sets Microsoft data model
Who can open itPrivilegesMaintain vendor methods of payment VendPaymModeMaintainView vendor methods of payment VendPaymModeViewDutiesMaintain vendor payments PaymVendorPaymentsMaintainInquire into invoice and payment policies VendInvoiceInvoicePaymentPoliciesInquirEnable invoice and payment process VendInvoiceInvoicePaymentProcessEnable
5 security rolesAuditor AuditPolicyManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounts payable manager VendInvoiceAccountsPayableManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccounting manager LedgerAccountingManagerAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAuditor AuditPolicyManagerGive people one of these roles. On this system, 5 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PaymentFormatCodeSets_W
Integrate withPaymentFormatCodeEntity data entity Microsoft data model
Data migrationPaymentFormatCodeEntity (Payment format code sets): loaded for each company.Microsoft Learn
Table definitionPaymentFormatCodeSets_W columns and relations Microsoft data model
Everyone

8Sources