BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Threshold discounts

A setup page where you create and manage threshold discounts, which give a discount once the qualifying total of a transaction reaches one or more amount tiers.

Used by
Retail merchandising manager, Retail operations manager, Retail service and 1 more role
Business process
Create threshold discounts in Dynamics 365 Commerce
Menu item
RetailDiscountThreshold
Main table
RetailPeriodicDiscount
Data entity
RetailDiscountEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you create and manage threshold discounts, which give a discount once the qualifying total of a transaction reaches one or more amount tiers.
What you do hereUse this page to define the amount tiers, the discount for each tier, the products that count towards the total, and optionally the products that receive the discount.
ExampleFor example, give 30 percent off a specific item once the total for items in the Fashion category reaches $100.
Threshold discounts page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processIntroduce products › Set product prices › Create threshold discounts in Dynamics 365 Commerce
Menu pathRetail and Commerce › Pricing and discounts › Threshold discounts
Set up firstPrice groups Microsoft Learn
Used next byPrice simulator Microsoft Learn Distribution schedule Microsoft Learn
Related pagesCommerce parameters (Enable competition between exclusive threshold and other periodic discounts) Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Retail and Commerce > Pricing and discounts > Threshold discounts.
  2. On the Action Pane, select New.
  3. Enter the discount name, price groups, priority and validation period.
  4. On the Threshold discount tiers FastTab, select Add and enter the Amount for the tier and its discount.
  5. In the Calculation type field, choose how the discount is given (for example Discount lines).
  6. On the Lines FastTab, add the products or categories that count towards the threshold.
  7. If you chose Discount lines, add the products to discount on the Threshold discount lines FastTab.
  8. Set Status to Enabled.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
AmountThe transaction amount that must be reached for the tier.Microsoft Learn
Discount method / Discount valueWhether the tier gives a percentage or an amount, and how much.Microsoft Learn
Calculation typeSelecting Discount lines lets you discount specific products rather than the qualifying lines.Microsoft Learn
LinesThe products or categories whose sales amount counts towards the threshold.Microsoft Learn
Threshold discount linesThe products that actually receive the discount when the threshold is met.Microsoft Learn
Count non-discountable products towards thresholdLets items that cannot be discounted still count towards reaching the threshold.Microsoft Learn
Discount concurrency modeExclusive, Best price or Compounded; exclusive threshold discounts can be made to compete with other exclusive discounts via a parameter.Microsoft Learn ConcurrencyMode

Test checklist

  1. Create a threshold discount with two amount tiers, the second giving a larger discount, and add a price group.
  2. Enable it and run the 1020 job.
  3. Ring up a sale just above the first tier and check the first tier discount.
  4. Ring up a sale above the second tier and check the larger discount.
  5. With Count non-discountable products towards threshold on, include a product set to Prevent all discounts and check it counts towards the total but isn't discounted.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Number sequences

ReferenceShared or per companyNote
DiscountPer companyNew records on this page take their Discount from the RetailOfferIdEx3 reference; BEAT uses number sequence Comm_79. Checked in Dynamics 365
Solution architect

5Design impact

Can it be undoneOne-way: Warning: the Discount ID and Discount type are fixed once created. Tiers can be changed only while Disabled, and each tier must give at least the largest discount of the tier below or the discount can't be enabled. Microsoft Learn
If you change it laterEach higher tier must give at least as much discount as the tier below or the discount cannot be enabled; threshold discounts also feed the Prevent retail discounts product setting. Microsoft Learn
Technical architect

6Technical

Menu itemRetailDiscountThreshold Checked in Dynamics 365
FormRetailPeriodicDiscount Checked in Dynamics 365
TableRetailPeriodicDiscountShown as “PERIODIC DISCOUNT” in Record infoKey field: OfferIdChecked in Dynamics 365
Data entitiesRetailDiscountEntityPeriodic discount Microsoft data model
Who can open itPrivilegesMaintain retail discounts RetailDiscountsMaintainView retail discounts RetailDiscountsViewDutiesMaintain retail campaign discounts RetailDiscountOfferMaintainMaintain retail campaign discounts RetailDiscountOfferView
4 security rolesRetail merchandising manager RetailMerchandisingManagerRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store manager RetailStoreManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail merchandising manager RetailMerchandisingManagerTo use itRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): New, Copy from, Price groups, View shared products, Validation logsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailDiscountThreshold
Integrate withRetailDiscountEntity data entity Microsoft data model
Data migrationRetailDiscountEntity (Periodic discount): loaded for each company.Microsoft Learn
Table definitionRetailPeriodicDiscount columns and relations Microsoft data model
Everyone

8Sources