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 :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Rounding Issue using Line Discounts

(0) ShareShare
ReportReport
Posted on by

Hello, 

We are running into an issue with our Sales Order Net Amounts being off by .01. We are currently utilizing Trade Agreement Journals for Line Discounts to offer standard extended prices to our customers, but it appears that when a customer orders more than 1 of an item, the system takes the Unit Price * Qty then Subtracts the Discount amount. We need to take the Unit Price - Discount Amount THEN * qty. 

Example

Unit Price: 23.99

Line Discount: 17%

 

If a customer orders qty 5, the price in the net amount is 99.56, and the customer is expecting it to be 99.55. Because they receive 17% off these items, their extended price for this item is 23.99 - 4.08 (17%) = 19.91, so *5 is 99.55

The system is taking the base price of 23.99, multiplying it by the qty, 5, then calculating and subtracting the discount which equals to 99.56 in the Net Amount of the Sales Order 

Any help would be very appreciated. 

Thanks,

Kailey 

I have the same question (2)
  • Suggested answer
    meelamri Profile Picture
    13,218 User Group Leader on at

    Hi,

    Please refer to this blog:

    community.dynamics.com/.../choose-your-best-rounding-policy-in-ms-dynamics-crm-pricing-method

    It explains how you can configure the rounding policy.

  • Community Member Profile Picture
    on at

    Thank you! This is so helpful, but it is talking about CRM. How would i configure this for D365 F&O?

    Thanks,

    Kailey

  • Community Member Profile Picture
    on at

    We need to apply the discount to the Unit price and then multiply by the Sales Quantity. How can we achieve this?

    Thanks,

    Kailey

  • CU27040842-8 Profile Picture
    4 on at
    RE: Rounding Issue using Line Discounts
    Was a solution to this found? We're having a similar issue where the unit price is four decimal places after the discount is applied but the line shows a rounded value so the sales line amount looks incorrect after the quantity multiplication.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 71 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 66 Super User 2026 Season 1

#3
ManoVerse Profile Picture

ManoVerse 51 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans