Line Discount % in Sales Order Lines

Maddynav123

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

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

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

Maddynav123

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

ErictP

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

@ErictP thank you. It works.

kriki

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

Rainer

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