BeyondERP.Newsletter
Menu

Setup page · Pricing management

Threshold discounts

A page where you view, edit and create threshold discounts only.

Used by
Retail merchandising manager, Retail operations manager, Retail service and 3 more roles
Business process
Set product prices
Menu item
GUPDiscountThreshold
Main table
RetailPeriodicDiscount
Data entity
RetailDiscountEntity
Setup steps
1 on this page
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 page where you view, edit and create threshold discounts only.
What you do hereUse this page to set up discounts that customers get when the order total reaches one or more amounts; the threshold applies per order, not per line.
ExampleFor example, a customer who buys a total of $1,000 or more of brand A items gets $100 off.
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
Menu pathPricing management › During-sales pricing › Discounts › Threshold discounts
Set up firstPrice component codes Microsoft Learn
Related pagesAll 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.

Setup steps on this page

Set up Threshold discounts

Use this page to set up discounts that customers get when the order total reaches one or more amounts; the threshold applies per order, not per line.

Steps from Microsoft

  1. Go to Pricing management > During-sales pricing > Discounts > Threshold discounts.
  2. Select New on the Action Pane (on All discounts, choose the discount type from the menu).
  3. Enter an identifier in the Discount field and a Name.
  4. On the General FastTab, select the Currency, the Price component code and the Discount concurrency mode.
  5. On the Action Pane, select Header price attribute group to choose the customers that the rule applies to.
  6. On the Lines FastTab, select New, choose the items, and set the calculation for each line.
  7. On the Validation period FastTab, set the Effective date and Expiration date.
  8. Set the Status field to Enabled.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Count non-discountable items toward thresholdWhen set to Yes, items that can't be discounted still count toward the threshold.Microsoft Learn CountNonDiscountItems
StatusOnly enabled rules are used in calculations; new rules start as disabled.Microsoft Learn Status
Price component codeThe discount price component code that the rule belongs to; use a separate code for threshold discounts.Microsoft Learn PriceComponentCodeName
Discount concurrency modeHow the discount competes or combines with other discounts on the same price component code.Microsoft Learn ConcurrencyMode

Test checklist

  1. Create a Discounts price component code for thresholds and add it to the price tree after the other discount codes.
  2. Create a threshold discount of 100 off at 1,000 for one brand and enable it.
  3. Create a sales order of 900 for that brand and check no threshold discount applies.
  4. Add lines to bring the total above 1,000 and check the discount applies.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Threshold discountsA price component code used only for threshold discounts, placed after the other discount price component codes in the price treeLearn advises creating a separate price component code for threshold discounts, not mixing them with other discount types, and sequencing it after the other discount codes, because the order total decides eligibility.Putting threshold discounts in the same price component code as other discount types, which makes the order total that is tested unclear.

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 undoneReversible: Disable, edit, enable again. Changes affect orders priced afterwards. Microsoft Learn
If you change it laterThreshold discounts are calculated after other discount types, because the order total decides whether they apply. Microsoft Learn
Technical architect

6Technical

Menu itemGUPDiscountThreshold 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 pricing service sales discount records GUPDiscountRecordMaintainView pricing service discount agreements and records GUPDiscountRecordViewDutiesInquiries into pricing service discount agreements and records GUPDiscountInquiryMaintain pricing service sales discount records GUPDiscountMaintainMaintain pricing service sales discount records GUPDiscountRecordMaintainMaintain coupons MCRCouponMaintainMaintain retail coupons RetailCouponsMaintainMaintain retail campaign discounts RetailDiscountOfferMaintainMaintain retail campaign discounts RetailDiscountOfferView
7 security roles MCRTestUserRoleRetail merchandising manager RetailMerchandisingManagerRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store manager RetailStoreManagerSales clerk TradeSalesClerkSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceSales manager TradeSalesManagerRetail merchandising manager RetailMerchandisingManagerTo use itSales clerk TradeSalesClerkRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerGive people one of these roles. On this system, 6 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): New, Price groups, Validation logs, Copy, Header price attribute group, Discount exclusion list, Fund listChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=GUPDiscountThreshold
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