Pricing procedure - vat calculation on freight charge

[Former Member]

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..

.

[pankaj_singh9 · Accepted 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

[Former Member · Accepted solution]

Hi Pankaj,

can u tell me the usage and effect of AltCBV 363 ??

[pankaj_singh9 · Accepted solution]

The value from the subtotal 6 will be passed/picked up by the routines 363 and deducted from the base value for VAT.

In case if combination of Subtotal 6 and AltCBV 363 doesn't work then use combination of Subtotal 4 and AltCBV 362 and check.

[Former Member · Accepted solution]

Pankaj,

I have tried both 363 and 362, still i couldn't get the output.. in my tax procedure - vat is under JVRD.

tell me , in pricing procedure, where FRC1 should come ?

Edited by: sapjj jk on Sep 2, 2008 10:56 AM

[Former Member · Accepted solution]

in standard process it acts over Net value incl. disc.

regards,

indranil

[pankaj_singh9 · Accepted solution]

Hi,

take copy of FRB1 and check following;

Cond. class A Discount or surcharge

Calculat.type A Percentage

Cond.category Blank

Don't activate "Accrual" key for this condition.

Insert this just with Discount conditions with RA00, RA01, etc... just below Gross Price condition (PB00 an PBXX) in M/08

[Former Member · Accepted solution]

Thank u Pankaj... I got it, as per ur input.

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Kannan,

i don't want to create seprate tax code.. in that case , tell me the solutoin..

[Former Member]

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

[Former Member]

BSA,

Seems ur solutoin will work.. could u pls brief in detail..

..

[Former Member]

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

[Former Member]

HI,

Thank u for great input..

can u pls give me with example , how the calculation of VAT works on freight con type. ..

..