Skip to content
Bitta Apps

Bitta Commission · Tutorial · 2:06 · YouTube

% of Margin commission in Business Central

What this video covers

Pay your salespeople on the profit of a sale, not its price.

We build a % of Margin plan with a minimum margin, and post an invoice where one discounted line pays nothing.

Method 2 of 11 in the Bitta Commission series.

Transcript

Pay on the profit, not the price. That's % of Margin, method two of eleven. Maya sells Oakridge a commercial drip irrigation kit. Twelve hundred dollars. The kit costs seven hundred eighty. Bitta Commission takes that cost from the item card. Price minus cost leaves a margin of four hundred twenty dollars. That's thirty-five percent. Maya's rate line pays twenty percent of the margin: eighty-four dollars. The same rate line sets a minimum margin of ten percent. A second kit goes out at thirty percent off. Eight hundred forty dollars, so the margin is only sixty, about seven percent. That's under the minimum, so the line pays nothing, and it says why: Below Minimum Margin. The invoice pays eighty-four dollars. A line with no cost pays nothing too, with the reason Missing Cost. Now in Business Central.

The cost first. The kit's item card has a unit cost of seven hundred eighty dollars. A new plan for Maya, with one component paid as % of Margin. Its rate line: twenty percent of the margin, with a minimum margin of ten percent. Assign it to Maya. A new invoice for Oakridge, with one drip irrigation kit at full price. Then a second kit, thirty percent off. Explain Commission: the first kit earns eighty-four dollars. The second is below the minimum margin, so it earns nothing. Post the invoice. Maya's commission entry is in the ledger: eighty-four dollars.

Use % of Margin when discounts and costs vary from deal to deal, so your team protects the profit, not just the sale. Next: Margin Band Rate.

More Bitta Commission videos

All videos

Next step

See Bitta Commission on your own data