Rounding in Pricing

We have a frustrating scenario that is causing an issue with our customers in Mexico. In this region, our sales force has negotiated discount percentages out to three decimals (ex. 16.167%). Due to rounding performed by standard SAP condition type NETP, depending on the quantity and price, we see some discrepancies between orders with our final unit price. Details below:

Scenario 1 - nine units (you can see that an extra 0.03 was removed by NETP)

Condition Type Value Quantity Total J3AP (List Price) 309.83 9 2788.47 Z020 (Std Discount %) 12.167% 339.2731449 Subtotal 2449.20 NETP (Rounding Condition) -0.03 Subtotal 2 2449.17 Distribution Allowance 3.5% 85.72 Marketing Allowance 2.5% 61.23 Subtotal 3 2302.22 Unit Price (Subtotal 3 / Quantity) 255.80

Scenario 2 - 1 unit

Condition Type Value Quantity Total J3AP (List Price) 309.83 1 309.83 Z020 (Std Discount %) 12.167% 37.6970161 Subtotal 272.13 NETP (Rounding Condition) 0 Subtotal 2 272.13 Distribution Allowance 3.5% 9.52 Marketing Allowance 2.5% 6.80 Subtotal 3 255.81 Unit Price (Subtotal 3 / Quantity) 255.81

Have you ever run into a similar situation? How did your company handle these rounding discrepancies?

Thanks,

Dan