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 and settle the final payment in full before the discount date

Scenario: Settle a partial vendor payment before the discount date with a final payment after the discount date

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