BeyondERP.Newsletter
Menu

Setup step on the Affiliation price groups page · Retail and Commerce

Set up Affiliation price groups

Use this page to see which price groups give an affiliation such as students, seniors or employees its prices and discounts.

Used by
Retail merchandising manager, Retail operations manager, Retail service and 1 more role
Business process
Manage sales channels
Menu item
RetailPriceDiscGroupAffiliations
Main table
PriceDiscGroup
Data entity
PriceDiscLineDiscountCustomerGroupEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry page that lists, for each price group, the affiliations (customer groups) and the discounts linked to it.
What you do hereUse this page to see which price groups give an affiliation such as students, seniors or employees its prices and discounts.
ExampleFor example, a student affiliation price group can carry a discount that a customer receives simply by showing a membership card at the POS.
Affiliation price groups 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 processDevelop sales policies › Manage sales channels
Menu pathRetail and Commerce › Pricing and discounts › Price groups › Affiliation price groups
Set up firstAll price groups Microsoft Learn Affiliations (Price groups) Microsoft Learn
Used next byAll discounts Microsoft Learn
Related pagesLoyalty price groups Microsoft Learn Set up an affiliation and its discounts (AX 2012) Microsoft Learn
In this process Set up Register offline status · Set up Category images
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 Affiliation price groups

Use this page to see which price groups give an affiliation such as students, seniors or employees its prices and discounts.

How to use it

  1. Go to Retail and Commerce > Pricing and discounts > Price groups > Affiliation price groups.
  2. Use the Filter box to find a price group; the list shows the price groups of this type.
  3. Under Affiliations, review which affiliations the price group is assigned to.
  4. Under Price adjustments and discounts, review the discounts and price adjustments that use the price group.
  5. Price groups are created on All price groups; New and Delete are disabled here.

Source: Checked in Dynamics 365

Test checklist

  1. Link a Student affiliation price group and a Houston store price group to a discount and turn on Match all associated price groups.
  2. Enable the discount and run the distribution jobs.
  3. Add the Student affiliation to a sale in the Houston store and check the discount applies.
  4. Repeat in another store and check it doesn't apply.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Affiliation price groupsOne price group per affiliation; to limit an affiliation discount to one store, link the affiliation and store price groups to the discount and turn on Match all associated price groupsWith Match all associated price groups on, the discount is only considered when every linked price group applies to the transaction, which restricts affiliation discounts to chosen stores.Linking two or more channel price groups to a discount with Match all associated price groups on. A transaction belongs to only one store, so the discount never applies.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Price group links and the Match all option can be changed on the discount while it is disabled.
If you change it laterCombining an affiliation price group with a store price group on a discount and enabling Match all associated price groups limits the affiliation discount to that store. Microsoft Learn
Technical architect

6Technical

Menu itemRetailPriceDiscGroupAffiliations Checked in Dynamics 365
FormRetailPriceDiscGroup Checked in Dynamics 365
TablePriceDiscGroupShown as “PRICE GROUPS” in Record infoKey field: GroupIdChecked in Dynamics 365
Data entitiesPriceDiscLineDiscountCustomerGroupEntityLine discount customer groups Microsoft data model PriceDiscLineDiscountProductGroupEntityLine discount item groups Microsoft data model PriceDiscLineDiscountVendorGroupEntityLine discount vendor groups Microsoft data model PriceDiscMultilineDiscountCustomerGroupEntityMultiline discount customer groups Microsoft data model PriceDiscPriceCustomerGroupEntityPrice customer groups Microsoft data model PriceDiscPriceVendorGroupEntityPrice vendor groups Microsoft data model PriceDiscTotalDiscountCustomerGroupEntityTotal discount customer groups Microsoft data model PriceDiscTotalDiscountVendorGroupEntityTotal discount vendor groups Microsoft data model PriceDiscMultilineDiscountProductGroupEntityMultiline discount item groups Microsoft data model PriceDiscMultilineDiscountVendorGroupEntityMultiline discount vendor groups Microsoft data model MCRPostageDiscountCustomerGroupEntityPostage discount customer groups Microsoft data model
Who can open itPrivilegesMaintain retail discounts RetailDiscountsMaintainView retail discounts RetailDiscountsViewMaintain retail loyalty schemes RetailLoyaltySchemesMaintainDutiesMaintain retail campaign discounts RetailDiscountOfferMaintainMaintain retail campaign discounts RetailDiscountOfferViewMaintain retail labels RetailLabelsMaintainMaintain retail loyalty RetailLoyaltyMaintain
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 operations manager RetailOperationsManagerRetail merchandising manager RetailMerchandisingManagerTo use itRetail store manager RetailStoreManagerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailPriceDiscGroupAffiliations
Integrate withPriceDiscLineDiscountCustomerGroupEntity data entity Microsoft data model
Table definitionPriceDiscGroup columns and relations Microsoft data model
Everyone

8Sources

To cite this step: RC-PRICEGRP-040, Set up Affiliation price groups. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/RC-PRICEGRP-040