BeyondERP.Newsletter
Menu

Setup step on the Payment schedules page · Accounts receivable

Set up Payment schedules

Create the payment schedules used to plan installment payments from customers.

Used by
Accounts receivable clerk, Accounts receivable manager, Auditor and 12 more roles
Business process
Define customer payment processes in Dynamics 365 Finance
Menu item
CustPaymSched
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 payment of an invoice into installments over set time intervals.
What you do hereUse it to define the number, amount and due dates of installments using the Total, Fixed amount, Fixed quantity or Specified allocation methods; the setup is shared with Accounts payable.
ExampleA customer invoiced USD 6,000.00 pays USD 2,000.00 each month, and the invoice is not considered past due while the 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

Create the payment schedules used to plan installment payments from customers.

  1. Screen 1

    Create the payment schedule

    Go to Accounts receivable > Payments 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 receivable > Payments setup > Payment schedules.
  2. Select the Allocation: Total, Fixed amount, Fixed quantity or Specified.
  3. On the General FastTab, in the Payment per list, select Days, Months or Years.
  4. In the Sales tax allocation list, choose how sales tax is spread over the installments.
  5. For Specified, on the Payment lines FastTab, enter each installment's interval in the Quantity field and its value in the Amount in transaction currency field.
  6. In the Percentage/Amount list, choose whether each value is a percent or an amount.
  7. For Fixed amount or Fixed quantity, enter the Change, then the Number of payments or the fixed amount.
  8. In the Minimum field, enter the smallest installment amount.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
AllocationHow the amount is split: the total, a fixed amount, a fixed number of payments, or amounts you specify.Microsoft Learn Fixed quantityPaymBy
Payment perThe interval between installments in days, months or years, used to calculate each due date.Microsoft Learn MonthsPeriodUnit
Sales tax allocationHow sales tax is spread across the installments.Microsoft Learn TaxDistribution
ChangeThe number of interval units between the due dates of installments.Microsoft Learn 1QtyUnit
Number of paymentsThe fixed number of installments when the allocation is Fixed quantity.Microsoft Learn 3NumOfPayment
MinimumThe smallest installment amount; it overrides calculated amounts.Microsoft Learn LowestAmount
Percentage/AmountWhether each installment value is a percent of the invoice or an absolute amount.Microsoft Learn
Payment scheduleThe code that identifies the payment schedule.Microsoft Learn 3MONTHSName
DescriptionA short text that describes the payment schedule.Microsoft Learn Three monthly installmentsDescription

Test checklist

  1. Create a schedule with Allocation Fixed quantity, Number of payments 3, Payment per Months and Change 1.
  2. Attach it to terms of payment and post a 6,000 invoice.
  3. Check three instalments of 2,000 with monthly due dates on the customer transactions.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Payment schedulesFixed quantity for equal instalments, Fixed amount for a set amount per instalment, and Specified with Payment lines when instalments differ.The Allocation method decides how the invoice is split, and Payment per with Change sets the interval between due dates.Setting a Minimum without noticing it overrides the calculated instalment amounts, which changes the number of instalments. The setup is also shared with Accounts payable.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Schedules can be changed at any time; they affect invoices that use them afterwards, for customers and vendors in the legal entity.
If you change it laterPayment schedules are shared by Accounts receivable and Accounts payable in the same legal entity, so a change here also affects vendor installments. Microsoft Learn
Technical architect

6Technical

Menu itemCustPaymSched 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 customer payment schedules CustPaymSchedMaintainView customer payment schedules CustPaymSchedViewDutiesInquire into collections status CollectionLetterCollectionsStatusInquirInquire into customer invoice status CustInvoiceCustomerInvoiceStatusInquireEnable invoice and cash process CustInvoiceInvoiceAndCashProcessEnableReview invoice and cash process performance CustInvoiceInvoiceAndCashProcPerfReviewInquire into invoice and cash reference data CustInvoiceInvoiceAndCashRefDataInquireInquire into customer payments status PaymCustomerPaymentsStatusInquireEnable invoice and cash process RentalCustInvoiceInvAndCashProcEnable
15 security rolesAuditor AuditPolicyManagerCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRental manager RentalManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerRental coordinator agent RentalCoordinatorAgentCollections manager CollectionLetterCollectionsManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 15 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustPaymSched
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