cancel
Showing results for 
Search instead for 
Did you mean: 

Tax

Former Member
0 Kudos
44

In PLD's the Tax column's amount is not displaying (here I have took a link as service tax @12% or CST @ 2% or VAT @2% whatever the Tax code it may be,tax total is tax total is displaying accurately but separate tax amount is not displaying in the rows it is displaying as INR 0=00 )

pls help me

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

In SAP you have Table OSTT. In this table all the tax codes are stored. For each Tax code, there will be related Nota Fiscal Id and Numerator.

In PLD, Add repetitive area and in Repetitive area

1. Create 1 text field and enter the number (Nota Fiscal Tax ID or Numerator)

Note : If you are calculating excise duty or service tax or Vat then you will be entering Nota fiscal Tax ID else you will be entering Numerator Number in the Text field you have created.

Let's Assume Field_001 (ex. Field_001 --> -90 or 6)

2. Create 1 database field, in that link the "Sales Tax Authorities Type" table and "Nota Fiscal Tax ID" or "Numerator"

let's assume Field_002

3. Create one Formula Field, In that Check whether the two fields are equal.

let's assume Field_003 contains formula (ie., Field_001==Field_002)

4. Create one Database field, In that link "A/R - tax Amount per Document" table and "Tax Amount" Column.

let's assume Field_004

5. Create one Formula Field, in that multiply two fields

let's assume Field_005 = Field_003 * Field_004.

6. Then in Repetitive area Footer, Create one formula field, and in that Sum that result.

Let's assume Filed_006 = COLSUM("Field_005")

Do the above said process to retrieve seperate tax amount values.

To print Tax rate :

In repetitive area footer, create one database field, and now choose A/R Invoice or corresponding table and Tax Rate column.

Let's Assume, that in repetitive area footer Field_101 has the above database table link.

Now, Create one Text Field and enter "VAT" and then next to text field create Formula Field and Choose the Field_101 in the Formula column.

I hope this could help you to solve your problem.

Regards

Raja.S

Answers (0)