Skip to Content
0
Former Member
Feb 25, 2009 at 06:16 PM

Tax Calculation on Base amount in FB60

1511 Views

Dear All,

My client wants to calculate tax on base amount in FB60,

he receives invoice from vendor with 6 items(i.e., 6 different types of expenses gl)

and in that invoice he get the total tax amount not individual tax amount, here is the example :

item 1 - 1402.50

item 2 - 855.50

item 3 - 3780.00

Sub total - 6038.00

Tax 19% - 1147.22 (tax amount for above 3 items)

Total - 7185.22

In FB60 the system is calculating the tax on net value i.e., we have to enter the total amount (7185.22) in header level and line item we have to enter the amount including the tax value

item 1 - 1668.98 (1402.50 x 19%) - user calculating the tax manually and entering the same.

item 2 - 1078.05 (855.50x 19%) - - user calculating the tax manually and entering the same

item 3 - 4498.20 (3780 x 19%) - - user calculating the tax manually and entering the same

he is getting this type of invoices more and he dont want to do calculation for each and every item

Please advice on this issue as early as possible.

Thanks in advance

Regards

JS