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

Rounding

I have a need to round figures from GROSS (including Tax) to NET (exluding tax) The problem is that our prices are defined inclusive of tax eg £10. When we receive a payment we cannot put in the GROSS of £10 and SAP to work out the NET - I do not know how to do this. Of course, this is the ideal solution, if possible.

The alternative is to put in the NET figure in SAP - but SAP will calculate the 17.5% tax and leave us a difference of say 1pence. If the "ideal solution" as described above is not available then I should be able to manually changed the TAX figure to make the figures add up and SAP does not allow me to do so.

So I wonder if anyone knows what the solution is.

thanks

Robert

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2008 at 02:48 PM

    I managed to resolve this issue

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2008 at 02:48 PM

    I managed to resolve this issue

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 19, 2008 at 08:45 AM

    Hi Robert,

    Can you share your solution, that would be highly appreciated as we are also dealing with tax in one of our customization and are facing some rounding issues.

    Just thought your solution may help us as well.

    Regards,

    Jeniffer

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jennifer, My rounding issues were of basic nature and they were resolved in two ways

      1 Working out Net from Gross - this was simple because all we had to do is enable the GROSS column so it is shown on the screen. SAP works out the net if we input the figures in the Gross column

      2. Where the default has been set for too many decimals (ie 3 decimals for product quantity), I can supress these decimals with the PLD on the printout and for the time beeing, we have to tolerate the 3 decimals on the default screen layouts.

      Probably this is not of great help to you but these are my solutions for now. Generally speaking, SAP probably works out the calculations correctly but it is a matter of screen layout and what you see, which can be different from the "real figure"

      Good luck

      Robert

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2008 at 05:37 AM

    Thanks Robert for the quick reply will surely try out this solution...

    Regards,

    Jeniffer

    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.