Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Excise duty calculation on Assessable value in PO

Former Member
0 Kudos

Dear Team,

We are facing critical issue in Excise Duty calculation, Excise is calculating on basic price for our normal procurement and we are selling the same at MRP cost... Now the issue is Excise Duty has to be calculated on Assessable value (65% on MRP value) instead of basic price in PO.

Example:

Basic Price - 100

MRP - 300

Assessable value - 195

Excise Duty - 24.10 (195*12.36%)

Regards,

Sai

1 ACCEPTED SOLUTION

binoy_vargis1
Active Contributor
0 Kudos

You can create a new manual statistical condition type in MM Schema for MRP. If 65% is not fixed then you have to create another condition type for abatement also.

Inside Taxprocedure TAXINN/TAXINJ you have to put a routine against BED condition type so that the Base value for calculation of BED can be changed. Rest all remains the same.

Take the help of technical team for the routine. Logic and validations or restrictions can be made inside the routine.

Regards
Binoy

4 REPLIES 4

binoy_vargis1
Active Contributor
0 Kudos

You can create a new manual statistical condition type in MM Schema for MRP. If 65% is not fixed then you have to create another condition type for abatement also.

Inside Taxprocedure TAXINN/TAXINJ you have to put a routine against BED condition type so that the Base value for calculation of BED can be changed. Rest all remains the same.

Take the help of technical team for the routine. Logic and validations or restrictions can be made inside the routine.

Regards
Binoy

0 Kudos

Dear Binoy,

Thanks for the input, we have created new condition type for MRP and Abatement, routine also made and tax input is coming correctly as per assessable value instead of base price.

Now VAT also calculating for assessable + ED value instead of Base value + ED(Calculated on assessable value) tried with routine not succeed...

Kindly help us...

0 Kudos

Dear Sai,

For achieving this you have to do slit changes in your tax procedure. 

Kindly ask your technical team to create another routine to store only Base price and assign the same with dummy condition type, now you can get the actual base price and add ED values.

Take a total and calculate VAT as per below step

Example:

100  ZBAS(Dummy Condition Type)  876 (Routine)

101  BED (Calculated for Assessable value)

102  Cess

103  SCess

104  Base + ED

105  Vat   (For 104)

Regards,

Karna J

0 Kudos

Hi Sai,

Sorry for the late reply. I think you are close to the solution. You should not change the Procedure too much.

MRP and Abatement condition types should be kept independent of calculations in the procedure. It is only for changing the base price already got for BED(JMOP) making use of the routine. If that is the case you will get base price (BASB) added to Excise duties which are modified for calculation of VAT.

For Eg:

10 BASB

30 ZMRP(Independent condition type used to store MRP value)

40 ZABA(Independent condition typeused to store Abatement %)

70 JMOP   From 10(Routine XXX which will change the base value for calculating JMOP with a formula MRP*Abatement %)

270 ZVAT(As usual will calculate from BASB+Excise duties)

Hope this is the way you have done this. Steps 30, and 40 should not come in any "From -to"steps.

This is working well with one of our clients.

Regards

Binoy