If you are interested in learning more about cash discounts using Microsoft Dynamics 365 Finance, contact us here to find out how we can help you grow your business. You can also email us at info@loganconsulting.com or call (312) 345-8817.
Understand Cash Discounts with Dynamics 365 Finance
Posted on: August 8, 2022 | By: Guy Logan | Microsoft Dynamics AX/365, Microsoft Dynamics Manufacturing
Cash discounts are incentives given to vendors to get them to pay a bill before it is due. The customer will usually reduce the amount that the vendor owes by either a small percentage or a set dollar amount.
In Microsoft D365 Finance, cash discounts are setup and shared for Accounts payable and Accounts receivable. The cash discount available can be defined on the customer invoice or vendor invoice, and will be taken if the invoice is paid within the cash discount date. Read this blog to learn more about cash discounts and how to use it in Dynamics 365 Finance.
Cash discounts
Cash discounts for both customers and/or vendors can be created in the Cash discounts page. You can also define, by using the Next discount code field, a series of cash discounts that succeed each other as previous cash discount dates expire. For more information, see “Example: Series of cash discounts” later in this article. If the invoice, credit transaction (either a payment or a credit note), or both are entered in a currency other than the accounting currency of the legal entity, the cash discount is calculated using the exchange rate based on the date of the payment or credit note. If the invoice and credit document are entered in different legal entities, and if the accounting currencies for the legal entities differ, the exchange rate is taken from the legal entity of the invoice, as of the date of the credit document. For more information, see “Example: Exchange rates for cash discounts” later in this article.
Defaulting order of cash discount main account
If an invoice is settled in time to obtain a cash discount, the cash discount is automatically posted to a cash discount main account according to the following defaulting priority:
- The main account specified in the Alternative cash discount account field on the customer Settle open transactions page or the vendor Settle open transactions page.
- The main account specified in the Customer cash discount field or the Vendor cash discount field of the ledger posting group that is assigned to the sales tax code of the invoice. Set up ledger posting groups on the Ledger posting groups page and assign them to sales tax codes in the Sales tax codes page.
- The main posting account on the Cash discounts page in either the Main account for customer discounts field or the Main account for vendor discounts field for the cash discount code that is on the settled invoice.
- The main account for cash discounts, as defined in the Accounts for automatic transactions page.
Example: Series of cash discounts
Set up three cash discount codes as follows:
- Code 5D10% – A cash discount of 10% when the amount is paid within 5 days.
- Code 10D5% – A cash discount of 5% when the amount is paid within 10 days.
- Code 14D2% – A cash discount of 2% when the amount is paid within 14 days.
In the Next discount code field:
- For the 5D10% code, select 10D5%.
- For the 10D5% code, select 14D2%.
- For the 14D2% code, leave the Next discount code field blank.
The three cash discounts succeed each other as the payment date exceeds the previous cash discount date on the invoice. Only one cash discount is granted when the invoice is paid, based on which cash discount date is meet in the sequence of cash discounts.
Example: Exchange rates for cash discounts
Your legal entity’s accounting currency is EUR and the following exchange rates are specified for USD:
- February 1 = 110
- March 1 = 80
An invoice for 1000 USD with cash discount terms of 20D2% is posted on February 15. The accounting currency amount of the invoice is 1100 EUR. A payment for 980 USD is settled with the invoice on March 1. The cash discount amount is 20 USD. The accounting currency amount of the payment is 784 EUR. The accounting currency amount of the cash discount is calculated by using the exchange rate as of March 1: 20 * 80 / 100 = 16 EUR.