BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

Sales categories

A setup page for the sales category hierarchy, the category hierarchy assigned to the Sales category hierarchy type so that its categories can be used on sales orders.

Business process
Define order management policies for Dynamics 365 Supply Chain Management
Menu item
SalesCategoryHierarchyManagement
Data entity
CatProcurementProductCategoryEntity
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 for the sales category hierarchy, the category hierarchy assigned to the Sales category hierarchy type so that its categories can be used on sales orders.
What you do hereUse this page to classify products into sales categories, which can also control ledger posting for sales.
ExampleFor example, BEAT assigns its hierarchy BEAT-SALES to the Sales category hierarchy type, classifies its 40 bottled drinks under the category Soft drinks, and posts their revenue to main account 401100 through an inventory posting line with Item code Category.
Sales categories 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 Sales categories

Use this page to classify products into sales categories, which can also control ledger posting for sales.

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Categories > Sales categories.
  2. Create the category hierarchy if needed, and add category nodes with a Name, Code and Friendly name.
  3. Associate the hierarchy with the Sales category hierarchy type.
  4. Classify each released product in a sales category under Product categories.
  5. Set up revenue posting with Item code Category on Inventory management > Setup > Posting > Posting.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Category hierarchyThe category hierarchy that is assigned to the Sales category hierarchy type.Microsoft Learn BEAT-SALES
CategoryA category node in the hierarchy, with a name, a code and a friendly name.Microsoft Learn Soft drinks

Common errors and fixes

MessageWhat to do
Sales categories can't be selected on sales order lines.Assign the category hierarchy to the Sales category hierarchy type; only then can its categories be used on sales orders. Microsoft Learn

Test checklist

  1. Check the hierarchy is associated with the Sales category hierarchy type.
  2. Classify a released product in a sales category under Product categories.
  3. In Inventory management > Setup > Posting > Posting, Sales tab, Revenue, add a line with Item code Category and the category in Category relation.
  4. Invoice a sales order for the product and check the revenue posts to the main account set for the category.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Sales categoriesAssign one category hierarchy to the Sales category hierarchy type, then, where revenue must follow product categories, set up inventory posting with Item code = CategoryA category hierarchy can be used on sales orders only once it's assigned to the Sales category hierarchy type, and posting can then be set up by sales category instead of by item or item group.Post sales revenue by sales category or by item group?Building categories in a hierarchy that isn't associated with the Sales category hierarchy type; those categories aren't available on sales orders, so category-based revenue posting can't apply.Test: Revenue posts to the category's account

Feature management and licence

Licence or add-inOn the live system, Sales manager, Rental manager, Rental coordinator agent, Rental sales manager and Accounts receivable manager can maintain this page, and Rental representative can use it.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyThe category hierarchy itself is shared; the products classified in it are the released products of each company. Microsoft Learn
Can it be undoneReversible with effort: Categories can be changed, but products, posting lines and any open orders that use them must be updated too. Microsoft Learn
If you change it laterRevenue posting set up with Item code Category follows the category a product is classified in, so moving a product to another category changes the main account used on invoices posted afterwards. Microsoft Learn
Technical architect

6Technical

Menu itemSalesCategoryHierarchyManagement
Data entitiesCatProcurementProductCategoryEntityProcurement product categories Checked in Dynamics 365EcoResProductCategoryEntityProduct categories Microsoft data model EcoResProductCategoryHierarchyEntityProduct category hierarchies Microsoft data model
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentRental sales manager RentalSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerTo use itRental representative RentalRepresentativeGive people one of these roles. On this system, 7 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SalesCategoryHierarchyManagement
Integrate withCatProcurementProductCategoryEntity data entity Checked in Dynamics 365
Everyone

8Sources