BeyondERP.Newsletter
Menu

Setup step on the Cash discounts page · Accounts receivable

Set up Cash discounts

Set up and manage the cash discount codes that are linked to customer and vendor accounts and applied to sales and purchase orders.

Used by
Accounts receivable clerk, Accounts receivable manager, Auditor and 10 more roles
Business process
Establish cash discounting policies in Dynamics 365 Finance
Menu item
CustCashDisc
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 discounts, shared by Accounts payable and Accounts receivable, which are granted when an invoice is paid by the cash discount date.
What you do hereUse it to create cash discount codes with discount percentages and posting accounts, optionally chained through a Next discount code.
ExampleThree codes are chained: 10% if paid within 5 days, then 5% within 10 days, then 2% within 14 days, so only the discount whose date is met applies.
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 cash discount codes that are linked to customer and vendor accounts and applied to sales and purchase orders.

  1. Screen 1

    Create the cash discount

    Go to Accounts receivable > Payments 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 receivable > Payments setup > Cash discounts and select New.
  2. In the Cash discount field, enter an ID.
  3. In the Description field, enter a description.
  4. In the Discount percentage field, enter the discount percentage.
  5. If discounts are tiered, select the Next discount code that applies after this one.
  6. In the Main account for customer discounts field, enter the main account for customer discounts.
  7. In the Discount offset accounts field, choose where vendor discounts post.
  8. In the Main account for vendor discounts field, enter the main account for vendor discounts.
  9. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Cash discountThe ID of the cash discount code.Microsoft Learn 2/10CashDiscCode
Discount percentageThe percentage the customer gets off when paying in time.Microsoft Learn 2.00Percent
Next discount codeLinks discounts into a series, so the next code applies once the earlier discount date has passed.Microsoft Learn CashDiscCodeNext
Main account for customer discountsThe main account that customer cash discounts post to.Microsoft Learn PaidLedgerDimension
Discount offset accountsChooses whether vendor cash discounts post to the accounts on the invoice lines or to the main account for vendor invoices.Microsoft Learn DiscountOffsetMethod_PSN
Main account for vendor discountsThe main account that vendor cash discounts post to.Microsoft Learn ReceivedLedgerDimension
DescriptionA short text that describes the cash discount.Microsoft Learn 2% within 10 daysDescription
DaysThe number of days used to work out the cash discount date, counted as set in the Net/Current field.Microsoft Learn 10NumOfDays

Test checklist

  1. Create 2% within 10 days with a customer discount account.
  2. Invoice a customer who has the code.
  3. Enter a payment within 10 days and mark the invoice.
  4. Check the discount amount and its main account on the voucher.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Cash discountsOne code per discount offer, chained with Next discount code for tiered offers, each with Main account for customer discountsCash discount codes are shared by Accounts receivable and Accounts payable and are taken when the invoice is paid by the cash discount date; a series of codes lets one expire into the next.Expecting the code's Main account for customer discounts to be used when the sales tax code's ledger posting group has a Customer cash discount account: the ledger posting group account wins.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Discounts are calculated when the invoice is posted; changes affect later invoices.
If you change it laterWhen an invoice is paid in time, the discount posts to a main account picked in a set order: an alternative account entered at settlement, then the sales tax ledger posting group, then the account on this page, then Accounts for automatic transactions. Microsoft Learn
Technical architect

6Technical

Menu itemCustCashDisc 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 customer cash discounts CustCashDiscMaintainView customer cash discounts CustCashDiscViewDutiesInquire into collections status CollectionLetterCollectionsStatusInquirInquire into collections policies CollectionLetterCollectPoliciesInquireInquire into invoice and cash policies CustInvoiceInvoiceAndCashPoliciesInquirEnable invoice and cash process CustInvoiceInvoiceAndCashProcessEnableInquire into invoice and cash policies RentalCustInvInvoiceAndCashPolInquirEnable invoice and cash process RentalCustInvoiceInvAndCashProcEnable
13 security rolesAuditor AuditPolicyManagerCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerAccounts 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, 13 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=CustCashDisc
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