...
This report will spread subtotal discount coupons proportionally to the unit prices shown in the report. This will help you understand the net price that you're selling the product for. Here is an example of the math:
So for this example we have the following items with cost:
| Item ID | Amount |
|---|---|
| ROGGVIN- |
...
| SAMPLER | 24.85 |
| ROGGN-2.1OZ- |
...
| EA | 6.95 |
| ROGGNP-2.2OZ- |
...
| EAU | 4.95 |
The subtotal for the order was 36.75 and there were subtotal discounts of 7.95. So if we look at the % allocations it would be:
| Item ID | Math | Percentage |
|---|---|---|
| ROGGVIN- |
...
| SAMPLER | 24.85 / 36.75 |
...
| 67.62% | |
| ROGGN-2.1OZ- |
...
| EA | 6.95 / 36.75 |
...
| 18.91% | |
| ROGGNP-2.2OZ- |
...
| EAU | 4.95 / 36.75 |
...
| 13.47% |
Taking those allocation percentages we have the following subtotal discount portions:
| Item ID | Math | Portion of Subtotal Discount |
|---|---|---|
| ROGGVIN- |
...
| SAMPLER | 7.95 * 67.62% |
...
| 5.37 | |
| ROGGN-2.1OZ- |
...
| EA | 7.95 * 18.91% |
...
| 1.50 | |
| ROGGNP-2.2OZ- |
...
| EAU | 7.95 * 13.47% |
...
| 1.07 |
...
Subtracting the portion of the subtotal discount from the original item unit prices we get
| Item ID | Math | Effective Unit Price |
|---|---|---|
| ROGGVIN-SAMPLER | 24.85 - 5.37 | 19.48 |
| ROGGN-2.1OZ-EA | 6.95 - 1.50 | 5.45 |
| ROGGNP-2.2OZ-EAU | 4.95 - 1.07 | 3.88 |