BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Loyalty schemes

A setup page where you define loyalty schemes: the earning rules and redemption rules for a loyalty program, and the channels they apply to.

Used by
Retail operations manager, Retail service
Business process
Manage sales channels
Menu item
RetailLoyaltySchemes
Main table
RetailLoyaltyScheme
Data entity
RetailLoyaltySchemeEntity
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 setup page where you define loyalty schemes: the earning rules and redemption rules for a loyalty program, and the channels they apply to.
What you do hereUse this page to specify how customers earn reward points for purchases or other activities, how points are redeemed as payment, and which channels and tiers the rules cover.
ExampleFor example, a retailer creates a scheme that earns one point per dollar spent in all stores and lets customers pay with 100 points per dollar.
Loyalty schemes 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.

Setup steps on this page

Set up Loyalty schemes

Use this page to specify how customers earn reward points for purchases or other activities, how points are redeemed as payment, and which channels and tiers the rules cover.

Steps from Microsoft

  1. Go to Retail and Commerce > Customers > Loyalty > Loyalty schemes.
  2. Select New and enter a Scheme ID and Description.
  3. In the Name field, select the loyalty program and select Save.
  4. Under earning rules, select Add line, choose the Activity type, amount or quantity, currency, Reward point ID and Reward points.
  5. Under redemption rules, select Add line, choose the Reward point ID, Reward points, Redemption type, Amount or quantity and Currency.
  6. Under channels, select Add line and move organization nodes to Selected organization nodes.
  7. Select Save and run Process loyalty schemes.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Scheme IDIdentifier of the scheme.Microsoft Learn LoyaltySchemeId
Name (loyalty program)The loyalty program the scheme belongs to.Microsoft Learn
Activity typeWhat earns points: purchase by amount, by quantity, or sales transaction count.Microsoft Learn
Activity amount/quantityMinimum amount or quantity per transaction that triggers the earning rule.Microsoft Learn
Reward point IDThe reward point type earned or redeemed by the rule.Microsoft Learn
Reward pointsPoints earned per activity unit or needed per redemption unit.Microsoft Learn
Redemption typeWhether points pay by currency amount or by item quantity.Microsoft Learn
Excluded affiliationsAffiliations whose members cannot earn points under the scheme.Microsoft Learn

Test checklist

  1. Create a scheme with an earning rule (Purchase products by amount, 10.00) and a redemption rule.
  2. Add a test store, then run Process loyalty schemes and 1050.
  3. Sell 9.00 with a loyalty card and check no points are earned; sell 10.00 and check points are earned.
  4. Pay with the loyalty payment method and check points are redeemed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Loyalty schemesActivity amount/quantity 1.0 for Sales transaction count rules; staff and wholesale affiliations listed under Excluded affiliationsLearn says to always use 1.0 for Sales transaction count, and excluded affiliations stop customers with special pricing from earning points.Forgetting that earning rules are cumulative: a customer who matches a tier line and an affiliation line earns both.
Solution architect

5Design impact

Can it be undoneReversible: Any change to a scheme's rules or channels takes effect in stores only after Process loyalty schemes and 1050 run. Microsoft Learn
If you change it laterChanging a scheme's channels or rules has no effect in the stores until Process loyalty schemes and the 1050 job are run; earning rules that a customer qualifies for are cumulative. Microsoft Learn
Technical architect

6Technical

Menu itemRetailLoyaltySchemes Checked in Dynamics 365
FormRetailLoyaltySchemes Checked in Dynamics 365
TableRetailLoyaltySchemeShown as “LOYALTY SCHEMES” in Record infoKey field: LoyaltySchemeIdChecked in Dynamics 365
Data entitiesRetailLoyaltySchemeEntityLoyalty schemes 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
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailLoyaltySchemes
Integrate withRetailLoyaltySchemeEntity data entity Microsoft data model
Data migrationRetailLoyaltySchemeEntity (Loyalty schemes): shared by all companies.Microsoft Learn
Table definitionRetailLoyaltyScheme columns and relations Microsoft data model
Everyone

8Sources