cancel
Showing results for 
Search instead for 
Did you mean: 

Tax Calculation

Former Member
0 Kudos

Hi All,

I have to calculate VAT on discounted amount. eg. In A/P Invoice i have 'X' amount in total before discount .Now i am giving 2000

discount on 'X' amount .Now i have to calculate vat on discounted amount.How can i solve this ?

My Formula is

"VAT_BaseAmt=TotalBED_TaxAmtCess_TaxAmt+SHECD_TaxAmt

VAT_TaxAmt=VAT_BaseAmt*VAT_Rate"

when i choose Discount in tax formula .Data type of Discount is in Percents.

Regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sandeep,

As per your current formula, the system will automatically calculate the tax on discounted total as you have selected total in formula.

As soon as you put the discount amount the system will calculate new tax amount. So no need to use any discount function in tax code.

Regards,

Abhishek

Former Member
0 Kudos

hi,

thanks for reply.. But i have to calculate taxes after the discount .

with prior formula it will not give the right answer.

Regards

Former Member
0 Kudos

Hi Sandeep,

The system will automatically calculate new tax amount after u enter discount amount. Please check & mentioned whr u are not getting correct calculation. Becuase the same thing I have try & used.

Regards,

Abhishek

Former Member
0 Kudos

Hi ,

My Scenario is like this .. In A/P Invoice I have an item of 300 quantity ,it's unit price is 231.50 ,sap calculate it's total value as 69450. Now vendor gives me discount of 6085.21 Rs. (which is 8.7620%). Now after discount i will get total value 63364.71 . Now I select a CST tax (it's rate is 3.00) it's value is 1900.94.Real problem starts from here , now i have to give another discount sum of 860 so my total value would be 64406.

when i try to give the second discount it will changed all the value . how could i solve this problem .

Regards

Former Member
0 Kudos

Add a UDF called 'Discount 2' in row level of marketing documents.

Write a FMS in 'Total' as '(Rate * Qty) - (Discount + Discount2)'

Now Tax would be computed on this Total.

Former Member
0 Kudos

Hi,

I want to define the cost center for the expenses like Salary, Telephone, Travelling. Please help me how to define the cost center

Thanks in advance.

Regards

Jai

Answers (0)