Skip to content
Bitta Apps

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

Next step

See Bitta Commission on your own data