BeyondERP.Newsletter
Menu

Setup step on the Payment schedules page · Accounts payable

Set up Payment schedules

Set up the payment schedules that are used to manage installment payments to vendors.

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
PaymSched
Main table
PaymSched
Data entity
PaymentScheduleEntity
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 payment schedules, which split an invoice into installments with a number, amount and due date for each installment.
What you do hereUse this page to pay invoices in installments, using allocation methods such as Total, Fixed amount, Fixed quantity or Specified.
ExampleAn invoice of 10,000 USD is paid at 2,000 USD each month until the balance is paid, and it isn't considered past due while scheduled payments are made on time.
Payment schedules 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 schedules1 screen

Set up the payment schedules that are used to manage installment payments to vendors.

  1. Screen 1

    Create the payment schedule

    Go to Accounts payable > Payment setup > Payment schedules

    1. Select New
    2. Enter the code and the description
    3. Set the allocation, the period and the number of payments
    4. Save
    1Payment scheduleBEAT-3M
    2AllocationFixed quantity
    3Payment perMonths
    4Change1
    5Number of payments3
    DescriptionThree monthly installments
    Create the payment schedule (zoomed on the outlined fields)
    Show the full screenCreate the payment schedule
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Accounts payable > Payment setup > Payment schedules.
  2. Choose an Allocation: Total, Fixed amount, Fixed quantity or Specified.
  3. On the General FastTab, in Payment per, choose Days, Months or Years for the interval between installments.
  4. For Fixed amount or Fixed quantity, enter the interval in Change, then the Number of payments or the fixed amount, and a Minimum installment amount.
  5. For Specified, add lines on the Payment lines FastTab with the interval in Quantity and the installment value as a percentage or an amount.
  6. Use Sales tax allocation to spread sales tax across the installments.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
AllocationHow the invoice is split: the whole amount, a fixed amount per payment, a fixed number of payments, or amounts on given dates.Microsoft Learn Fixed quantityPaymBy
Payment perThe interval unit between installment due dates: days, months or years.Microsoft Learn MonthsPeriodUnit
Number of paymentsHow many installments to create when the allocation is Fixed quantity.Microsoft Learn 3NumOfPayment
MinimumThe smallest installment allowed; it overrides calculated amounts.Microsoft Learn LowestAmount
Sales tax allocationHow the sales tax amount is spread across the installments.Microsoft Learn TaxDistribution
Payment schedule3MONTHSName
DescriptionA short description of the payment schedule.Checked in Dynamics 365Three monthly installmentsDescription
ChangeThe number of interval units between the due dates of installments.Microsoft Learn 1QtyUnit

Test checklist

  1. Create a Fixed quantity schedule with 5 payments, Payment per Months, Change 1.
  2. Assign it to a test vendor's invoice.
  3. Post a 10,000 invoice and check five installments of 2,000 with monthly due dates.
  4. Check that the first due date follows the terms of payment.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Payment schedulesWhich allocation should the schedule use?Forgetting that, when a payment schedule is linked to terms of payment, the terms calculate the first installment's due date and the schedule only the later ones; also, the Minimum amount overrides calculated installments.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: The schedule is used when installments are calculated for an invoice, so a change affects invoices calculated afterwards.
Technical architect

6Technical

Menu itemPaymSched Checked in Dynamics 365
FormPaymSched Checked in Dynamics 365
TablePaymSchedShown as “Payment schedule” in Record infoChecked in Dynamics 365
Data entitiesPaymentScheduleEntityPayment schedule Microsoft data model
Who can open itPrivilegesMaintain vendor payment schedules PaymSchedMaintainView vendor payment schedules PaymSchedViewDutiesInquire into vendor payment status PaymVendorPaymentStatusInquireEnable invoice and payment process VendInvoiceInvoicePaymentProcessEnableInquire into invoice and payment process reference data VendInvoiceInvoicePaymntProcessRefDataI
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
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PaymSched
Integrate withPaymentScheduleEntity data entity Microsoft data model
Data migrationPaymentScheduleEntity (Payment schedule): loaded for each company, in Microsoft's default template 120 - Accounts payable.Load order: Microsoft's default template 120 - Accounts payable loads Payment schedule at execution unit 1, level 30, sequence 10. 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 General ledger)Microsoft Learn
Table definitionPaymSched columns and relations Microsoft data model
Everyone

8Sources