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 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.
Sohail Ahmed
2
mmv
2
Amol Salvi
2