Tax Breakup in PLD

Dear All,

I require the following tax breakup in PLD

Ex:

Total................................................303743.40.......A

Packing charges.................................2316............B

Excise Duty@10%..............................30606..........C=(AB)10%

ECess@2%..........................................612............D=C*2%

Hcess@1%..........................................306.............E=C*1%

Transportation charges(Freight).............3937.............F

Octroi@3%.......................................10655.............G=((ABCDEF)(ABCDE+F)0.04)3%

Octroi service charges@1%...................107.............H=G*1%

VAT@4...............................................14091...........I= (ABCDEFG+H)*4%

In PLD this is structure which client is expecting for A/R Invoice since this is mandatory for his business practice.

We have created 2 set of tax code for octroi, octroi service charges, vat which are apllicable at line item and freight charges ie transportation charges.

In PLD, Till Hcess it is coming fine but tax after transportation are coming twice since we are applying

octroi_1, octroi service charges_1,VAT_1 at line item and octroi_2, octroi service charges_2 and VAT_2 at freight.

In PLD it shows

octroi_1

octroi service charges_1

VAT_1

octroi_2

octroi service charges_2

VAT_2

Instead we want it to as shown in above example.

Any solution will be highly appreciable..........

swapnil