...
Total Received Value = (Value Received + Discount + Taxes)
Total Bill Value = Sum of all installments.
Commission base = (Total Bill Value - Discount - Tax that was discounted from the base according to the Sales Representative File and Parameters)
Formula
Calculation of Proportionalized Commission Base = Total Received Value / Actual Bill Value * Commission Base
Calculation of the Proportionalized Commission Base =
Total Amount Received (BRL 10,105.85 + BRL 100.00 + BRL 634.35 = BRL 10,840.20) / Total Bill Value (BRL 10,840.20) * Commission Base (BRL 10,840.20 - BRL 100.00 - BRL 840.20 = BRL 9,900.00) = BRL 9,900.00
Taxes discounted from the base + Discounts + Commission Base
Rebuild base for analyzing the calculated value = BRL 840.20 + BRL 100.00 + BRL 9,900.00 = BRL 10,840.20
Notes:
The ICMS reduction value will be discounted from the sales representative commission base if it is within the following rule: ICMS Calculation Base Reduction - MG - MP11 – 115292.