BeyondERP.Newsletter
Menu

Setup step on the Cash discounts page · Accounts payable

Set up Cash discounts

Set up and manage the terms for obtaining cash discounts; the codes are linked to vendors and applied to purchase orders.

Used by
Accounts payable manager, Auditor, Accounting manager and 1 more role
Business process
Define cash discounting policies in Dynamics 365 Finance
Menu item
CashDisc
Main table
CashDisc
Data entity
CashDiscountEntity
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 cash discount codes that define the discount obtained when vendor invoices are paid within a set number of days.
What you do hereUse this page to set up discount codes, optionally chained through a next discount code, that can be assigned to vendors, journals or purchase orders.
ExampleUSMF sets up 5D10%, 10D5% and 14D2% codes so that a 10, 5 or 2 percent discount applies when it pays within 5, 10 or 14 days; only one discount is granted.
Cash discounts 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 Cash discounts1 screen

Set up and manage the terms for obtaining cash discounts; the codes are linked to vendors and applied to purchase orders.

  1. Screen 1

    Create the cash discount

    Go to Accounts payable > Payment setup > Cash discounts

    1. Select New
    2. Enter the code and the description
    3. Set the number of days and the discount percentage
    4. Fill the main accounts for customer and vendor discounts, then save
    1Cash discountBEAT-2/10
    2Days10
    3Discount percentage2.00
    Description2% within 10 days
    Create the cash discount (zoomed on the outlined fields)
    Show the full screenCreate the cash discount
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Accounts payable > Payment setup > Cash discounts.
  2. Select New.
  3. In the Cash discount field, enter an ID, and add a description.
  4. If the vendor offers tiered discounts, select the next cash discount to use when this one expires.
  5. In the Days field, enter the number of days used to calculate the cash discount date.
  6. Enter the discount percentage in the Discount field.
  7. Enter the main accounts for customer and vendor cash discounts.
  8. Save the record.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
DaysThe number of days used to work out the cash discount date, counted as set in the Net/Current field.Microsoft Learn 10NumOfDays
DiscountThe cash discount percentage.Microsoft Learn
Next discount codeThe discount that applies after this one expires, for tiered discounts.Microsoft Learn CashDiscCodeNext
Discount offset accountsWhether the vendor discount posts to the main account or to the accounts on the invoice lines.Microsoft Learn DiscountOffsetMethod_PSN
Cash discountThe ID of the cash discount code.Microsoft Learn 2/10CashDiscCode
DescriptionA short description of the cash discount.Checked in Dynamics 3652% within 10 daysDescription
Discount percentageThe percentage of the invoice amount that is taken off if paid in time.Microsoft Learn 2.00Percent

Test checklist

  1. Create 2% within 14 days with a vendor discount main account.
  2. Set it on a vendor and post an invoice.
  3. Pay within 14 days via a payment journal with the invoice marked.
  4. Check the discount is taken and posted to the expected account.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Cash discountsOne code per discount offer (for example 2% within 14 days), chained with Next discount code for tiered offers, and Cash-discount administration set in Accounts payable parameters before the first settlementCodes in a series succeed each other as cash discount dates expire, and only one discount is granted. Learn says Cash-discount administration must be set correctly before an invoice is settled.Not knowing which account the discount posts to: an alternative account on Settle transactions wins, then the Vendor cash discount account on the sales tax code's ledger posting group, then the code's main account, then Accounts for automatic transactions.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Cash discount dates and amounts are calculated when the invoice is posted, so a changed code affects later invoices only.
Technical architect

6Technical

Menu itemCashDisc Checked in Dynamics 365
FormCashDisc Checked in Dynamics 365
TableCashDiscShown as “Cash discount” in Record infoChecked in Dynamics 365
Data entitiesCashDiscountEntityCash discount Microsoft data model CredManCashDiscRankEntityRanking of cash discounts Microsoft data model
Who can open itPrivilegesMaintain vendor cash discounts CashDiscMaintainView vendor cash discounts CashDiscViewDutiesInquire into invoice and payment policies VendInvoiceInvoicePaymentPoliciesInquirEnable invoice and payment process VendInvoiceInvoicePaymentProcessEnable
4 security rolesAuditor AuditPolicyManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorAccounts 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 LedgerAccountingManagerAuditor AuditPolicyManagerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the pageButtons: TranslationsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CashDisc
Integrate withCashDiscountEntity data entity Microsoft data model
Data migrationCashDiscountEntity (Cash discount): loaded for each company, in Microsoft's default template 120 - Accounts payable.CredManCashDiscRankEntity (Ranking of cash discounts): loaded for each company.Load order: Microsoft's default template 120 - Accounts payable loads Cash discount 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 definitionCashDisc columns and relations Microsoft data model
Everyone

8Sources