Setting up condition for Abetement, Excise and CST calculation for PO

[Former Member]

Hi sir,

I want to create a PO with condition. Can u help me how to define this condition in PO. The requirement is given as below

Qty:25056 * 32 = 801792

But there is Abetment of 35% on MRP  value.

25056 * 139 = 3482784

3482784 * 35% = 1218974 (3482784 - 1218974 = 2263810)

Now  6% Excise charge on 65% value (2263810)

2263810 * 6% = 135828.6

Now this Excise value add in invoice value (801792 + 135828.60 = 937620.60)

Now 2% CST calculate on total value (937620.60 * 2% = 18752.41)

And total invoice value is = 956372.98.

Message was edited by: Jyoti Prakash

[former_member198650]

Hi Sonia,

First uncheck the assume answered button. Come to your issue, to achieve it refer below steps:

1. Create 2 conditions in OBQ1 with access sequence which has maintained for excise condition. One is for MRP value and another one for abatement. In abatement condition maintain the sign as negative.

2. Add the above 2 conditions in the tax procedure in OBQ3 before the excise condition. Here you have to select statistical check box and change the from and to for excise condition as step nos of above 2 conditions

3. Then after maintain the tax condition in FV11 for the above 2 condition. Here for abatement you have to mention as -35%. Then it will calculate excise on 65% of MRP.

Once done above settings, create a PO and check the impact.

Regards,

Mukthar