Skip to Content
author's profile photo Former Member
Former Member

sap sd - Tax Calculation Based on Base Price

if base price is above 10000/- Eur, tax should be 8%, if base price is below 10000/- Eur tax should be 5%, customer and material taxable.

Is it possible through standard configuration. Pls Help Out!

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2013 at 01:42 PM

    I think you need to create routine and assign against your tax condition, write your above logic.

    Or you may do with scale in condition type, not sure whether tax condition can be configured with scales.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 27, 2013 at 03:00 PM

    Hi,

    Could you define the business requirements more in detail here ? Never heard such tiered tax requirements based on the Base Amount.

    Which country and Industry/Product this type of Tax Rate is being applied to ?

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2013 at 03:36 PM

    Hi Krishna ,

    Scale can help you .Maintain quantity scale and try to maintain the record .It should work .Hope scale logic applies to all the materials available for Sale since most of the company uses single/common condition type to determine Tax .

    I

    Regards

    Santosh Verma


    01.PNG (59.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Srinu S

      Hi Srinu

      Item behavior can be controlled if we remove check mark from Group Condition. Try executing the transaction after you remove the check box.

      Z Would be an Option for Karka along with separate table which will have Tax code combination and Tax % . As Ju said system will surely throw an error at the time of release when Tax code % are not matching .Routine will overwrite the correct Tax amount with Correct Tax code after checking the Base Price .

      More over scaling will take Net value amount not the base Price as Karka looking for .I feel he has limited option after knowing the requirement in detail .

      Thank you guys for all good learning.

      Regards

      Santosh Verma

      01.PNG (141.1 kB)
  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2013 at 01:32 PM

    HI All

    Thanks for working on this Requirement

    I found the same requirement Here SCN,

    They r also confused weather to use scales in MWST or not.

    Please see the below thread

    http://scn.sap.com/thread/3373969

    Karka krishna

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 29, 2013 at 05:40 PM

    Hi All,

    Here are my points on this post :

    1) Requirement Itself:


    It goes back to the basic requirement. There seems to be some flaw. As I said in my earlier responses in this post never seen this kind of requirement and it does not make any business sense from a Tax and Legal Perspective.

    It is like penalizing if a Material is above some Price then Tax is more. Well in some weird philosophical way, it looks justified by in a more practical way it is not. Same Material is taxed 2 ways purely based on value.

    From this perspective, it makes sense the Tax Base being the Base Price;

    2) Group Condition Setting:


    Srinu & Santosh:

    In the testing as pointed out the Group Condition has to be removed for it to work properly, if at all. This is a scenario we are testing not what it actually should be.

    As you must be aware, the Group Condition is based in this case on whether the Tax is calculated based on an individual material or a Material Group;

    3) Karka :


    The calculation of Tax whether it is based on

    • Base Price OR
    • Net Value - Cash Discount


    can be controlled through From and To Steps and Sub Totals.


    With all the other things, other post contributors have done, I am sure you will be able to do this part.

    4) Ju:

    Your point on Tax Code Issue should not arise as only one Tax Code is assigned to a single line of Tax Condition Record.

    Normally different Line Items could have different Tax Codes. I always look at in theory;

    5) Overall:

    My curiosity in this post was based on the fact, if this is a real requirement or not and in the process, discovering the feature of Scales being used differently than what I did in the past, is a bonus.

    For me personally, the requirement looks uncommon, or may be things are changing 😎

    Enjoyed the discussion everyone.

    I log off from this discussion.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 06, 2014 at 06:42 AM

    Hi Karka,

    Just curios! Did you get any solution for this ?

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

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.