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

Announcements

No record found.

News and Announcements icon
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
    303,706 Super User 2026 Season 1 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 659

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 465 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 304 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans