BeyondERP.Newsletter
Menu

Master data page · Retail and Commerce

Affiliations

A setup page where you define affiliations: named groups of customers (such as students, seniors or employees) that receive specific prices and discounts through price groups.

Used by
Retail operations manager, Retail service
Business process
Use affiliations to create pricing and discounts in Dynamics 365 Commerce
Menu item
RetailAffiliations
Main table
RetailAffiliation
Data entity
RetailAffiliationEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define affiliations: named groups of customers (such as students, seniors or employees) that receive specific prices and discounts through price groups.
What you do hereUse this page to create affiliations and link price groups to them, so that customers who belong to the affiliation, or anonymous shoppers who present a membership card, get the associated pricing and discounts.
ExampleFor example, a retailer creates a Student affiliation with a 10 percent discount price group; a cashier adds it to a transaction when the shopper shows a student card.
Affiliations 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 > Customers > Affiliations.
  2. Select New.
  3. Enter a name and a description for the affiliation.
  4. Select Price groups.
  5. Select Add and choose the price group that carries the affiliation's prices and discounts.
  6. Close the price groups page and save.
  7. Link the same price group to the discounts or trade agreements the affiliation should receive.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
NameName of the affiliation.Microsoft Learn Name
DescriptionDescription of the affiliation.Microsoft Learn Description
Price groupsPrice groups whose prices and discounts apply to members of the affiliation.Microsoft Learn
Hide in channelsHides the affiliation from the POS while its pricing still applies.Microsoft Learn HideInChannels

Test checklist

  1. Create an affiliation with its own price group (not shared with channels or loyalty).
  2. Link a discount to that price group and add the affiliation to a test customer.
  3. Sell to the customer in POS and check the discount applies.
  4. Set Hide in channels and check the cashier can't see or remove the affiliation but the discount still applies.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneReversible: Affiliations and their price groups can be changed any time. Hide in channels only stops cashiers seeing, adding or removing the affiliation in POS; its prices and discounts still apply. Microsoft Learn
If you change it laterHiding an affiliation in channels stops cashiers seeing or changing it but does not stop its prices and discounts applying; a customer can belong to several affiliations at once. Microsoft Learn
Technical architect

5Technical

Menu itemRetailAffiliations Checked in Dynamics 365
FormRetailAffiliations Checked in Dynamics 365
TableRetailAffiliationShown as “LOYALTY PROGRAM” in Record infoKey field: NameChecked in Dynamics 365
Data entitiesRetailAffiliationEntityRetail affiliations Microsoft data model RetailLoyaltyEntityLoyalty program Microsoft data model
Who can open itPrivilegesMaintain retail loyalty schemes RetailLoyaltySchemesMaintainDutiesMaintain retail labels RetailLabelsMaintainMaintain retail loyalty RetailLoyaltyMaintain
2 security rolesRetail operations manager RetailOperationsManagerRetail service RetailService
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail operations manager RetailOperationsManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Translations, Info codes, Price groupsChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=RetailAffiliations
Integrate withRetailAffiliationEntity data entity Microsoft data model
Data migrationRetailAffiliationEntity (Retail affiliations): shared by all companies, in Microsoft's default template 500 - Retail.RetailLoyaltyEntity (Loyalty program): shared by all companies.Load order: Microsoft's default template 500 - Retail loads Retail affiliations at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionRetailAffiliation columns and relations Microsoft data model
Everyone

7Sources