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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.