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

Brilliant and gold tax calculation

Hi everyone,

I have a question about tax calculation. Our client sells brilliant. Their some products have brilliant and gold. There is no calculate for gold in Turkey. I will try to explain our scenario as below:

For example there is a product which has 1000 USD sales price. and this product involve 3,5 gr. gold. karat of this gold is 14. Full gold coin is 24. Thats why, they calculate 14/24 = 0,585. And they have gold exchange rate also. Let's say 100 for exchange rate.

Formula is : 3,5 * 0,585 * 100 = 204,75

Product sales price : 1000 USD

1000 - 204,75 = 795,25

amount base = 795,25 / 1,18 = 673,9407

tax = 121,3093

How to calculate this tax in sap? Can anyone help me about this issue?


Thank you very much

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 11:36 AM

    Could anyone help me??

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2016 at 12:56 PM

    Once you arrived the base price, then the tax would be calculated based on that as I presume, your tax condition type is set to Percent. Ideally, you should have posted this query in sales forum.

    G. Lakshmipathi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2016 at 01:16 PM

    Kah,

    From what you've stated, 1000 USD sales price is inclusive of tax, right?

    What you drew seems like can be accomplished by using calculation base formulaes, but I wonder if there can be a better way. Technically you can do the exact same calculation in the formulae, and calculate the tax amount by dividing the tax amount to tax applicable amount you've found. Then you'll need to substract tax amount from 1000 USD to find the base price, which at the very least doesn't look very promising. This can be trickier than it seems and cause more problems than it solves. Is there a reason why your client wouldn't sell their products with base price + tax formulation? They can always list the prices to their customers inclusive of sales tax, but not setting a list base price does not look like best practice at all.

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Bilgin

      Is there a reason why your client wouldn't sell their products with base price + tax formulation? They can always list the prices to their customers inclusive of sales tax, but not setting a list base price does not look like best practice at all.

      Normally in some industries (Cements,Chemicals etc..) MRP will be fixed by Governments(In India)-So all the discounts,Taxes,surcharges etc..should not cross this Fixed MRP.

      Also standard SAP will be giving the option of doing pricing with procedures called Standard pricing & Reverse pricing..so some clients will be using this process of reverse pricing..

      Phanikumar

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.