BeyondERP.Newsletter
Menu

Setup page · Accounts payable

Payment calendar configuration

A setup page for payment calendar rules (Specific, Customer/vendor location or Company location) that select which payment calendar to use, with priorities.

Used by
Accounts payable clerk, Accounts payable manager, Chief financial officer and 6 more roles
Business process
Defining payment policies in Dynamics 365 Finance
Menu item
PaymCalendarRuleVendor
Main table
PaymCalendarRule
Data entity
PaymentCalendarRuleEntity
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 calendar rules (Specific, Customer/vendor location or Company location) that select which payment calendar to use, with priorities.
What you do hereUse this page to choose payment calendars other than those specified by interest codes; due dates can't be adjusted unless a rule is set up here.
ExampleA Specific rule assigns a payment calendar to customers and vendors whose method of payment is CHECK, regardless of terms of payment.
Payment calendar configuration 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 calendar configuration1 screen
  1. Screen 1

    Create the payment calendar rule for vendors

    Go to Accounts payable > Payment setup > Payment calendar configuration, Define rules

    1. On Define rules, select New
    2. Enter Rule name and Description
    3. Turn on Active and set Payment calendar, Method of payment and Terms of payment
    4. Select Save
    1Rule nameBEAT-AP
    DescriptionCash method calendar
    Rule typeSpecific
    ActiveYes
    Payment calendarBEAT-WEEK
    Method of paymentCode, BEAT-CASH
    Terms of paymentAll
    Create the payment calendar rule for vendors (zoomed on the outlined fields)
    Show the full screenCreate the payment calendar rule for vendors
    page title tab to open what to set or check

Steps from Microsoft

  1. Open Payment calendar configuration.
  2. Create a rule and enter a name, a description and a type: Specific, Customer/vendor location or Company location.
  3. Enter the values the rule uses to choose a calendar, such as the method of payment and terms of payment, or the order of addresses to check.
  4. Select Prioritize rules and use Move up or Move down to set the order in which active rules are evaluated.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
TypeHow the rule picks a calendar: by method and terms of payment, by the customer or vendor address, or by the company address.Microsoft Learn
Rule nameThe name of the payment calendar rule.Microsoft Learn NOWEEKENDName
DescriptionA short description of the payment calendar rule.Microsoft Learn Cash method calendarDescription
Rule typeHow the rule picks a calendar: for a method and terms of payment, or by customer, vendor or company location.Microsoft Learn SpecificRuleType
ActiveWhether the rule is active and used when a calendar is chosen.Microsoft Learn YesIsActive
Payment calendarThe payment calendar the rule selects.Microsoft Learn WEEKDAYS
Method of paymentThe method of payment the rule applies to.Microsoft Learn Code, CHECK
Terms of paymentThe terms of payment the rule applies to.Microsoft Learn All

Test checklist

  1. Create a Specific rule for method of payment CHECK and a Company location rule.
  2. Prioritize the Specific rule first.
  3. Post a vendor invoice paid by CHECK with a due date on a holiday of the Specific calendar and check the adjusted date.
  4. Post one with another method of payment and check the company calendar is used.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Payment calendar configurationActive rules for each case (Specific, Customer/vendor location, Company location), ordered with Prioritize rules so the most specific rule is evaluated firstWhen several rules match, the calendar from the highest-priority rule is used, and due dates aren't adjusted unless a rule exists here.Using a location rule when no calendar is valid for the address: the system then selects no payment calendar.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Rules can be changed, reprioritised or deactivated at any time; only active rules are used. Microsoft Learn
If you change it laterWhen more than one rule matches, the calendar from the highest-priority rule is used. Microsoft Learn
Technical architect

6Technical

Menu itemPaymCalendarRuleVendor Checked in Dynamics 365
FormPaymCalendarRules Checked in Dynamics 365
TablePaymCalendarRuleShown as “Payment calendar rule” in Record infoKey field: RecIdChecked in Dynamics 365
Data entitiesPaymentCalendarRuleEntityPayment calendar rule Microsoft data model
Who can open itPrivilegesMaintain vendor payment calendar rules PaymentCalendarRuleMaintainVendorView vendor payment calendar rules PaymentCalendarRuleVendorViewDutiesInquire into vendor payment status PaymVendorPaymentStatusInquireEnable invoice and payment process VendInvoiceInvoicePaymentProcessEnable
9 security rolesChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts 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 clerk VendInvoiceAccountsPayableClerkChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 9 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PaymCalendarRuleVendor
Integrate withPaymentCalendarRuleEntity data entity Microsoft data model
Data migrationPaymentCalendarRuleEntity (Payment calendar rule): loaded for each company, in Microsoft's default template 120 - Accounts payable.Load order: Microsoft's default template 120 - Accounts payable loads Payment calendar rule at execution unit 1, level 120, sequence 30. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Bank)Microsoft Learn
Table definitionPaymCalendarRule columns and relations Microsoft data model
Everyone

8Sources