Export (0) Print
Expand All

Scenario: Use the "Date to use to calculate discounts" field to control discount calculations for vendor payments [AX 2012]

Updated: November 10, 2011

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.

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

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


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft