wrong calculation in miro for additional vat in guj
HI FRIENDS ,
I HAVE A SERIOUS ISSUE
Recently Additonal Vat was introduced in gujarat.
Additional vat is calculated on, total value of the amount.
A new condition type for additional vat is created.
We have the following scenario
Total PO Value Rs. 10000
Vat: 4% - Rs. 400
Additonal Vat 1% - Rs. 100
Total PO Value: Rs. 10500
In normal circumstances the entries will be as follows:
When MIGO is done:
Stock A/c Dr 10000
When MIRO is done:
Vendor A/c 10500
Add Vat 100
This scenario is running correctly in normal circumstances. However when the excise is included in rate we get the following entries
PO: Rate: Rs. 10000 (Excise of Rs. 200 includes in rate)
Vat: Rs. 400
Additional Vat Rs 100
Total PO Value: 10500
When MIGO is done: - here we tick the mrp indicator
Stock A/c dr. 9800
When J1iex is done
Cenvat input 200
to cenvat clearing 200
When MIRO is done
Vendor: Rs. 10500
Cenvat clearing 200
Vat: Rs. 400
Additional Vat: Rs. 98 ( Should be Rs. 100)
Scenario is working perfectly if there is no excise or excise is extra, problem only comes when excise is including in the rate.
We had raised an OSS with SAP. They have given us an user Exit ' J_1I17_USEREXIT_PROCESS_TKOMV'
how to work with this erxit they told us to redetrmine the additional vat here & its to be called after the fn mod : j_1i4_tax_conditions .they r the part of the class cl_im_india_tax_conditions
KINDLY ANY BODY HELP ME WITH DETAILED STEPS
thanks in advance