Discount on Excise and sales tax on discounted total.

[Former Member]

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

[former_member335885]

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

Just follow the following:

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

[Former Member]

Hi kiran,

Thanks for ur answer.

You are proposing a manual entry of values,

but is ther a way for the system to pick the edu cess and tax automatically from the records maintained.

regards,

vimal

[former_member335885]

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

[Former Member]

hi

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

Regards

Kavi

[Former Member]

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

[Former Member]

Hi,

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

regards,

vimal