on 10-19-2011 11:29 PM
I have a customer with the following Issue:
They enter an A/P or A/R invoice line for say a quantity of 10000 and the price is 4.18 per item and they apply a discount of $80.66
The company is set to show price to 3 decimal places. So the effective price that shows on the invoice is 0.808 per item. The line total though is not 8080.00 but 8084.21 because the system is using price of 0.808421 for calculating the line total.
This creates a problem because document total is incorrect. Is there any way to get the rounding to actually calculate the line total by the truncated 3 decimal point unit cost?
Hi,
The numbers given by your example sounds no match. Please clarify it.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The system is set to round to 3 decimal points. The client wants it rounding prices to 3 decimal points.
They have a line item on the order. It's dollar value is 4.18 as price. A discount of 80.66% is given on that line. This brings the displayed gross price and price after discount to 0.808 visible. This is also what shows on the invoice as the unit price.
The problem is that behind the scenes: SAP is calculating the price it uses for multiplying and calculating Line TOTAL as 0.808412.
If you have 10,000 on order, the price that shows for the unit price after discount is .808 which with 10,000 should be a line total of 8080.00. Because it is not rounding the unit price to the proper digits though and is using the 6 decimal value of 0.808412, the 10,000 have a line total of 8084.12. This is a problem because customers are calling saying that price displayed is one thing and then they multiply it by quantity and compare it to the line total and see they are being charge 4.12 more.
Multiply this by 20 or 30 lines and invoices can be significantly higher than they should be.
Our client does not want to do 4 or 5 digit prices to show increase precision. They need the unit price rounding to 3 decimals to take place before multiplication with quantity for line total.
B1 round calutions on each line. A possible solution is in the administration module and in system intialization window in one of the tabs you could allow numbers to have larger decimal value and that might improve calculations. OR if you want to shrink the number decimal pointds from the DB there is a table with those values which is not a suggested method.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
14 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.