on 09-02-2008 5:47 AM
HI,
Pls tell me, how to activate in pricing procedure, VAT should calculate frm the freight charge and how to link pricing procedure and tax procedure?? . give me solution..
.
Hi,
For this you have to treat Freight as a Discount Condition Type in MM Pricing
Take a copy of RA01 in M/06 as YA01and keep it as following;
Cond. class A Discount or surcharge
Calculat.type A Percentage
Cond.category Blank
And Plus/minus - A (Positive)
Use this in Pricing Procedure ( M/08 ) after Gross Price ad Discount conditions (before Subtotal) and assign Subtotal "6" against this condition type.
In OBQ3 - Tax Procedure, assign AltCBV 363 to VAT Condition Type (For e.g. JIP5)
Now check the calculation will happen as following;
Gross Price = 10000 INR
Freight (as +ve Discount) = 1000 INR
BED 14% = 1400 INR
ECS 2% = 28 INR
SECess 1% = 14 INR
VAT 4% = 497.68 INR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pankaj,
I have gone through your reply. I want to calculate VAT on Frieght. Following is the Scenario which i am using for the caluclation of VAT on Frieght.
In Condition Tab I am Getting the following information
PBXX Gross Price 949.6
Net value incl. disc 949.6
NAVS Non-Deductible Tax 0
Net value incl. tax 949.6
ZFCD Freight/Quantity Ded 575
SKTO Cash Discount 0
Actual price 1,524.60
In Invoice Tab I am geeting the following information
BASB Base Amount 949.6
Calculated Call 0.95 INR 949.6
Sub total 0.95 INR 949.6
JMOP IN: BED setoff % 8 % 75.97
JMX1 IN: A/P BED setoff 100 % 75.97
Total excise duty 0.08 INR 75.97
JEC1 A/P Ecess for Setoff 2 % 1.52
JSEP IN:A/P SECess Setoff 1 % 0.76
ZFRI FREIGHT-TESTING 0 INR 0
Copy Net Price 0.95 INR 949.6
Excise Duty 0.08 INR 75.97
JEX1 A/P Ecess for Invent 100 % 1.52
JHX1 IN: A/P SECess SOTot 100 % 0.76
Copy AED 0 INR 0
Price + Excise + AED 1.03 INR 1,027.85
JVCS A/P CST Non deductib 0 % 0
JVRD A/P VAT RM Deductibl 5 % 51.39
JVRN A/P VAT RM Non-Deduc 0 % 0
JVSD A/P Surcharge on VAT 10 % 5.14
Net Price + ED +ST 1.08 INR 1,084.38
But i Would Require the Following Calucaltions i.e (JVRD = JVRD + (ZFCD*0.05)) That i have mention in my below screen shot.
BASB Base Amount 949.6
Calculated Call 0.95 INR 949.6
Sub total 0.95 INR 949.6
JMOP IN: BED setoff % 8 % 75.97
JMX1 IN: A/P BED setoff 100 % 75.97
Total excise duty 0.08 INR 75.97
JEC1 A/P Ecess for Setoff 2 % 1.52
JSEP IN:A/P SECess Setoff 1 % 0.76
ZFRI FREIGHT-TESTING 0 INR 0
Copy Net Price 0.95 INR 949.6
Excise Duty 0.08 INR 75.97
JEX1 A/P Ecess for Invent 100 % 1.52
JHX1 IN: A/P SECess SOTot 100 % 0.76
Copy AED 0 INR 0
Price + Excise + AED 1.03 INR 1,027.85
JVCS A/P CST Non deductib 0 % 0
JVRD A/P VAT RM Deductibl 5 % 80.14
JVRN A/P VAT RM Non-Deduc 0 %
JVSD A/P Surcharge on VAT 10 % 8.015
Net Price + ED +ST 1.08 INR 1,116.01
PBXX Gross Price 949.6
Net value incl. disc 949.6
NAVS Non-Deductible Tax 0
Net value incl. tax 949.6
ZFCD Freight/Quantity Ded 575
SKTO Cash Discount 0
Actual price 1,524.60
Dinesh
Hello Sapjj,
I'm also facing tha same problem.
In addition to the freight, i want the vat to be calculated also on P&F.
Can u plz gve me detailed input regarding this?
If possible, tell me what changes has to be done in the routine so that it will be helpful to my ABAPer.
Thanks in advance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create a Tax code exclusively for freight vendor and use the tax code while doing MIRO for Planned Deliver costs.
In Tax procedure,maintain the condition type and give the account key.
Miantain GL account for account key.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create a Tax code exclusively for freight vendor and use the tax code while doing MIRO for Planned Deliver costs.
In Tax procedure,maintain the condition type and give the account key.
Miantain GL account for account key.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can write a rouitine to fetch the Base amount for VAT calculation from Freight cond type and assign that rouitine to VAT cond type.
take Abaper help to write a routine.
Regds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Routine is like Alternative formula for condition base value,give ur inputs to Abaper how the VAT condition type has to calculate the VAT. In normal scenario VAT is calculated on (BaseBEDECS+SHE CES) but in ur case VAT should be on frrieght.So abaper can write a program to fetch the base value from Frt Condition for VAT calculation.Assign that routine against VAT condition type in AltCBV column.
Hope its is clear.
Regds
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.