Setup Examples
This page starts from the task – "our shop should always earn 15 %", "the Ariba catalog may only change at the start of a quarter" – and names the fields you set in the Price Calculation Setup to get there. Each example is a template: take the values, adjust percentages and amounts to your business, check the result with the Example Price (Cost 100.00) and the Price Simulation, then go live.
How to read the examples
- The tables only list the fields that matter.
- Calculations assume a cost of 84.00 after supplier conditions and 19 % VAT.
- All percentages and amounts are sample values, not a recommendation for your pricing.
- In more detail, with all the background: chapter 25 of the user manual (PDF, German).
Which example fits?
| I want to … | Example |
|---|---|
| price the online shop with a fixed margin and a .99 ending | 1 |
| price commission and fees into a marketplace | 2 |
| match or undercut competitor prices | 3 |
| run further channels as a markup or discount on the shop | 4 |
| a price list that only changes once a quarter (e.g. SAP Ariba) | 5 |
| annual prices for several framework-contract customers | 6 |
| a smaller margin on expensive B2B items, plus quantity discounts | 7 |
| calculate from the item unit cost without a supplier connector | 8 |
| clear overstock and not give away scarce goods | 9 |
| make small parts cover the freight | 10 |
| introduce the engine carefully | 11 |
Example 1: Online shop with 15 % margin and .99 ending
| Field | Value |
|---|---|
| Cost Source | Best Supplier Offer |
| Prefer Offers in Stock | Yes |
| Include Discounts / Include Freight Cost | Yes / Yes |
| Margin Formula | Trade Margin (of price) |
| Margin % | 15 |
| Min. Margin Amount | 2.00 |
| Prices Including VAT | Yes |
| VAT Bus. Posting Gr. (Price) | your domestic group, e.g. DOMESTIC |
| Rounding Method | Round to x.99 |
| Use List Price as Max | Yes |
| Safety Max Change % | 25 |
| Min. Price Change % / Force Update After (Days) | 1 / 7 |
Calculation: 84.00 ÷ (1 − 15 %) = 98.82 net → × 1.19 = 117.60 → 117.99. x.99 always rounds up, so the actual margin is slightly above 15 %.
Trade margin or markup?
With Markup (on cost), 15 % gives only 96.60 net, rounded 114.99 – a trade margin of 13 %. Agree beforehand which reading your business means.
Min. Margin Amount raises, Safety Min Contribution rejects
The Min. Margin Amount raises prices that are too thin: a small part costing 3.00 sells at 5.00 net (5.99 gross) instead of 3.53. The Safety Min Contribution in the safety limits rejects such a price instead, and the previous one stays.
Example 2: Marketplace with commission
The marketplace keeps 10.5 % of the gross price and 0.35 per sale; 12 % margin should remain after fees.
| Field | Value |
|---|---|
| Margin Formula / Margin % | Trade Margin (of price) / 12 |
| Prices Including VAT | Yes |
| Rounding Method | Round to x.99 |
Add one line without an item category to the Marketplace Fees: Commission % 10.5, Payment Fee % 0, Fixed Fee 0.35, Enabled Yes.
Calculation: 84.00 ÷ 0.88 = 95.45 net → 113.59 gross → (113.59 + 0.35) ÷ (1 − 10.5 %) = 127.31 → 127.99. After 13.44 commission and the 0.35 fixed fee, 95.97 net remain – a 12.5 % margin.
Do not count fees twice
Connectors with their own fee model (e.g. Amazon) price their fees in themselves. For such channels, enter nothing in the Marketplace Fees, or only what the connector does not cover. The price explanation shows both parts separately.
A different commission for one item category: add a second fee line with that Item Category Code.
Example 3: Undercut competitors
One cent below the cheapest competitor, never below 8 % margin, never above the RRP. In addition to example 1:
| Field | Value |
|---|---|
| Competitor Strategy | Undercut |
| Competitor Offset % / Competitor Offset Amount | 0 / 0.01 |
| Competitor Min. Margin % | 8 |
| Competitor Max Age (Hours) | 24 |
| Allow Competitor Events | No |
| Use List Price as Max | Yes |
Regular price 117.99, floor 84.00 ÷ 0.92 × 1.19 = 108.65, RRP 119.00 net = 141.61 gross:
| Cheapest competitor | Published price |
|---|---|
| 112.90 | 112.89 |
| 104.00 | 108.65 – the floor holds |
| 125.00 | 124.99 – the price rises with the market |
| 150.00 | 141.61 – the RRP caps it |
| older than 24 h | 117.99 – the regular price |
Good to know
- The strategy follows the market in both directions – upwards up to the RRP. Without Use List Price as Max or without RRP data, the price rises at most to twice the calculated price.
- The competitor price is not rounded: one cent below the market stays one cent below the market.
- On marketplace lists the floor includes the list's fees.
- The safety limits check afterwards, unchanged.
Match sets exactly the market price; Premium with 3 % stays deliberately above it.
Example 4: Derive channels from the shop
eBay 5 % above the shop, business customers 8 % below it net – both follow the shop in the same run.
| Field | eBay | B2B |
|---|---|---|
| Source No. | – | customer price group of the business customers |
| Base Price List Code | SHOP |
SHOP |
| Base Price Adjustment % | 5 |
-8 |
| Prices Including VAT | Yes | No |
| Rounding Method | Round to x.99 | Commercial Rounding |
Calculation (shop 117.99): eBay 117.99 × 1.05 = 123.89 → 123.99; B2B 117.99 ÷ 1.19 = 99.15 net, −8 % → 91.22.
Margin and offer selection do not apply to derived lists; fees, rounding, cap, competitor strategy and safety limits still do. Marketplace fees on the eBay list would come on top of the 5 % – use one or the other.
Example 5: Fixed quarterly prices for SAP Ariba
Prices apply per calendar quarter; new prices are ready as proposals 30 days ahead.
| Field | Value |
|---|---|
| Price List Code | the list your Ariba channel reads |
| Pricing Mode | Periodic |
| Period Start | 01/01/2027 |
| Period Length | 3M |
| Next Period Lead Time | 30D |
| Coverage Quantity | e.g. 10 – the usual order quantity |
| Margin Formula / Margin % | Trade Margin (of price) / 10 |
| Min. Margin % | 6 – below it the cockpit reports Below Minimum Margin |
| Prices Including VAT | No |
| Rounding Method | Commercial Rounding |
| Safety Max Change % | 20 |
Timeline for Q2 2027:
| Date | What happens | Your task |
|---|---|---|
| until 1 March | The catalog stays; the log shows Held for Period. | Watch the Below Minimum Margin focus |
| 2 March | The hourly run prepares: every change becomes a proposal starting 1 April. | – |
| March | The proposals wait in the price approvals. | Approve → Scheduled |
| 1 April | The run puts the scheduled prices into effect; the Ariba connector uploads the catalog with its next upload. | – |
Good to know
- Without approval the old price stays in the new quarter as well.
- A new item gets its first price at once.
- Hysteresis, approval threshold and competitor strategy do not apply to periodic lists; the safety limits do.
- Activation needs the
QUEUEjob queue entry. - Half-year or year: Period Length
6Mor1Y. The lead time must be shorter than the period.
Example 6: Annual prices for several framework-contract customers
One periodic base list and one derived list per customer with its own discount:
| Field | Base | Customer A | Customer B |
|---|---|---|---|
| Price List Code | FRAMEWORK |
FRAMEWORK-A |
FRAMEWORK-B |
| Source No. | internal price group without customers | price group A | price group B |
| Pricing Mode | Periodic | Continuous | Continuous |
| Period Start / Period Length | 01/01/2027 / 1Y |
– | – |
| Next Period Lead Time | 45D |
– | – |
| Base Price List Code / Base Price Adjustment % | – | FRAMEWORK / -2 |
FRAMEWORK / -4 |
The customer lists stay Continuous and follow the base as soon as an approved price takes effect there – at year end you review one list instead of many.
Example 7: B2B with margin tiers and quantity discounts
| Field | Value |
|---|---|
| Source No. | customer price group of the resellers |
| Suggest Markup on Documents | Yes |
| Margin Formula | Markup (on cost) |
| Margin % | 6 – applies above the highest tier |
| Prices Including VAT | No |
| Rounding Method | Commercial Rounding |
Margin Tiers: cost up to 50.00 → 25 %, up to 250.00 → 15 %, up to 1,000.00 → 10 %.
Quantity Tiers: from 10 → 3 % discount, from 50 → 5 %.
Calculation: cost 40.00 → 50.00 (48.50 from 10 pieces, 47.50 from 50); cost 180.00 → 207.00; cost 2,400.00 → 2,544.00.
Good to know
- Category margins take precedence over margin tiers.
- Prices jump at tier boundaries: cost 50.00 gives 62.50, cost 50.01 only 57.51.
- Set Suggest Markup on Documents on one list only – the one for your direct business.
Example 8: Without a supplier connector
| Field | Value |
|---|---|
| Cost Source | Item Unit Cost |
| Margin Formula / Margin % | Markup (on cost) / 40 |
| Prices Including VAT | Yes |
| Rounding Method | Price Points |
Price Points: up to 10.00 → ending 0.49, up to 100.00 → 0.90, up to 999,999.00 → 0.00, each Up.
Calculation: unit cost 5.00 → 8.33 gross → 8.49; unit cost 12.50 → 20.83 gross → 20.90.
Do not forget the last tier
A price above the highest price point tier stays unrounded.
Instead of the unit cost, the cost source Purchase Price List can take your maintained purchase prices.
Example 9: Clearance and scarcity
| Field | Value |
|---|---|
| High Stock Threshold / High Stock Margin Adj. % | 50 / -4 |
| Low Stock Threshold / Low Stock Margin Adj. % | 3 / 5 |
With a 15 % default margin the engine calculates with 11 % (stock ≥ 50) or 20 % (stock ≤ 3), counted in sales units. Min. Margin % and the safety limits still apply.
Example 10: Small parts with freight costs
The supplier charges 5.90 freight below 100.00 order value. Freight should only decide the price where a single unit would not cover it otherwise.
| Field | Value |
|---|---|
| Freight as Min. Margin | Yes |
| Freight Floor Surcharge | 0 for drop shipment, e.g. 3.00 when shipping through your own warehouse |
At a 20 % trade margin, net:
| Cost | Freight in cost | Freight as min. margin | … with surcharge 3.00 |
|---|---|---|---|
| 4.00 | 12.38 | 9.90 | 12.90 |
| 80.00 | 107.38 | 100.00 | 100.00 |
Freight as Min. Margin overrides Include Freight Cost, works only with the cost source Best Supplier Offer and needs a Margin % above zero.
Example 11: Careful introduction
- In the Price Engine Setup, switch on Suspend Price List Activation – the engine calculates, Business Central keeps selling at the previous prices.
- Set up the price lists, start the Price Simulation, check large changes and rejections.
- In the Price Cockpit, compare the Inactive Price column with today's price.
- Set an Approval Threshold % of e.g.
10. - Go live channel by channel with Activate Price List (derived lists together with their base), or all at once with Activate All Price Lists.
- Run Create Job Queue Entries.
- After a few quiet weeks, raise the approval threshold or set it to
0.
Quick recipes
| Goal | Setting |
|---|---|
| Hold a single price | Fix Price in the cockpit |
| A promotion for a period | Promotional Price... in the cockpit |
| Never above the RRP | Use List Price as Max |
| Only certain suppliers | Vendor Filter |
| Only part of the range | Item Filter |
| Different margin for an item category or item | Category Margins |
| Prices in a foreign currency | Currency Code |
| Catch supplier data errors | Safety Max Change % |
| No price flapping | Min. Price Change % + Force Update After (Days) |
| Review larger changes | Approval Threshold % |
| Do not pass on the discount, but include freight | Include Discounts off, Include Freight Cost on |
| Calculate on an offer with enough stock | Coverage Quantity |