Skip to Content
avatar image
Former Member

MRP Based Excise

Dear All,

In our organization we have below billing process (MRP Based Excise).

Excise duty is calculated on MRP(-)30% Abatment.

Can any one help me how to configured the scinerio in a pricing procedure because the Excise is calculated on the base price.

Can anybody telll me how to map this.

Thanks in Advance.

Shobhit Gautam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Apr 07, 2009 at 11:07 AM

    Hi Shobhit,

    For excise duty you have to first calculate base value.....

    Create one condition type as a Base Value and get that -30% price of MRP in this condition type

    now you can calculate excise duty % on this base value condition....

    Regards,

    Ratish

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2009 at 11:13 AM

    Hi

    Welcome to SDN

    maintain abartment condition caluculation type as negitive in v/06.

    step ctype des from to

    10 Base price 200.00

    20 MRP 250.00

    30 Abatement 20 75.00- 30%-

    Assessable value 20 30 175 (250-75)

    kindly maintain in your pricing procudure and test.

    Regards,

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gurus,

      I just got struck at calculating Total excise duty on MRP-Abatement for the same look below my table and provide me complet breif steps

      Product rate each : 1040.33 INR

      Qty : 2

      Total Basic : 2080.66

      MRP :1000 each (2000)

      Abatement 20% :400

      Total Excise :1600

      Excise (10.30%) :164.80

      VAT (4%) :89.82 (On total basic+Excise)

      Invoice value : 2,355.28 (Total BasicExciseVAT)

      Please give me config steps for above information.

      Regards

      Srini

  • avatar image
    Former Member
    Apr 22, 2009 at 04:39 AM

    HI

    10 0 ZPR2 DOMESTIC-BASIC PRICE

    40 0 ZMRP Domestic-MRP Price

    60 0 ZABT Abatement% Discount 40

    80 0 price after abt 40 60

    85 0 Rebate Basis 10

    90 0 BO03 Customer Rebate 85

    130 0 ZEXC BASIC EXCISE DUTY 80 80

    160 0 ZEC1 EDUCATION CESS 130

    165 0 ZEIX SECONDARY & HR E-CES 130

    170 0 total tax 130 165

    200 0 ZAS2 Total Asesable Value 180 190

    210 0 ZCST CST % 190

    250 0 ZVAT VAT 190

    380 0 ZROF ROUNDING OFF

    390 0 grand total 190 380

    440 0 VPRS Internal price

    The above is the pricing procedure i too had the same scenario

    ZPR2 will be the price to the customer

    ZMRP will be the mrp price of teh material

    ZABT is the condition type for abatement which is 30%

    for this copy any discount condition and change them

    dont forget to put as statistical for ZMRP condition type

    regards

    like the above create the pricing procedure

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 11, 2010 at 09:49 AM

    Thanks for all inputs

    Add comment
    10|10000 characters needed characters exceeded