web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

wrong Cash Discount Dates on Payment Schedule invoices

(0) ShareShare
ReportReport
Posted on by 140

Hi, we are in D365 2020 release wave 2, trying to setup Cash Discounts on a Payment Schedule (to be calculated when the invoice is posted).  Previously I tried to have the Cash Discount calculate on the total payment amount, but could only get it to calculate on the individual Schedule amounts.  Now I am ok with it calculating on the individual Schedule amounts, but the Cash Discount Dates are wrong for the 2nd & 3rd Schedules.  This is how I tried to set up a 3% Cash Discount on 30/60/90 Schedules, or 3%30 / 3%60 / 3%90:

Terms of Payment: Payment method Net, Days 30, Payment schedule 306090.

Payment Schedule 306090: Allocation Fixed quantity, Payment per Days, Change 30, Number of payments 3.

All of the above works fine for straight 30/60/90 billing.  Now to add a 3% discount to EACH schedule, at time of sales order entry I select the "first" Cash Discount 3%30.  Here is how I set those up:

Cash Discount 3%30: Days 30, Discount percentage 3, Next discount code 3%60

Cash Discount 3%60: Days 60, Discount percentage 3, Next discount code 3%90

Cash Discount 3%90: Days 90, Discount percentage 3.

The Payment Schedules' Due Dates are correct, but the Cash Discount Dates aren't:

Due Date 4/2/2021 - Cash Discount Date 4/2/2021
Due Date 5/2/2021 - Cash Discount Date 4/2/2021
Due Date 6/1/2021 - Cash Discount Date 5/2/2021

So the Cash Discount Dates for the 2nd & 3rd Schedules are 30 days too early.

I have the same question (0)
  • MATTGUO Profile Picture
    22,349 Moderator on at
    RE: wrong Cash Discount Dates on Payment Schedule invoices

    Hi,

    Same case with you, it seems to be a bug. Please create a support ticket in LCS.

    You can use the alternative way to select the current week in the cash discount setup. The cash discount date will be closer.

  • David Penna Profile Picture
    140 on at
    RE: wrong Cash Discount Dates on Payment Schedule invoices
    [quote user="MATTGUO"]

    Hi,

    Same case with you, it seems to be a bug. Please create a support ticket in LCS.

    You can use the alternative way to select the current week in the cash discount setup. The cash discount date will be closer.

    [/quote]

    MATTGUO Thanks for your response, I let our developers know in case they can create a support ticket.

    As for your other suggestion, I tried the Cash Discount Setup with Discount Principle's Net/Current set to Current Week and you were right, the Discount Dates were just two days later than correct (which would be same as  regular Due Dates).  In that instance, the Days was still set to 30... so for the heck of it I tried it with Net/Current still at Current Week but Days set to 28.  The result was exactly the same as when Net/Current was Net and Days 30: Discount Date for 2nd Schedule same as 1st, Discount Date for 3rd Schedule is what it should be for 2nd.  So do you know how Cash Discounts Setup implements the Days value?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 783

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 715 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 519 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans