Payment Schedule Cash Discount Calculation

(0) Share

Report

Posted on by Community Member

I am trying to calculate a cash discount on an invoice that has a payment schedule, but I would like the calculation to be based on the entire amount of all invoices in the schedule. I currently only see a discount being calculated on the final payment.

I am using a payment schedule for a total of 90 days, broken down into three equal payments and a cash discount of 0% for the first 60 days, with a "next" cash discount of 2% for the following 30 days.

Is there a way to have the cash discount calculation based on the total payment amount rather than just the final invoice of the schedule

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi Stennant,

Can you tell us which version of AX you are using? Was the payment schedule directly applied when posting the invoice or was this schedule created afterwards?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is in AX 2012 R2 CU6. The schedule was directly applied when posting the invoice.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Any new on this? Apparently when there is a Cash discount set on the transaction at the time of posting, the Transaction reorganising option seems to be disabled in the settle open transaction form. It seems Ax doesn't want payment schedule to be created if there is a cash discount term on the transaction.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi Stennant,

Due to very busy days I'm not able to retest. Can you review the cash discount settings? When setting up multiple iterations, you have to start with the smallest number of days. Usually this is the highest discount.

So first 3% within 8 days, then 2% within 30 days en then next 0% within 60 days. The latest is not really needed as after the last step, no discount setting is found and thus 0%.

Was this reply helpful? Yes No
David Penna 140 on at

Like (0)

Report

[quote user="stennant"]
I am trying to calculate a cash discount on an invoice that has a payment schedule, but I would like the calculation to be based on the entire amount of all invoices in the schedule. I currently only see a discount being calculated on the final payment.

I am using a payment schedule for a total of 90 days, broken down into three equal payments and a cash discount of 0% for the first 60 days, with a "next" cash discount of 2% for the following 30 days.

Is there a way to have the cash discount calculation based on the total payment amount rather than just the final invoice of the schedule
[/quote]
Hi, did you ever find a solution to this? I would also like to setup a Cash Discount on the total of all Payment Schedules of an invoice, rather than one Discount pon each Schedule. It seems as soon as you post an invoice with both features, D365 forces Discounts onto all Schedules. I have also tried setting up 0% Discounts as the Next Discount Codes after the first, but it seems that feature doesn't apply on Schedule invoices.

Was this reply helpful? Yes No