MRP Based Excise

[Former Member]

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

[Former Member]

Thanks for all inputs

[Former Member]

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

[former_member315051]

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

[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

[Former Member]

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