cancel
Showing results for 
Search instead for 
Did you mean: 

rounding Issue on invoices

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

The numbers given by your example sounds no match. Please clarify it.

Thanks,

Gordon

Former Member
0 Kudos

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.

Former Member
0 Kudos

What are all different decimal settings? Please list them.

Former Member
0 Kudos

Unless there is a specific need to show the correct disount, why not just enter the 8080 in the line total & let the system calculate the price after discount?

jbrotto
Active Contributor
0 Kudos

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.