Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Payment Schedule Cash Discount Calculation

Posted on by 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

  • David Penna Profile Picture
    David Penna 138 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... 287,914 Super User 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... 287,914 Super User 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?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans