Skip to Content
avatar image
Former Member

Pricing procedure - vat calculation on freight charge

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

.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Sep 02, 2008 at 07:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Pankaj Singh

      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

  • avatar image
    Former Member
    Sep 02, 2008 at 04:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 04:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 05:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2008 at 06:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded