BeyondERP.Newsletter
Menu

Job page · Inventory management

Price margin update

A page where you review the calculated commodity-based prices and margins and turn them into trade agreements.

Used by
Accounts payable manager, Auditor, Purchasing manager and 1 more role
Business process
Develop sales pricing strategy
Menu item
PdsComdPricingMargin
Main table
PdsComdPricingMargin
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 page where you review the calculated commodity-based prices and margins and turn them into trade agreements.
What you do hereUse this page to create trade agreements for the customers set up in the pricing template, which are then posted.
ExampleFor example, the apple sauce prices calculated for each week can be turned into trade agreements that are then approved and posted.
Price margin update 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 › Price margin update
Set up firstCreate price and margin data Microsoft Learn
Used next byTrade agreement journals 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 Create price and margin data has calculated the new prices and you have reviewed them.
How oftenEach time new price and margin data is calculated.
What the output showsLines with the calculated prices and margins, and after Update trade agreements a trade agreement journal for the customers in the template. A price missing for a customer usually means that customer isn't in the template's customer relation.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Commodity pricing > Price margin update.
  2. Select the calculation record, and then select Lines on the Action Pane to review the calculated cost, sales price and margin per item and customer relation.
  3. Select Update trade agreements, and then select OK. Trade agreements are created for the customers, or all customers, set up in the quantity and margin template.
  4. Go to Sales and marketing > Prices and discounts > Trade agreement journals and post the journal that was created. Until it's posted, no new price applies.
  5. Open the posted trade agreement and check that its prices and validity dates match the dates of the pricing calculation.

Source: Microsoft Learn

Test checklist

  1. A trade agreement journal is created.
  2. Prices in the posted journal match the reviewed lines.
  3. The agreements are valid only for the pricing calculation dates.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneYes, before posting: Delete the trade agreement journal before it's posted to discard the prices. Once posted, the prices apply for the pricing calculation dates. Microsoft Learn
If you change it laterThe trade agreements that are created are valid only for the dates of the pricing calculation that was used. Microsoft Learn
Technical architect

5Technical

Menu itemPdsComdPricingMargin Checked in Dynamics 365
FormPdsComdPricingMargin Checked in Dynamics 365
TablePdsComdPricingMarginShown as “Pricing margin” in Record infoKey field: PricingRunId, PricingTemplateId, ProfitSetChecked in Dynamics 365
Who can open itPrivilegesMaintain commodity pricing margins PdsComdPricingMarginMaintainView commodity pricing margins PdsComdPricingMarginViewDutiesCommodity pricing PdsComdPricingMaintainInquire into purchase order to invoice policies PurchOrderToInvoicePoliciesInquire
4 security rolesAuditor AuditPolicyManagerPurchasing manager TradePurchasingManagerSales manager TradeSalesManagerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerPurchasing manager TradePurchasingManagerTo use itAccounts payable manager VendInvoiceAccountsPayableManagerAuditor AuditPolicyManagerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=PdsComdPricingMargin
Table definitionPdsComdPricingMargin columns and relations Microsoft data model
Everyone

7Sources