Hub module · on Microsoft AppSource

Price
Engine

Supplier offers and your own Business Central data become calculated price lists: one purchase price list per vendor, one sales price list per sales channel – with margin, rounding, fees, repricing and safety limits. Every calculation is logged, including every rejected one.

In short

What does the Price Engine do in Business Central?

The merchantCENTRAL Price Engine is a module for Microsoft Dynamics 365 Business Central (Cloud) built on the merchantCENTRAL hub. It takes the offers of your supplier connectors – or, with no connector at all, the item unit cost or your purchase price lists – and writes Business Central price lists from them: one purchase price list per vendor, whose direct unit cost flows into purchase orders and the requisition worksheet, and one sales price list per sales channel. Every sales price runs through the same pipeline: cost basis, margin, VAT, fees, rounding, list-price cap, competition and safety limits. If a price breaks a limit, it is rejected instead of published and the old price stays. Manually maintained price lists are never touched.

Feature set

From supplier offer to published price

One line per sales channel in the Price Calculation Setup holds every rule for that channel. The Example Price (Cost 100.00) column shows the effect immediately, without starting a run.

Purchase prices per vendor

One automatically maintained purchase price list per vendor, MC-<VendorNo>. Its direct unit cost – the net price less your discount – is what purchase orders and the requisition worksheet pick up. Withdrawn offers close their line on their own.

Margins with a hierarchy

Trade margin or markup, refined by margin tiers by cost and overridden by category margins: item beats vendor + category beats vendor beats category. Overstock and scarcity can shift the margin if you want them to.

Fees, gross prices, currencies

Marketplace fees (commission, payment fee, fixed fee) are priced in so your margin is what remains. B2C lists calculate gross, foreign-currency lists convert at the daily rate – and without an exchange rate on file, no price is published.

Rounding and price cap

To x.99, x.90, x.95, commercial rounding – or your own price points per price band. Use List Price as Max keeps the price from going above the lowest supplier list price (RRP).

Derived channels, tiers, promotions

One channel follows another: “eBay = shop + 5%”. Quantity tiers follow the price automatically, and time-limited promotional prices run alongside the regular price – which applies again on its own once they end.

Repricing inside a corridor

Match, undercut or premium against the central competitor prices in the hub – never below the minimum price and competitor minimum margin, capped above by the list price or, without that cap, twice the calculated price. Every adjustment is logged with amount and source.

Cost basis

With a supplier connector – or without one

Each sales price list picks its own cost source. With the two Business Central sources the full pipeline is available to any company; only the mirrored purchase price lists and the list-price cap need supplier data.

Cost sourceCost basisSupplier connector
Best Supplier OfferThe cheapest offer in the hub, shaped by your supplier terms – discount, freight, insurancerequired
Item Unit CostThe unit cost on the item cardnot needed
Purchase Price ListThe lowest active purchase price line in Business Centralnot needed

Supplier terms

In the Supplier Cost Setup you record discount, shipping cost with a freight rule, and insurance per vendor, optionally per item category. Each price list decides which parts go into its calculation.

Coverage quantity

When a supplier still offers its last unit at the old price, that single unit does not set the price for the whole channel: the price comes from the offer at which the configured quantity can actually be sourced.

Freight on small parts

With Freight as Min. Margin, the supplier’s freight only drives the price where selling one unit would not cover the shipment it triggers – instead of loading freight onto every item.

Safety

Reject, slow down, hold

A supplier sends 1.00 instead of 100.00 – that must never reach a channel. If a price breaks a limit, it is rejected: the old price stays and the log gives the reason. Out of the box only the Max. Offer Price Spread is active; you set the other limits per price list, and 0 switches them off. Three further settings don’t reject but slow things down.

SettingEffectResult
Max. Offer Price SpreadApplies to all price lists, factor 4 out of the box: if an item’s most expensive offer costs more than this multiple of the cheapest – usually unit and pack prices side by side – the price is rejectedRejected
Min. PriceAbsolute floor per price listRejected
Safety Max Change %Largest change allowed against the current price – the protection against supplier data errorsRejected
Safety Min Markup %Minimum markup on cost, compared netRejected
Safety Min Contribution“Never below x per unit”, compared netRejected
Min. Price Change %Small changes are not published, so channels don’t flicker; Force Update After (Days) lets the drift through eventuallySuppressed
Approval Threshold %Larger changes don’t go live but wait as proposals in Price ApprovalsPending Approval
Fix PriceIn the Price Cockpit, until a date, with a reason – the engine leaves fixed prices alone on every pathFixed
Traceability

“Why does this item cost that?” – answered

Every calculation is logged, including the ones that produced no price. The price explanation shows, as a waterfall, which step decided the price.

  • DashboardHow many purchase and sales prices are still pending, what was calculated and rejected today, whether the engine is running.
  • Price CockpitOne row per item and channel with a traffic-light status and a focus on the morning questions: rejected, no sales price, below minimum margin, change above 10%.
  • Why This Price?The waterfall from purchase price to published price – with the margin actually applied, every fee, and the competitor adjustment with its source.
  • Price origin on documentsOn the unit price in sales quotes, orders and invoices, once you switch it on: calculated price, promotional price or another source.
  • Explain This PriceOptional, with Copilot through your own Azure OpenAI resource: the explanation in plain words. The figures come only from the log – the AI calculates nothing.
Control

See it first, then go live

New rules, a new margin, a changed fee – you see what it means for your prices before any customer does.

Price Simulation

The full pipeline runs across your whole range without writing anything: current and simulated price, change in percent, “would be rejected”. You then apply selected lines for real.

Price Approvals

Changes above the approval threshold park as proposals in the workbench – with current and proposed price and the waterfall behind them. Only Approve puts the price into force.

Migration mode

With Suspend Price List Activation the engine calculates and writes, while Business Central keeps selling at the existing prices. Afterwards you go live list by list – or all at once.

Prices with a term

In pricing mode Periodic, contract price lists – SAP Ariba catalogs or framework agreements, for example – hold their prices for a period. Next period’s prices are prepared, approved and take effect when it starts.

Price disclosure

Reference price and unit price, calculated alongside

Two figures Business Central does not know by itself – and that the German Price Indication Ordinance (PAngV) requires when selling to consumers.

Price timeline and reference price

Every price the engine puts into force goes into the Price Timeline with its date. When you create a promotional price in the cockpit, the engine shows the lowest price of the last 30 days (PAngV section 11) and the actual reduction – and asks before saving if the percentage you want to advertise isn’t covered.

Unit price from item contents

On the Item Contents page you record the content as printed on the pack – 500 g, 0.75 l. The engine derives the price per kilogram, litre, metre or square metre, and per 100 g or 100 ml for packs up to 250 g or 250 ml.

What a person decides

The engine always gives the conservative figure. Whether an item needs a unit price, or whether the exception for stepwise reductions applies, it leaves to you – and gives you the data to judge it.

Frequently asked

Price calculation in Business Central – FAQ

Does the Price Engine overwrite my manually maintained prices?

No. It only maintains the sales price lists you set up in the Price Calculation Setup and the purchase price lists prefixed MC-. Every other price list stays untouched. You can also protect individual items with Fix Price, and running promotional prices are never overwritten.

Does the Price Engine work without a supplier connector?

Yes. With the cost source Item Unit Cost or Purchase Price List it calculates on Business Central data – with margins, gross prices, rounding, price points, promotions, tiers, simulation, approvals and repricing. Only the per-vendor purchase price lists and the list-price cap need supplier data.

What happens when a supplier sends bad data?

Out of the box, the Max. Offer Price Spread applies: if an item’s offers differ by more than a factor of 4, the price is rejected. If you also set Safety Max Change %, the engine rejects any price that a data error such as 1.00 instead of 100.00 would change too much. The old price stays, the case shows up red in the Price Cockpit and counts on the Rejected Today tile. If rejections pile up after a run, the engine raises a notification.

How low can repricing go?

Never below the minimum price and the Competitor Min. Margin % – and marketplace fees sit on top of that floor like on any other price. On the way up, Use List Price as Max caps the price at the RRP; without that switch or without RRP data it rises to at most twice the calculated price. Competitor prices come from the central hub table: from marketplace connectors such as the Amazon connector, from manual maintenance or from your own sources. Stale market prices are ignored.

How do prices stay current?

Every price change – a supplier import, a unit cost, a purchase price line, a changed unit of measure – queues the item for recalculation. Each item is processed once, after every supplier import and hourly via the job queue; a daily reconciliation closes purchase price lines that no longer have a live offer. The action Create Job Queue Entries sets up the scheduled runs. Changed rules – margin, supplier terms, rounding – queue nothing by themselves: afterwards, run Recalculate Prices or Queue All Offered Items.

Does the Price Engine call external services?

Not for its calculations – all input data lives in Business Central and no credentials are needed. The only exception is the optional price explanation with Copilot, which goes to your own Azure OpenAI resource configured in the hub, not to ALTENBRAND. Separately, the app reports technical operating data to the publisher’s Application Insights account – run type, counts, duration, error codes, but no business data such as prices, margins, costs or item numbers.

Do I need Trading as well?

No. Both evaluate supplier offers, but for different purposes: the Price Engine calculates sales prices in advance, Trading picks the source of supply at the moment of the sales order. They complement each other, but neither requires the other.

What does it cost, and what do I need?

€99 per 4 weeks (net) per tenant, with a 30-day free trial. You need Microsoft Dynamics 365 Business Central version 28 or later (Cloud, Essentials or Premium) and the free hub app AD merchantCENTRAL. Sandboxes also need a licence or a running demo for the module PRICEENGINE – they are never billed.

Documentation

Manual, data sheet & online help

The complete user manual as a PDF – from setup through cost sources, margins and safety limits to repricing and the price timeline. The online help is always up to date and available right from Business Central.

User manual (PDF, German)

Installation, licensing, price calculation setup, category margins, supplier terms, fees, Price Cockpit, log, simulation, approvals, repricing, price timeline, unit price and setup examples.

Download manual

Data sheet (PDF, German)

The three-page summary: pricing rules per channel, core features, safety net, system requirements and setup – to pass on to your business team or management.

Open data sheet

Online help

Help pages for every page of the module and eleven setup examples, from an online shop to an SAP Ariba catalog – available in Business Central via the question-mark menu.

Open online help

Simulate first, then go live

Install the hub and the Price Engine from AppSource, add one line per channel to the Price Calculation Setup and run the price simulation across your range. Free for 30 days – and if you like, we will show you the engine with your own data first.