BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Price adjustments

A setup page where you create price adjustments, which change the base or trade agreement price of products, variants or categories by a percentage, an amount, or a new unit price for the price groups and dates you choose.

Used by
Retail merchandising manager, Retail operations manager, Retail service and 1 more role
Business process
Set product prices
Menu item
RetailDiscountPromotion
Main table
RetailPeriodicDiscount
Data entity
RetailDiscountEntity
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 create price adjustments, which change the base or trade agreement price of products, variants or categories by a percentage, an amount, or a new unit price for the price groups and dates you choose.
What you do hereUse this page to create, track and manage markdowns (or increases) on product prices for specific channels, catalogs, affiliations or loyalty programs without changing the product's base price.
ExampleFor example, mark down a category of last-season products by 20 percent for the stores linked to a regional price group.
Price adjustments 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 processIntroduce products › Set product prices
Menu pathRetail and Commerce › Pricing and discounts › Price adjustments
Set up firstPrice groups Microsoft Learn Commerce parameters Microsoft Learn
Used next byPrice simulator Microsoft Learn Distribution schedule Microsoft Learn
Related pagesTrade agreement journals Microsoft Learn Simple discounts 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.

Steps from Microsoft

  1. Go to Retail and Commerce > Pricing and discounts > Price adjustments.
  2. Select New and enter an ID and name for the price adjustment.
  3. Select Price groups and choose the price groups it applies to.
  4. On the Price/discount FastTab, enter the default discount percentage.
  5. On the Validation period FastTab, set the start and end dates.
  6. On the Lines FastTab, select Add and set the discount method and value for each product, variant or category.
  7. Set Status to Enabled.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
StatusEnabled or Disabled; the record can be edited only while disabled.Microsoft Learn Status
Price groupsThe price groups, and so the channels, catalogs, affiliations or loyalty programs, the adjustment applies to.Microsoft Learn
Discount percentageThe default percentage reduction applied to every line unless changed per line.Microsoft Learn
Validation periodStandard start and end dates, or a predefined discount period.Microsoft Learn
Discount methodPer line: percentage off, amount off, a new price, or a new price including tax.Microsoft Learn

Test checklist

  1. Create a Percentage off price adjustment for one product, add a channel price group and dates, and enable it.
  2. Run the Price simulator for that channel and check the active price is the trade agreement price less the percentage.
  3. Create a Unit price adjustment above the current price and check it is not used.
  4. Check a channel without the price group still shows the unadjusted price.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Number sequences

ReferenceShared or per companyNote
DiscountPer companyNew records on this page take their Discount from the RetailOfferIdEx3 reference; BEAT uses number sequence Comm_79. Checked in Dynamics 365
Solution architect

5Design impact

Can it be undoneHard to reverse: An adjustment can be disabled or expired, but deleting it loses its statistics. A Unit price adjustment above the current price is ignored. Microsoft Learn
If you change it laterThe largest applicable price adjustment changes the active price in every channel on the price group; a unit-price adjustment higher than the current price is ignored, and deleting an adjustment loses its statistics. Microsoft Learn
Technical architect

6Technical

Menu itemRetailDiscountPromotion Checked in Dynamics 365
FormRetailPeriodicDiscount Checked in Dynamics 365
TableRetailPeriodicDiscountShown as “PERIODIC DISCOUNT” in Record infoKey field: OfferIdChecked in Dynamics 365
Data entitiesRetailDiscountEntityPeriodic discount Microsoft data model
Who can open itPrivilegesMaintain retail discounts RetailDiscountsMaintainView retail discounts RetailDiscountsViewMaintain retail price adjustments RetailPromotionsMaintainMaintain retail price adjustments RetailPromotionsViewDutiesMaintain retail campaign discounts RetailDiscountOfferMaintainMaintain retail campaign discounts RetailDiscountOfferView
4 security rolesRetail merchandising manager RetailMerchandisingManagerRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store manager RetailStoreManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail merchandising manager RetailMerchandisingManagerTo use itRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerGive 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): New, Copy from, Price groups, View shared products, Validation logsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailDiscountPromotion
Integrate withRetailDiscountEntity data entity Microsoft data model
Data migrationRetailDiscountEntity (Periodic discount): loaded for each company.Microsoft Learn
Table definitionRetailPeriodicDiscount columns and relations Microsoft data model
Everyone

8Sources