Getting Excise Prod Grooup pf Excah Item from Sales Line

mrigya

Hi All

pLease tell me how can i write the code for getting the Excise Prod. Group for each item in Sales Line Table,
the Excise Prod. group of each item has to be displayed on Sales Header trigger,if Excise Prod. group for Item2 is same as that of Item1 then it should not be displayed.

Best Regards
Mrigya

ssingla

What you want to acheive from this?

mrigya

I want to get the Excise Posting Group for each item,but want it on Sales Header's (Header), and the condition is if any of the Excise posting group is same for more than one item it should be displayed only once.

Regards
Mrigya

ssingla

I have understood that, but what you finally trying to acheive after having the values. The Sales line table have it and that is normally sufficent for reporting and viewing purpose.

mrigya

This is what the Client wants. and he wants it on Sales Header's Header

ssingla

mrigya wrote:

This is what the Client wants. and he wants it on Sales Header's Header

That is not always the reason to customize. This is not the NAV way so convince him to adapt to NAV not make NAV working his way. I know it is not so easy to change but it will be better for him in terms of cost, ease of migration....
The request you has put in will need a subform in the header tab which will need updation on each sales line insert/delete/modification. This can really be a performance killer if the volume is huge.

mrigya

May be you have not undertood what i meant to do..I dont think it has something to do with subform and all..
I did it using 6 variables and its working fine..

Regards
Mrigya

ssingla

Can you tell how you have done it. And also test with 15 items in sales line having 7 or more different Excise Product Posting Group.

mrigya

Re