Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Payment Schedule Cash ...
Microsoft Dynamics AX (Archived)

Payment Schedule Cash Discount Calculation

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • David Penna Profile Picture
    David Penna 140 on at
    RE: Payment Schedule Cash Discount Calculation
    [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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Payment Schedule Cash Discount Calculation

    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%.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment Schedule Cash Discount Calculation

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment Schedule Cash Discount Calculation

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Payment Schedule Cash Discount Calculation

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans