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, ...
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
    299,704 Super User 2025 Season 2 on at
    Sales Order Item discount percentage calculated but not reported in EndDisc value in report output
    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
    Sales Order Item discount percentage calculated but not reported in EndDisc value in report output
    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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 753

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 534 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans