problem with the standard Excise Invoice (16593).

Hi all,

i am facing a problem with the standard Excise Invoice (16593).
According to my requirement i need to create a Sales Order having 10 items but at the time of dispatching(posting) the items we can dispatch say only 1 or 2 or 3 or up to 10 items.
So, if we wish to post only 1 item then we change “Qty. to Ship” and “Qty to Invoice” as 0 for rest of 9 items and we post it. And to show only those on the report report having Qty>0
i am using code under section trigger


In the report LineAmt, ExciseAmt, CSTVATAMT is getting calculated perfectly but eCess and SHECess is wrong.
Actually Report is calculating eCess and SHECess for all 10 items.

There is no problem if i post all ten items.
How can we we restrict the report to calculate eCess and SHECess for only those items having quantity >0, i have tried SETFILTER but didn’t worked.


Did you ever find a solution to this problem? If yes, would you mind sharing it with us?