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.