Discounts and pricing in Dynamics 365 Commerce

Retail pricing is some of the most complex logic in any ERP. A customer scanning a product at the till should see the right price, with the right active promotion, with the right customer-tier discount, with the right tax — all computed in milliseconds. Dynamics 365 Commerce has one of the most sophisticated discount engines in mid-to-large retail; understanding it is essential to deploying it well.

Base price hierarchy. Every product has a price determined by walking a hierarchy:

1. Trade agreement — customer-specific or customer-group-specific pricing.
2. Channel-specific price — the store / e-commerce site's overriding price for the product.
3. Sales price on the product master.

The most specific applicable rule wins. Customer-specific overrides channel-specific; channel-specific overrides master.

Trade agreements. Trade agreements are pricing and discount rules attached to:

• Item + Customer combinations.
• Item group + Customer group combinations.
• All items + All customers (broad rules).
• Date ranges per rule (promotional pricing with effective dates).

A customer can have many trade agreement lines; the engine picks the best applicable price or discount automatically.

Discount engines. Beyond base prices, discounts apply additional reductions:

• Simple discount — fixed % off or fixed amount off.
• Quantity-based discount — buy 3, get 10% off.
• Mix-and-match discount — buy any 3 items from category X, pay for 2.
• Threshold discount — spend over €100 and get 15% off the total.
• Multiple-buy discount — buy product A and get product B at discount.

Each discount has:

• Discount code — unique identifier.
• Validity period — start and end dates.
• Concurrency — can this discount stack with others (e.g. customer loyalty + promotional discount) or is it exclusive.
• Channel filter — which channels (stores, e-commerce, B2B) the discount applies to.
• Customer filter — which customer groups.
• Item filter — which items or categories.

Concurrency. When multiple discounts apply to a transaction, the engine evaluates concurrency — which can combine and which are exclusive. Configurable per discount; typical patterns:

• Loyalty discount stacks with promotional discount (additive).
• Customer-tier discount and promotional discount: most specific wins (no stacking).
• Manager override: replaces all other discounts.

Loyalty. Loyalty programs integrate with the discount engine:

• Tier-based — Bronze members get 5%, Silver 10%, Gold 15%.
• Point accrual and redemption — earn points on purchases; redeem points as discount.
• Birthday rewards — special offers around customer birthdays.
• Threshold-based — spend €X this quarter and earn a discount.

Coupons. Coupons are codes the customer enters or presents at checkout (manual entry, barcode scan, mobile-app reveal). The coupon validates against rules (one-time use, multi-use, customer-specific, channel-specific) and applies its associated discount.

Tax interaction. Tax in retail is complex (sales tax in the US, VAT in EU, GST elsewhere). The pricing engine handles tax-inclusive or tax-exclusive pricing per channel, with tax computed on either the gross or net price based on configuration.

Performance. The engine runs at the till in real time; it must compute correctly in milliseconds. The store-level cache holds active prices and discounts so offline operations don't lose pricing.

Common pitfalls.

• Discount stacking surprise — too-generous concurrency lets every discount stack, eroding margin.
• Conflicting trade agreements — overlapping rules without clear precedence produce inconsistent prices.
• Expired discounts not removed — old promotions linger and confuse staff.
• Customer-tier overrides — VIP customers' tier discount unintentionally overridden by a generic promotional discount.

Operational discipline. Test every promotion at the till before going live. Document concurrency rules clearly. Review the discount catalogue quarterly to retire stale rules. The engine is powerful enough to do almost anything; that's the danger as much as the strength.