Tax Breakup in PLD

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Pls check the link.

Also,

may be the following will help u as u can placed the tax on the position u want.

If tou want the tax break up , for that you have to mke the formula using the ostt and por4(purchase) and inv4 for invoice pld. table .

Every taxcode has a unique nota fiscal id .Use that in ur PLD .

Ex:

First inser a repetitive area.

Suppose Hcess id is 90 in ostt.

1. Make a text field in repetive area and give 90 to it .

2. make a db field and fetch nota id from ostt.

3. make a formula field and Compare text field and db field .

4. link the test field and db field with formula field .

5. make a db field and fetch taxamount from por4.

6. link this filed also to formula field

7 . make a new formula field and multiple the amount field and previous formula field .

8. make a new formula field in repetitive area footer and do copulmn sum of last formula field which have the result of multiplication.

Same u have to repeat for taxrate .

However u should go for Crystal report for such type of requirement .

Rgds,

Premraj

[Former Member]

thnks

[former_member187989]

Check this thread

Jeyakanthan

[Former Member]

Hi,

Still i am not able to solve this.

[former_member187989]

hi,

Since ur requirement is business critical,

Better create add on for document(customizing tax breakup).

Jeyakanthan

[gagan_thareja]

Dear Swapnil,

Please check the workaround in the attachment that will diaplay tax

breakup but its only possible to show VAT,(BED+CESS) and not BED and

CESS seperately.This will help you to just get an idea, how to do the tax break up.

Hope this will help.

Regards,

Gagan Thareja

SAP Business One Forums Team

[Former Member]

Hi,

As per above recommedation i am able to get Tax amount for respective tax in PLD.

E.X. ColSum("F_243") = 100

Now i want to display the Tax description for respective ColSum like

E.X.

Tax Description.................................ColSum Amount(Tax Amount)

Excise@10%........................................... 100

I tried to get this Tax description from OSTA and this field link to Type column in OSTA and this Type no. is defined in Repetative area as mention in ur above solution.

How to do this ?

swapnil

[Former Member]

hi

It is not solved