Skip to Content
0
Apr 24, 2009 at 10:30 AM

Tax Calculation

543 Views

Hi All,

I am having a complex scenario in tax calculation, can anybody help me on how to deal with this situation.

One of my client is involved in chemical manufacturing where they buy all the raw materials from different vendors who are manufacturers and distributors. when they issue an invoice on the name of my client ( this will be A/P Invoice for my client) it contains several componenets in the Tax Section.

Currently SAP B1 calculates the Excise duty in the following way.

1. Excise duty is calculated based on the percentage on the total. i.e. if the document total is 100, then Excise duty is calucated first, secondly on the excise total Cess component is calculated.

2. This Excise + Cess componets will be added to the total of the document to calculate the VAT tax Later. Then automatically the total will be displayed with the tax added to it.

What is my client is needed is: Before calculating the VAT they would like to add one more component to the total of the document (this is after calculating the BED component and added to the total of the document ) then on the final figure VAT will be calculated.

How this will be possible either with one tax code or by adding another column in the row level of the document and consider that amount for calculating the final tax amount?

Thanks

SV Reddy