Scenario: Use the "Date to use to calculate discounts" field to control discount calculations for vendor payments
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
You can take a cash discount that is based on a date other than the transaction date of the payment. You can do this by using the Date to use for calculating discounts field in the Settle open transactions form. This field is available only if you open the form from a list page, or from a form that opens when you double-click a record on a list page. For more information, see Settle open transactions - vendor (form).
On June 28, April creates an invoice for 2,000.00 for vendor 3052. The invoice has a cash discount of 1 percent if the invoice is paid in 14 days.
Payment for 500.00 on July 15 and Date to use for calculating discounts = Transaction date
April creates a payment for 500.00 on July 15, which is after the discount date. April opens the Settle open transactions form to view the transactions that can be settled. (Click Accounts payable > Common > Vendors > All vendors. On the Action Pane, click Invoice, and then click Settle open transactions.)
April marks the two transactions, and then selects the payment line. She does not see any information about cash discounts, because the cash discount is shown when the invoice line is selected.
April selects the invoice line. She now sees the information about cash discounts. The default setting for the Date to use for calculating discounts field is Transaction date. No cash discount is taken, because the payment is after the discount date.
Mark |
Use cash discount |
Voucher |
Account |
Date |
Due date |
Invoice |
Amount in transaction currency |
Currency |
Amount to settle |
|---|---|---|---|---|---|---|---|---|---|
Selected and highlighted |
Normal |
Inv-10030 |
3052 |
6/28/2015 |
7/12/2015 |
10030 |
-2,000.00 |
USD |
-1,980.00 |
Selected |
Normal |
APP-10030 |
3052 |
7/15/2015 |
7/15/2015 |
500.00 |
USD |
Discount information is shown at the bottom of the Settle open transactions form.
Cash discount date |
7/12/2015 |
Cash discount amount |
0.00 |
Use cash discount |
Normal |
Cash discount taken |
0.00 |
Cash discount amount to take |
0.00 |
Payment for 500.00 on July 15 and Date to use for calculating discounts = Selected date
In the Settle open transactions form, April changes the value in the Date to use for calculating discounts field to Selected date. She enters a date of July 10, which is in the discount period for the invoice. That date is used to calculate a cash discount for the transaction. In the Settle open transactions form, April sees that, by default, the full discount of 20.00 is displayed. The invoice line shows that the amount to settle is 1,980.00.
Mark |
Use cash discount |
Voucher |
Account |
Date |
Due date |
Invoice |
Amount in transaction currency |
Currency |
Amount to settle |
|---|---|---|---|---|---|---|---|---|---|
Selected and highlighted |
Normal |
Inv-10030 |
3052 |
6/28/2015 |
7/12/2015 |
10030 |
-2,000.00 |
USD |
-1,980.00 |
Selected |
Normal |
APP-10030 |
3052 |
7/15/2015 |
7/15/2015 |
500.00 |
USD |
500.00 |
Discount information is shown at the bottom of the Settle open transactions form. The discount amount to take is 20.00, because the amount to settle for the invoice is the default amount, 1,980.00.
Cash discount date |
7/12/2015 |
Cash discount amount |
-20.00 |
Use cash discount |
Normal |
Cash discount taken |
0.00 |
Cash discount amount to take |
-20.00 |
April updates the value in the Amount to settle field to 500.00. The value in the Cash discount amount to take field is calculated as 5.05.
Mark |
Use cash discount |
Voucher |
Account |
Date |
Due date |
Invoice |
Amount in transaction currency |
Currency |
Amount to settle |
|---|---|---|---|---|---|---|---|---|---|
Selected and highlighted |
Normal |
Inv-10030 |
3052 |
6/28/2015 |
7/12/2015 |
10030 |
2,000.00 |
USD |
-500.00 |
Selected |
Normal |
APP-10030 |
3052 |
7/15/2015 |
7/15/2015 |
500.00 |
USD |
500.00 |
Discount information is shown at the bottom of the Settle open transactions form. The value in the Cash discount amount to take field is 5.05, because the amount to settle for the invoice was changed to the payment amount, 500.00.
Cash discount date |
7/12/2015 |
Cash discount amount |
-20.00 |
Use cash discount |
Normal |
Cash discount taken |
0.00 |
Cash discount amount to take |
-5.05 |
See also
Scenario: Settle a vendor payment with an invoice
Scenario: Settle vendor payments by using payment proposals
Scenario: Settle a partial vendor payment that has multiple discount periods
Scenario: Settle a partial vendor payment that has discounts on vendor credit notes
Scenario: Take a discount that is more than the calculated discount for a vendor payment