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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Sales Order Item discount percentage calculated but not reported in EndDisc value in report output

(1) ShareShare
ReportReport
Posted on by 197
Hello,
 
Our sales teams want to do ad-hoc discounts on line items. They don't seem to want to do a set discount for certain items or customers, so maybe I don't need to set up trade agreement pricing policies etc?
 
I'm making sure the Sales Order Confirmatino shows the discounts properly.  We use Docentric for this report.
 
When I run the Sales Order confirmation with a line set up with a line discount like so:
Or in text in case the image is too small:
 
Item number  Description Ship date    Quantity Unit  Sales price  Amount
#######       BLAHBLAH   4/26/2024 100.0000  ea    5.5970       531.72
 
The EndDisc field from the Sales Invoice is not being populated with the final discount amount, in this case I'm expecting to see and EndDisc amount of 27.985.
 
Is there a simple way to do this without programming an extension to the relevant funcitons in the system?
In the totals command I see:
(there are more lines than I showed in my image above.)
So we can see the line discount is 27.98.
 
Do I have this correct, as in EndDisc (Total discount) should reflect the sum of line discount amounts?
Or should I be looking for a sum of the line discounts somewhere?
 
Any insights on this would be great!
Thanks again.
I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    300,904 Super User 2025 Season 2 on at
    Hi jt1024,
     
    The Total discount (EndDisc) is a different discount type. That is a discount based on the total value of the invoice. In your case, you have a line discount. The EndDisc field is not filled with the total of all discounts on the lines.
  • jt1024 Profile Picture
    197 on at
    Hello Andre,
     
    Excellent thanks for straightening me out. My manager also pointed out the same.
     
    Thanks again!
    - Jim

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 663 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 348 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans