Tax Break Up in pld

[Former Member]

Hi All,

I am not able to get tax break up in pld. I have read a few documents and tried to get tax break up but it works fine only for one row . If there are more than one items, the data gets repeated. can anyone please guide me how to correct this error?

Thanks,

Joseph

[former_member206488 · Accepted solution]

Hi joseph,

Cehck below thread:

or check https://websmp201.sap-ag.de/~sapdownload/011000358700004326202006E/HowToTaxBreakup_2004_2B_IN.pdf

Thanks,

Neetu

[Former Member · Accepted solution]

HI Neetu,

i tried as suggested i the thread and the data is not repeating anymore. However, the problem that i am facing now is that if there are 3 items in the PO, then the excise amount is getting divided by 3 and the CST amount is getting multiplied by 3 . Please guide.

I have created following in repetitive area;

a. Text field--> -90

b. Database field--> Ostt --> Numerator

c. Formula field--> a==b

I have linked the field a and b to c

d. Database field> POR4> tax amount

I have liked this field to c

e. Formula field--> c X d

In end of report, i have created formula field --> colsum of e

I havent linked this field to any of the fields.. The out put so far is correct if there is only one line item, if there are more than oe item in the purchase order, the excise amount is getting multiplied and cst/vat amount is getting divided by the the number of items. Please guide me what am i doing wrong??

Thanks,

Joseph

Edited by: Joseph Antony on Sep 21, 2010 12:17 PM

[former_member206488 · Accepted solution]

Hi Joseph,

Try as below:

select * from CRD7

a. Text field--> -90

b. Database field--> Ostt --> Numerator

c. Formula field--> a==b

d. Database field> POR4> tax amount

e: Formula Field: c *d

then in repetative area footer add formula filed : colsum(e)

Thanks,

Neetu

[Former Member · Accepted solution]

HI Neetu,

I have tried using another option which is as mentioned below;

Added a new repetitive area--> In Repetitive Area, I created the following fields;

a. Database field (INV4)=Tax amount

b. Databse Field (INV4)= Tax Rate

c. Database Field (INV4) = sta Type

d. Formula Field ---> c==-90

In the footer field, I created the following fields;

e. Text field--> Excise duty@ and linked this field to d.

f. Formula field--> Colsum of a and linked this field to d.

g. Formula field--> b

This is not giving any result but when i copy the field f to page footer and click on print preview, i get an error message whic says; "Field is not calculated- field f".

Thanks,

Joseph

[kvbalakumar · Accepted solution]

Hi Joseph,

Neetu's solution will work fine. Why won't to try that?

Link to and relate field won't work like -> Sum (tax amount) group by numerator.

You need to create separate formula fields for each type.

Neetu has given for BED type only. If you need others then you have to change the -90 as -55 (HCess), -60 (Cess), 1 (VAT), 4 (CST), ... etc.

Regards,

Bala

[Former Member · Accepted solution]

Hi Bala,

I do't know why but I am unable to get this break up in PLD. I must be missing something. Will get this with a work around. Create udf's and get tax amount through FMS.

Thanks,

Joseph

[msundararaja_perumal]

Hi,

If you are trying to achieve in SAP 8.8 version,

Kindly go through this document [HowTo_TaxBreakd_88_India|https://websmop101.sap-ag.de/~sapdownload/011000358700000806792009E/HowTo_TaxBreakd_88_India.pdf] might be helpful in resolving your repetition issue.

[bhavank_gajjar]

Hi Jospeh,

For which PLD you want tax breakup?

Regards,

Bhavank

[Former Member]

Hi Bhavank,

I'm trying to get it for purchase order. This is what I have done so far;

a. Created a database table> por4> tax amount (Say F-01)

b. Created a database table > por4> tax rate (say F-02)

c. created a database table> por4> staType (say F-03)

d. Created a formula field --> F-03==-90

I created the fields mentioned above in the repetitive area. In the Repetitive area footer, I created the following fields;

e. Created a text field--> Excise and linked this to D

f. Create a formula field as colsum of A

g Created a formula field where just selected B in the formula.

This reulsts in tax break up but works well only for one item. If there are more items, the data is getting duplicated.

Thanks,

Joseph