BeyondERP.Newsletter
Menu

Setup page · Pricing management

Mix and match discounts

A page where you view, edit and create mix-and-match discounts only.

Used by
Retail merchandising manager, Retail operations manager, Retail service and 3 more roles
Business process
Set product prices
Menu item
GUPDiscountMixAndMatch
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 mix-and-match discounts only.
What you do hereUse this page to set up discounts that customers get when they buy a specific combination of products, using line groups to set how many products are needed from each group.
ExampleFor example, a customer who buys 10 or more items of brand A gets 5 percent off items from package group B.
Mix and match 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 › Mix and match discounts
Set up firstMix and match line group setup Microsoft Learn Price component codes Microsoft Learn
Related pagesMix and match line groups 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 Mix and match discounts

Use this page to set up discounts that customers get when they buy a specific combination of products, using line groups to set how many products are needed from each group.

Steps from Microsoft

  1. Go to Pricing management > During-sales pricing > Discounts > Mix and match discounts.
  2. Select New on the Action Pane, and enter an identifier in the Discount field and a Name.
  3. On the General FastTab, select the Currency, the Price component code and the Discount concurrency mode.
  4. On the Price/discount FastTab, select the Calculation type and enter the discount terms.
  5. On the Action Pane, select Mix and match line groups to choose the line groups for this discount.
  6. On the Lines FastTab, add a line for each item or collection of items and assign a Line group to each.
  7. On the Validation period FastTab, set the Effective date and Expiration date, and then set Status to Enabled.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Calculation typeThe calculation the rule uses: deal price, percentage off, amount off, least expensive or line spec.Microsoft Learn
Percentage offThe default discount percentage for new lines on the Lines FastTab.Microsoft Learn DiscountPercentValue
Quantity limitThe maximum order quantity that the discount applies to, for all lines.Microsoft Learn
Number of least expensive linesFor the least expensive calculation, how many of the cheapest items get the discount.Microsoft Learn NoOfLeastExpensiveLines
Count non-discountable productsWhen set to Yes, items that can't be discounted still count toward the required quantity.Microsoft Learn MixAndMatchCountNonDiscountItems
Line groupThe line group that a line belongs to, which sets the number of products needed.Microsoft Learn lineGroup

Test checklist

  1. Create line groups A and B on Mix and match line group setup.
  2. Create a mix-and-match discount with Calculation type Line spec: line 1 for the qualifying items in group A at 0%, line 2 for the reward item in group B at 10%.
  3. Enable the discount.
  4. Create a sales order with one item from each line and check 10% off the reward item.
  5. Remove the qualifying item and check that the discount no longer applies.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Mix and match discountsSet up line groups first, then assign a line group to every line of the mix-and-match ruleYou must set up line groups and add them to the rule before you can select a Line group on the Lines FastTab; the Number of products needed comes from the line group.For Least expensive, the number of least-expensive products must be more than one and less than the number of products needed. For Line spec, Calculation type and Discount must be the same on all lines of a line group. Discount claims are not available for mix-and-match discounts.

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. Only enabled rules are used. Microsoft Learn
If you change it laterA rule is read-only while it is enabled, so you must disable it before you change it. Microsoft Learn
Technical architect

6Technical

Menu itemGUPDiscountMixAndMatch 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=GUPDiscountMixAndMatch
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