Skip to Content
author's profile photo Former Member
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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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

    Add a comment
    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

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.