BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Quantity discounts

A setup page where you create and manage quantity discounts, which give a percentage off or a special unit price once a customer buys at least a stated quantity of a product on one discount line.

Used by
Retail merchandising manager, Retail operations manager, Retail service and 1 more role
Business process
Create quantity discounts in Dynamics 365 Commerce
Menu item
RetailDiscountMultibuy
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 quantity discounts, which give a percentage off or a special unit price once a customer buys at least a stated quantity of a product on one discount line.
What you do hereUse this page to define quantity tiers for products or categories, with a larger discount at each higher quantity, and to assign the price groups that decide where the discount applies.
ExampleFor example, set up a 20 percent discount when a customer buys two or more tennis rackets of a particular brand.
Quantity 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

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 > Quantity discounts.
  2. Select New and enter a discount ID and name.
  3. Select Price groups and choose the price groups the discount applies to.
  4. On the Price/discount FastTab, choose Discount % or Unit price as the discount type.
  5. On the Validation period FastTab, set the start and end dates.
  6. On the Lines FastTab, select Add to add each product or category and set its unit.
  7. For each line, enter the minimum quantity and the discount per unit; add further tiers if the discount grows with quantity.
  8. Set Status to Enabled.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Discount typeWhether tiers are expressed as a percentage discount or as a specific unit price for the quantity.Microsoft Learn PeriodicDiscountType
Minimum quantityThe quantity of the line product the customer must buy to reach the tier.Microsoft Learn
Unit price / Disc. %The discounted unit price or percentage that applies at the tier.Microsoft Learn
UnitRequired unit of measure on each quantity discount line; it must match the sales line unit.Microsoft Learn UnitOfMeasure
StatusEnabled or Disabled; validation runs when the discount is enabled.Microsoft Learn Status
Discount concurrency modeExclusive, Best price or Compounded, deciding how this discount competes with others.Microsoft Learn ConcurrencyMode
Category / Product / VariantWhat each line discounts; a category line covers every product in it, including products added later.Microsoft Learn

Test checklist

  1. Create a quantity discount with two tiers whose discount rises with quantity, set the Unit, and add a price group.
  2. Enable it and run the 1020 job.
  3. Sell the lower tier quantity of one product and check the first tier discount.
  4. Sell two different products from separate lines and check they don't combine to reach a tier.
  5. Put both products in one category line and check they now combine.

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 the discount is Disabled, and the discount value must still rise as quantity rises or it fails validation when enabled. Microsoft Learn
If you change it laterQuantity tiers are checked per discount line, so combining several products to reach a tier only works if you group them in a category line; tier values must rise with quantity or the discount fails validation when enabled. Microsoft Learn
Technical architect

6Technical

Menu itemRetailDiscountMultibuy 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 RetailDiscountsViewMaintain retail multibuy RetailMultibuyMaintainMaintain retail multibuy RetailMultibuyViewDutiesMaintain 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=RetailDiscountMultibuy
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