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 :
Microsoft Dynamics NAV (Archived)

Double discounts on Sales Orders

(0) ShareShare
ReportReport
Posted on by

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
    625 on at
    RE: Double discounts on Sales Orders

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#3
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans