BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Category price rules

A page where you define a pricing rule for a product category (markup, margin or fixed amount on a chosen price basis) and generate a trade agreement journal of new sales prices for every product in that category.

Used by
Retail merchandising manager, Retail service
Business process
Manage sales channels
Menu item
RetailCategoryPriceRule
Main table
RetailCategoryPriceRule
Data entity
RetailCategoryPriceRuleEntity
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 page where you define a pricing rule for a product category (markup, margin or fixed amount on a chosen price basis) and generate a trade agreement journal of new sales prices for every product in that category.
What you do hereUse this page to create or expire sales price trade agreements for all products in a category at once, for a customer, price group or all customers, instead of entering each product price by hand.
ExampleFor example, set every product in a category to cost plus 50 percent markup for a channel price group and generate the journal in one step.
Category price rules 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 sales policies › Manage sales channels
Menu pathRetail and Commerce › Pricing and discounts › Category price rules
Set up firstPrice groups Microsoft Learn Trade agreement journal names Microsoft Learn
Used next byTrade agreement journals Microsoft Learn
Related pagesPricing and discount management workspace Microsoft Learn
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 price rules

Use this page to create or expire sales price trade agreements for all products in a category at once, for a customer, price group or all customers, instead of entering each product price by hand.

Steps from Microsoft

  1. Go to Retail and Commerce > Pricing and discounts > Category price rules.
  2. Select New.
  3. Set the Account code and Account selection (for example Group and a channel price group).
  4. Select the Category, enter the Amount/Percent, and choose the Rounding version.
  5. Select Generate trade agreements, enter the From date and To date, set Find next to Yes, and select Next.
  6. Select Finish to create the trade agreement journal.
  7. Review and edit the generated prices, then select Post > OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Account codeTable, Group or All; Group lets you target channel, loyalty, catalog or affiliation price groups.Microsoft Learn AccountCode
Account selectionThe customer or price group the generated agreements apply to.Microsoft Learn AccountRelation
CategoryThe product category whose products get new prices.Microsoft Learn Name
Price ruleMarkup, Margin or Fixed amount, the way the new price is derived from the basis.Microsoft Learn PriceSetupType
Price basisBase cost, Base price or Current price, the figure the rule is applied to.Microsoft Learn PriceBasis
Amount/PercentThe markup percentage, margin percentage or fixed amount to apply.Microsoft Learn AmountPercent
Rounding versionThe rounding rules applied to the generated prices.Microsoft Learn SmartRoundingGroup
Find nextWhether the generated trade agreements let the pricing engine keep searching for a lower price.Microsoft Learn

Test checklist

  1. Create a category price rule with Account code Group, a channel price group, a category, Price rule Markup and Price basis Base cost.
  2. Select Generate trade agreements, set From date and To date, and set Find next to Yes.
  3. Check the journal opens unposted and review the generated prices.
  4. Post the journal and check one product's price in the Price simulator.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Category price rulesAccount code Group for channel, catalog, affiliation or loyalty prices; reuse the same price rule for a category when prices change, and review the generated journal before postingGroup account codes create price-group specific agreements, and existing agreements can only be found and expired when the same price rule is reused. The generated journal is not posted until you post it.Creating a new price rule for a category that already has one. The old trade agreements aren't expired, so old and new prices overlap.Test: Category markup creates channel prices
Solution architect

5Design impact

Can it be undoneHard to reverse: Nothing changes until the generated journal is posted. After posting, prices are live and must be expired, which works automatically only when you reuse the same price rule. Microsoft Learn
If you change it laterGenerating prices only creates an unposted journal, so nothing changes until it is posted; expiring existing agreements works only when the same price rule (same category) is reused. Microsoft Learn
Technical architect

6Technical

Menu itemRetailCategoryPriceRule Checked in Dynamics 365
FormRetailCategoryPriceRule Checked in Dynamics 365
TableRetailCategoryPriceRuleShown as “RETAIL CATEGORY PRICE RULE TABLE” in Record infoChecked in Dynamics 365
Data entitiesRetailCategoryPriceRuleEntityCategory price rules Microsoft data model
Who can open itPrivilegesMaintain retail pricing RetailPricingMaintainDutiesMaintain retail product pricing RetailProductPricingMaintain
2 security rolesRetail merchandising manager RetailMerchandisingManagerRetail service RetailService
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail merchandising manager RetailMerchandisingManagerGive 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): Generate trade agreements, View journals, Display dimensionsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailCategoryPriceRule
Integrate withRetailCategoryPriceRuleEntity data entity Microsoft data model
Data migrationRetailCategoryPriceRuleEntity (Category price rules): loaded for each company.Microsoft Learn
Table definitionRetailCategoryPriceRule columns and relations Microsoft data model
Everyone

8Sources