Plans and rates
Rate lines and costs
Set rates by customer, product, dimension and date, see which rate line wins, and set commission costs by type.
updated: applies-to: 2.0.0.0
Matching rate lines are prioritized by customer, then product, then dimension and latest starting date; margin methods also use costs.
Rate lines say which sales a component pays on, and at what rate or amount. Commission costs give the cost that margin commission is calculated from.
Add rate lines
- Open the plan, select the component in Components and choose Rate Lines.
- Add a line for each rate:
| Field | What it does |
|---|---|
| Customer Scope and Customer Code | All Customers, a Customer (sell-to), a Bill-to Customer, or a Customer Commission Group. Customer Name shows its name. |
| Product Scope and Product Code | All Products, an Item, an Item Category or an Item Commission Group. Product Name shows its name. |
| Dimension Code, Dimension Value Code | Only sales lines with this dimension value. |
| Unit of Measure Code | For Amount per Unit: pay per this unit, such as CASE. |
| Starting Date, Ending Date | The posting dates the line is valid for. |
| Rate % or Amount | The rate, or the amount for per-unit and fixed methods. |
| Exclude | Matching sales earn nothing from this component. |
| Min. Margin % | Below this margin the line pays nothing. |
| Max. Line Discount % | Above this line discount the line pays nothing. |
Two rate lines: the more specific premium line wins for premium items.
Which rate line wins
Only lines that match the customer, product, dimension and posting date take part. With Rate Selection Most Specific, the default on the component, the most specific line wins:
- A line for a customer beats a line for a bill-to customer, which beats a customer group, which beats all customers.
- At the same customer level, an item beats an item group, which beats an item category, which beats all products.
- A dimension breaks a tie. Then the latest Starting Date wins.
So a line for a customer group beats a line for an item group. Under Most Specific, an Exclude line only works when it is the most specific line that matches. To keep an item out for everyone, use Commission Line Rules.
A component can also pay the matching line with the highest or the lowest rate. Then any matching Exclude line wins. See Rate selection.
Why a line paid nothing
The sales document and the commission entries show a reason when a line earns nothing:
| Reason | What happened |
|---|---|
| No Rate Line | No rate line matched the customer, product or date. |
| Excluded | The winning rate line, or a line rule, excludes the sale. |
| Above Maximum Discount | The line discount is above Max. Line Discount %. |
| Missing Cost | No cost was found and When Cost Is Missing is Pay No Commission. |
| Below Minimum Margin | The margin is below Min. Margin %. |
| Zero Rate | The rate is 0. |
| No Margin | The margin is zero or less. |
| Plan Blocked | The plan was blocked on the posting date. |
| No Plan | The salesperson has no plan on the posting date. |
| Not a New Customer | The component pays only on sales to new customers, and this customer is not new. See New customer rates. |
| Not Licensed | The salesperson has no seat of your license. The commission is withheld, not lost. See Subscription and license. |
| License Expired | When the sale was posted, the license had ended more than 14 days earlier. After you renew, Calculate Missed Commission on the Commission License page calculates it. |
Set commission costs
Search for Commission Costs. A cost line has a Type (Item, Resource, G/L Account or All), an optional No., a Variant Code for items, a Starting Date, a Unit Cost (LCY) and a Cost Adjustment %. Name shows the name of the item, resource or G/L account; it is blank on a line that applies to all of its type.
A fixed commission cost for one item and a freight loading on every item.
Where the cost comes from, per base unit:
- The commission cost for the item and variant, then for the item, then the line of the type with a blank No., then the All line.
- The item card Unit Cost (only when Use Item Unit Cost is on; it is off by default), or the resource card Unit Cost.
- The posted sales line's unit cost.
- The Cost Adjustment % of the most specific line that has one then raises or lowers the cost found.
Examples:
- A line of Type Item with a blank No., Unit Cost 0 and Cost Adjustment % 3 loads 3% freight onto every item's cost.
- A line of Type G/L Account gives a cost to installation or freight lines sold through a G/L account.