Line Discount % in Sales Order Lines

Maddynav123 · 2018-05-02

Hello,

Please can anyone help me how is called the Line Discount % field in Sales Order Lines? Where I can see this in C/AL?

What I want to do is that in table 7004 Sales Line Discount, I should be able to setup discount based on Item Category.

So When I create a new Sales Order and when I choose the Item for which i setup the Sales Line Discount I want to get the Line Discount % based on Type: Item Category.

Thank you.

ErictP · 2018-05-03

Then you must add the field "Item Category Code" to table 7002 "Sales Price".
Add this field to the key's.

Add the new field to the parameters in Codeunit 7000 "Sales Price Calc. Mgt." by function "FindSalesPrice".
Change the code to set a filter if the new parameter is filled.

Add this parameter to all the functions where the FindSalesPrice is called.

ErictP · 2018-05-03

Why don't you use the 'Item Disc. Group'?

Maddynav123 · 2018-05-03

No, I should change the functionality with "Item Category".

ErictP · 2018-05-03

Then you must add the field "Item Category Code" to table 7002 "Sales Price".
Add this field to the key's.

Add the new field to the parameters in Codeunit 7000 "Sales Price Calc. Mgt." by function "FindSalesPrice".
Change the code to set a filter if the new parameter is filled.

Add this parameter to all the functions where the FindSalesPrice is called.

Maddynav123 · 2018-05-08

@ErictP thank you. It works.

kriki · 2018-05-23

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

Rainer · 2021-11-30

Thats a very bad soloution to change a primary key, actually it destroys all the standard code.

Line Discount % in Sales Order Lines

Best Answer

Answers

Categories