Former Member

Discount on Excise and sales tax on discounted total.

Hi gurus,

I want to calculate pricing based on following scenario.

Discount should be on total of basic price and excise.

Then for that discounted total, sales tax should be calculated.

Ex:

Basic price = 1000

Excise (14%) = 140

Edu cess (3%) = 4.20

Total = 1144.20

Discount (5% on 1144.20) = 57.21

Total (1144.20 - 57.21) = 1086

CST 3% (on 1086) = 32.60

Grand total (1086 + 32.60) = 1119.09

In tax code excise , education cess and CST is maintained.

Discount should be calculated automatically on excise and education cess.

Likewise sales tax should be automatically calculated on discounted total.

So how to maintain it in pricing procedure.

Kindly help

Regards,

Vimal

10|10000 characters needed characters exceeded

Related questions

• Former Member
Posted on Apr 28, 2008 at 09:59 AM

HI

FOR MY knowladge u didnt get any discount on excise duty which is payable to govt.before excise cal u have to give disc

regards

srinivas kona

10|10000 characters needed characters exceeded
• Former Member

Hi,

But here the tax is based on discounted value of excise for certain materials.

regards,

vimal

• Former Member
Posted on Apr 28, 2008 at 10:02 AM

hi

As per govt norms, There is no Discount in Excise duty

Regards

Kavi

10|10000 characters needed characters exceeded
• Posted on Apr 28, 2008 at 10:06 AM

hi,

Basic price = 1000

Excise (14%) = 140

Edu cess (3%) = 4.20

Total = 1144.20

Discount (5% on 1144.20) = 57.21

Total (1144.20 - 57.21) = 1086

CST 3% (on 1086) = 32.60

Grand total (1086 + 32.60) = 1119.09

Step Condition type from to

10 Basic price 0 0

20 Excise 10 10

30 E Cess 10 10-----should be entered in PO

40 Total 10 30

50 Discount % 40 40 -

should be entered in PO

60 Total 40 50

70 CST % 60 60 -

should be entered in PO

80 Grand Total 60 70

Thanks & Regards,

reward if helpul

Kiran

10|10000 characters needed characters exceeded
• Kiran. V Former Member

Hi,

The actual procedure is to have these condition types like excise duty,cess... i mean all the duties should be entered in FV11 with the key combination.

The other condition tyoes like discounts, frieghts can be entered manually while creating PO or it can be placed in the inforecord. as it is a combination of material and vendor combination while creating a PO for this combinations, the system will pick these values from the inforecord and puts it in the PO.

Thanks & regards,

Kiran