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 :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Double discounts on Sa...
Microsoft Dynamics NAV (Archived)

Double discounts on Sales Orders

(0) ShareShare
ReportReport
Posted on by Community Member

In Dynamics NAV 2009 there is the functionality off the Customer Card to put in Sales Prices for certain items. (Customer card > Sales button > Prices) If we put in a sales price for an item on that customer my thought was that if we uncheck the column for Allow Line Disc. this should not allow any line discounts on the Sales Orders when this item is used for this customer. But even if the column is unchecked we can still put in a line discount on the order and this discounts the customer twice when the invoice is posted. Is this function suppose to prevent line discounts when there's already a sales price discount so that the customer doesn't get discounted twice?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    The Simpsoid Profile Picture
    The Simpsoid 625 on at

    I can confirm it still behaves in the same way in NAV 2013 R2.  The system won't *automatically* apply any discount when Allow Line Disc. is unchecked but it does nothing to prevent the user from adding it themselves either by keying a percentage or a discount amount.  I've modified table 37 so that a new function is called at the top of the OnValidate events for both Line Discount % and Line Discount Amount columns:

    CheckForUnexpectedLineDiscount() Continue : Boolean
Ok := TRUE;
IF ("Line Discount %" <> 0) AND ("Allow Line Disc." = FALSE) THEN BEGIN
  Ok := CONFIRM(UnexpectedLineDiscWarningText);
  IF Ok = FALSE THEN BEGIN
    "Line Discount %" := xRec."Line Discount %";
    "Line Discount Amount" := xRec."Line Discount Amount";
  END;
END;
EXIT(Ok);

    If the user cancels, this puts it back to what it was previously rather than forcing it to zero because my users said there might be a reason for there to be a small discount but they'd still want to be warned every time they try to change it.

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!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans