Skip to main content

Notifications

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

  • 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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans