TAX Calculation as per child items for fininsh goods in sale bill.

35 Views

hi team,

here i am implementing SAP business one in construction company :

SCENARIO:

TEMPLATE BOM= FG=ABC+D

steps:

1.sales order for FG item in which child items we are manually at row level for print layout issues.

2.Delivery challan document we are making by copy to functionality and then again selecting FG item so that

child items come again under FG at row level this we are doing so that we can decrease teh stock of chil items whihc ever is required.

3.A/R invoice we are creating in system only with FG item by deleting child item at row level due to print layout problems.

in sales invoice we are entering unit price of FG.

ISSUE ONLY ON VAT:

here in this company during creation of sales invoice WE HAVE to calculate the tax amount through system but the problem is that we have different taxt rates for different child items whihc is explained as below:

1.A(Material-aluminum)-vat@4%

2.B(material- hardware)- vat 12.5%

3.c(Material- Glass)- vat@4%

4.D(labour)- VAT not applicable only service tax 10.3% is applicable

so now my question is as follows:

1.how to calcualte the vat tax amount on invoice if child items are not present on invoice or

how to calculate the sale price( exclusive of tax) of the child item from the sale price of the FG(COMPANY is not able to bifurcate the sale price of finish goods at child items)

example:

after adding delivery we can come to know the COGS of the child items suppose

A=50

B=30

C=20

D=60

total=160

FG SALE PRICE =200 (exclusive of tax)SO Total margin is 40Rs(equivalent to 25%)

then A= 5012.5(MARGIN)=62.5 WITH VAT 4%= 62.52.5=65

B=307.5(MARGIN)=37.5 WITH VAT 12.5%= 37.54.69=42.19

C= 205(MARGIN)=25 WITH VAT 4%= 251=26

D=60+15(MARGIN)=75 with NIL VAT

FG= 62.537.525+75=200

vat on above= 2.54.691= 8.19Rs.