BeyondERP.Newsletter
Menu

Setup step on the Category hierarchy role associations page · Product information management

Set up Category hierarchy role associations

Use this page to associate a category hierarchy with a category hierarchy type, such as Derived financial hierarchy.

Used by
Purchasing agent, Purchasing Agent - Public Sector, Product designer and 12 more roles
Business process
Develop product strategy
Menu item
EcoResCategoryHierarchyRole
Main table
EcoResCategoryHierarchyRole
Data entity
EcoResProductCategoryHierarchyRoleEntity
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 list page that shows which category hierarchy is associated with each category hierarchy type.
What you do hereUse this page to associate a category hierarchy with a category hierarchy type, such as Derived financial hierarchy.
ExampleFor example, public sector organisations associate a category hierarchy with the Derived financial hierarchy type so that they can collect and analyse posted transaction data for specific main accounts and financial dimension values.
Category hierarchy role associations 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 product strategy
Menu pathProduct information management › Setup › Categories and attributes › Category hierarchy role associations
Set up firstCategory hierarchies Microsoft Learn
In this process Set up Bulk item conversion · Set up Country of Origin Rules
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 Category hierarchy role associations

Use this page to associate a category hierarchy with a category hierarchy type, such as Derived financial hierarchy.

Steps from Microsoft

  1. Go to Product information management > Setup > Categories and attributes > Category hierarchy role associations.
  2. Select New.
  3. In the Category hierarchy type field, select the hierarchy type, for example Derived financial hierarchy.
  4. In the Category hierarchy field, open the lookup and select the category hierarchy to associate with the type.
  5. Select Save.

Source: Microsoft Learn

Test checklist

  1. Select New, choose Category hierarchy type Derived financial hierarchy and select a hierarchy, then save.
  2. Associate the derived financial hierarchy with a legal entity in General ledger.
  3. Open Derived financial hierarchies and check the hierarchy's nodes are available for filter rules.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Category hierarchy role associationsAssociate each role only with the hierarchy built for it, for example the hierarchy that holds the product portfolio to synchronise for the Common data service roleLearn says features read the hierarchy associated with their role; the global product identifier table is limited to products in the hierarchy selected for the Common data service role.Leaving a role without an association. The dependent feature has nothing to work with, for example no products are generated in the global identifier table.
Solution architect

5Design impact

Can it be undoneReversible: The association is a record you create and save; dependent processes use whichever hierarchy is associated when they run.
Technical architect

6Technical

Menu itemEcoResCategoryHierarchyRole Checked in Dynamics 365
FormEcoResCategoryHierarchyRole Checked in Dynamics 365
TableEcoResCategoryHierarchyRoleShown as “CATEGORY HIERARCHY ROLES” in Record infoKey field: CategoryHierarchy_NameChecked in Dynamics 365
Data entitiesEcoResProductCategoryHierarchyRoleEntityProduct category hierarchy roles Microsoft data model RetailEcoResCategoryHierarchyRoleEntityCategory hierarchy roles Microsoft data model
Who can open itPrivilegesCreate category hierarchy types EcoResCategoryHierarchyRoleCreateEdit category hierarchy types EcoResCategoryHierarchyRoleEditMaintain category hierarchy types EcoResCategoryHierarchyRoleMaintainView category hierarchy types EcoResCategoryHierarchyRoleViewDutiesInquire into category hierarchy details EcoResCategoryMasterInquireMaintain all category hierarchy details EcoResCategoryMasterMaintainView derived financial hierarchy filters LedgerDerivedFinancialHierarchyInquireMaintain derived financial hierarchy filters LedgerDerivedFinancialHierarchyMaintain
15 security rolesProduct designer BOMProductDesignerProduct design manager BOMProductDesignManagerChief financial officer CompanyChiefFinancialOfficerMaterials manager InventMaterialsManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerRetail catalog manager RetailCatalogManagerRetail merchandising manager RetailMerchandisingManagerRetail service RetailServiceProcess engineer RouteProcessEngineerProcess engineering manager RouteProcessEngineeringManagerPurchasing manager TradePurchasingManagerPurchasing agent VendPurchasingAgentPurchasing Agent - Public Sector VendPurchasingAgent_PSN
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProduct designer BOMProductDesignerProcess engineer RouteProcessEngineerRetail service RetailServiceRetail merchandising manager RetailMerchandisingManagerRetail catalog manager RetailCatalogManagerTo use itProduct design manager BOMProductDesignManagerProcess engineering manager RouteProcessEngineeringManagerMaterials manager InventMaterialsManagerAccountant LedgerAccountantChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 15 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=EcoResCategoryHierarchyRole
Integrate withEcoResProductCategoryHierarchyRoleEntity data entity Microsoft data model
Data migrationEcoResProductCategoryHierarchyRoleEntity (Product category hierarchy roles): shared by all companies, in Microsoft's default template 120 - Accounts payable.Load order: Microsoft's default template 120 - Accounts payable loads Product category hierarchy roles at execution unit 1, level 30, sequence 20. Lower levels load first, and entities at the same level load in sequence order.Load first: Product category hierarchies, the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionEcoResCategoryHierarchyRole columns and relations Microsoft data model
Everyone

8Sources

To cite this step: PIM-CAT-020, Set up Category hierarchy role associations. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PIM-CAT-020