BeyondERP.Newsletter
Menu

Setup step on the Channel database group page · Retail and Commerce

Set up Channel database group

Use this page to create groups such as one for the cloud Commerce Scale Unit and one for store offline databases, to pick their channel schema and working folders, and to run a full data sync for every database in a group.

Used by
Retail operations manager, Retail service, Retail store IT and 1 more role
Business process
Manage sales channels
Menu item
RetailCDXDataGroup
Main table
RetailCDXDataGroup
Data entity
RetailCdxDataGroupEntity
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 isA setup page where you define groups of channel and offline databases that need the same data; each group references a channel schema and gathers the data packages that all its member databases require.
What you do hereUse this page to create groups such as one for the cloud Commerce Scale Unit and one for store offline databases, to pick their channel schema and working folders, and to run a full data sync for every database in a group.
ExampleFor example, Microsoft recommends a dummy group with no distribution schedule jobs for newly created terminals, so that no data is generated until they are ready to use.
Channel database group 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 Channel database group

Use this page to create groups such as one for the cloud Commerce Scale Unit and one for store offline databases, to pick their channel schema and working folders, and to run a full data sync for every database in a group.

Steps from Microsoft

  1. Go to Retail and Commerce > Headquarters setup > Commerce scheduler > Channel database group.
  2. On the action pane, select New.
  3. In the Name field, enter a name (for example Default) and optionally a Description.
  4. In the Channel schema field, select AX7.
  5. In the Working folders field, select File storage.
  6. On the action pane, select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
NameName of the group.Microsoft Learn
DescriptionOptional description of the group.Microsoft Learn Description
Channel schemaThe channel schema the group's databases use: AX7 for current channels, AX2012R3 for N-1 channels.Microsoft Learn
Working foldersThe working folders record used to store CDX data packages (File storage for cloud channels).Microsoft Learn Name

Test checklist

  1. Create the groups and set the Commerce channel schema (AX7) on each.
  2. Link the offline group to the required distribution schedule jobs and leave the holding group unlinked.
  3. Add a new offline database to the holding group and check Download sessions shows no sessions for it.
  4. Move it to the offline group, run Full data sync with job 9999 and check sessions are created and applied.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Channel database groupAt least two groups (one for the cloud Commerce Scale Unit, one for offline databases) plus a group with no distribution schedule jobs for new databases until they are neededLearn says at a minimum two groups should exist and highly recommends a group not linked to any job (or Pause offline synchronization) so data is generated only when required.How should new offline databases be kept from generating data before go-live?Adding many new offline databases straight into an active group. Each inherits every download session since the last full sync; Learn's example produces up to 2,000,000 sessions and severely impairs performance.
Solution architect

5Design impact

Can it be undoneReversible: Databases can be moved between groups; moving them back triggers data generation for the new group.
If you change it laterAdding a database to a group makes it inherit every download session since the last full sync, which can generate huge numbers of sessions at once and hurt performance if done at busy times. Microsoft Learn
Technical architect

6Technical

Menu itemRetailCDXDataGroup Checked in Dynamics 365
FormRetailCDXDataGroup Checked in Dynamics 365
TableRetailCDXDataGroupShown as “COMMERCE DATA EXCHANGE CHANNEL DATABASE GROUP” in Record infoKey field: NameChecked in Dynamics 365
Data entitiesRetailCdxDataGroupEntityCommerce Data Exchange channel database group Checked in Dynamics 365
Who can open itPrivilegesMaintain Retail Commerce Data Exchange RetailCDXMaintainDutiesManage Commerce Data Exchange: Synch Service RetailCDXMaintain
4 security rolesRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store IT RetailStoreITRetail 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 store manager RetailStoreManagerRetail store IT RetailStoreITGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Full data sync, Store hoursChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailCDXDataGroup
Integrate withRetailCdxDataGroupEntity data entity Checked in Dynamics 365
Table definitionRetailCDXDataGroup columns and relations Microsoft data model
Everyone

8Sources

To cite this step: RC-CDX-050, Set up Channel database group. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/RC-CDX-050