Bitta Commission · Tutorial · 2:36 · YouTube
Margin band commission in Business Central
What this video covers
Pay a higher rate on sales with better margins.
We build margin bands, explain one invoice measured per line and per document, and post it.
Method 3 of 11 in the Bitta Commission series.
Transcript
Pay a higher rate on better margins. That's Margin Band Rate, method three of eleven. Maya's plan has three margin bands. From zero percent margin, she earns two percent. From twenty, four percent. From thirty, six percent. The margin picks the band. The rate is paid on the sale. Maya sells Oakridge a drip irrigation kit for twelve hundred dollars, at a thirty-five percent margin. That's the thirty band. Six percent of twelve hundred is seventy-two dollars. On the same invoice, a pallet of compost at twenty-five percent off. Three hundred sixty dollars, at a margin under seventeen percent. That's the zero band: two percent, seven dollars twenty. Measured line by line, the invoice pays seventy-nine dollars twenty. Now measure the margin over the whole document instead. Fifteen sixty in sales, four hundred eighty in margin. Almost thirty-one percent. The whole invoice lands in the six percent band: ninety-three dollars sixty. A margin right on a boundary takes the band that starts there. Below the lowest band, a line pays nothing, with the reason No Rate Line. Now in Business Central.
A new plan for Maya, with a Margin Band Rate component. It measures the margin per line. Its margin bands: two percent from zero, four percent from twenty, six percent from thirty. Assign it to Maya. The invoice for Oakridge: one drip irrigation kit at full price. Then a pallet of compost, twenty-five percent off. Explain Commission: six percent on the kit, two percent on the compost. In total, seventy-nine dollars twenty. Now switch the component to measure the margin over the document. Explain again: six percent on both lines. Ninety-three dollars sixty. Post the invoice. Maya's commission entry is in the ledger: ninety-three dollars sixty, from this invoice.
Use Margin Band Rate to reward healthy margins with a simple rate on sales. Measure per line to judge each item, or per document to judge the whole deal. Next: Amount per Unit.
More Bitta Commission videos
All videos
1:02OverviewSales Commission in Business Central
3:54Part 1Set Up Sales Commission in Business Central
5:14Part 2Commission Plans and Rates in Business Central
5:17Part 3Read the Commission Trace in Business Central
4:23Part 4Pay Sales Commission in Business Central
4:05Part 5Periods, Teams and Targets in Business Central