BeyondERP.Newsletter
Menu

Job page · Inventory management

Create price and margin data

A periodic job that recalculates the cost and sales price of manufactured items from the latest commodity prices.

Business process
Develop sales pricing strategy
Menu item
action:PdsComdPricingMarginUpdate
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic job that recalculates the cost and sales price of manufactured items from the latest commodity prices.
What you do hereUse this periodic task to find the formula items that use a commodity and work out their new cost price, sales price and margin.
ExampleFor example, the sales price of apple sauce can follow the changes in the price of the apples it's made from.
Create price and margin data 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 › Develop sales pricing strategy
Menu pathInventory management › Periodic tasks › Commodity pricing › Create price and margin data
Set up firstPricing calculation Microsoft Learn Pricing template Microsoft Learn
Used next byPrice margin update 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.

When to run it

When to run itAfter the commodity prices for the period are entered on the Pricing calculation page.
How oftenEach time a new pricing calculation is entered, so at the commodity's pricing interval.
Batch settingsRun it directly for a small number of formula items; nothing in the dialog needs batch settings.
What the output showsPrice and margin data for review: a new cost price for every formula item that uses the commodity, and a sales price and margin for items with a quantity and margin template. An item without a sales price usually has no quantity and margin template.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Commodity pricing > Create price and margin data.
  2. In Pricing calculation, select the pricing calculation that holds the new commodity prices.
  3. In Pricing template, select the template whose quantity and margin template sets the cost multiplier, margin and customer relation for each formula item.
  4. Select OK, and then select Yes. The system finds all formula items that use the commodity and runs a BOM calculation up the tree until it reaches finished goods.
  5. Open Price margin update and review the new cost price, sales price and margin for each item before you create trade agreements.

Source: Microsoft Learn

Test checklist

  1. Every formula item that uses the commodity appears.
  2. Cost prices reflect the new commodity cost.
  3. Items with a quantity and margin template have a sales price and margin.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneYes, before trade agreements: The calculated data is only for review. Nothing changes customer prices until you create and post trade agreements from Price margin update. Microsoft Learn
If you change it laterCreates price and margin data for formula items from the latest commodity prices; prices change only when trade agreements are created and posted. Microsoft Learn
Technical architect

5Technical

Menu itemaction:PdsComdPricingMarginUpdate Checked in Dynamics 365
FormPdsComdPricingMarginDialog Checked in Dynamics 365
Roles to set it up and use itTo use itPurchasing manager TradePurchasingManagerSales manager TradeSalesManagerGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=action:PdsComdPricingMarginUpdate
Everyone

7Sources