BeyondERP.Newsletter
Menu

Setup page · Inventory management

Pricing template

A setup page where you create pricing templates that, with their quantity and margin templates, set the pricing rules for commodity price and margin calculations.

Used by
Accounts payable manager, Auditor, Purchasing manager and 1 more role
Business process
Maintain inventory levels
Menu item
PdsComdPricingTemplate
Main table
PdsComdPricingTemplate
Data entity
PdsCommodityPricingTemplateEntity
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 where you create pricing templates that, with their quantity and margin templates, set the pricing rules for commodity price and margin calculations.
What you do hereUse this page to define the cost multiplier and margin for formula items, item groups and customers when new sales prices are calculated.
ExampleFor example, a company can set up a pricing template so that the sales price of apple sauce is based on a 45 percent margin and a cost multiplier of 1.25 for all quantities.
Pricing template 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 processMaintain inventory levels
Menu pathInventory management › Setup › Commodity pricing › Pricing template
Used next byCreate price and margin data Microsoft Learn Inventory and warehouse management parameters Microsoft Learn
Related pagesCost basis type 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.

Step by step, with screenshots

Set up Pricing template1 screen

Use this page to define the cost multiplier and margin for formula items, item groups and customers when new sales prices are calculated.

  1. Screen 1

    Create a commodity pricing template

    Go to Inventory management > Setup > Commodity pricing > Pricing template

    1. Select New
    2. Enter the pricing template code and description
    3. Select Save
    4. Select Quantity and margin template to add the cost multiplier and margin by quantity
    1Pricing templateBEAT-PT
    DescriptionPricing template
    Create a commodity pricing template (zoomed on the outlined fields)
    Show the full screenCreate a commodity pricing template
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Inventory management > Setup > Commodity pricing > Pricing template.
  2. Select New, and enter the Pricing template and a Description.
  3. Select Save.
  4. Select Quantity and margin template, and then select New.
  5. Enter the Item relation and the Site.
  6. Set the Cost multiplier and the Margin percentage.
  7. On the Dimension FastTab, enter the Warehouse if needed, and then select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Item RelationAll formula items, one item group or one formula item; only items with the Formula production type can be used.Microsoft Learn
Customer RelationAll customers, a customer group or one customer; it's copied to the trade agreement journal that the calculation creates.Microsoft Learn
From and To QuantityThe sales quantity range that the line applies to.Microsoft Learn
Cost MultiplierA multiplier applied to the total production cost of the formula item before the margin is calculated.Microsoft Learn
Margin amount or percentageA fixed margin, or a percentage of the multiplied cost.Microsoft Learn
Pricing templateCOMMODITYPricingTemplateId
DescriptionA description of the pricing template.Checked in Dynamics 365Pricing templateDescription

Test checklist

  1. Create a pricing template with a quantity and margin line for one formula item, a customer relation, a From and To Quantity range, a Cost Multiplier and a margin percentage.
  2. Enter a Pricing calculation for the commodity raw material with a cost and a date range.
  3. Run Create price and margin data with that pricing template and check the Pricing update page shows a new cost and sales price for the formula item.
  4. Create the trade agreement from Pricing update, post it, and check a new sales order line for that customer and quantity picks up the new price within the date range.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Pricing templateOne pricing template per pricing policy, with quantity and margin lines by item relation (all formula items, item group or formula item) and customer relation; set the main one as the default Pricing template on the Commodity pricing tab of Inventory and warehouse management parametersThe pricing template, with its quantity and margin templates, defines the pricing criteria used in the formula calculations and new price determination, and the parameter default is the template used when you generate a pricing and margin update.Adding items that aren't formula items to the quantity and margin lines. Only items whose production type is Formula can be used, so other items never get a calculated sales price.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: You can change the cost multiplier and margin lines at any time. Changes apply to the next Create price and margin data calculation. Trade agreement journals already posted from an earlier calculation are not changed; they stay valid for that calculation's date range. Microsoft Learn
Technical architect

6Technical

Menu itemPdsComdPricingTemplate Checked in Dynamics 365
FormPdsComdPricingTemplate Checked in Dynamics 365
TablePdsComdPricingTemplateShown as “Commodity pricing template” in Record infoKey field: PricingTemplateIdChecked in Dynamics 365
Data entitiesPdsCommodityPricingTemplateEntityCommodity pricing templates Microsoft data model
Who can open itPrivilegesMaintain commodity pricing templates PdsComdPricingTemplateMaintainView commodity pricing templates PdsComdPricingTemplateViewDutiesCommodity 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

7Developer

Open it by URLhttps://<your-environment>/?mi=PdsComdPricingTemplate
Integrate withPdsCommodityPricingTemplateEntity data entity Microsoft data model
Data migrationPdsCommodityPricingTemplateEntity (Commodity pricing templates): loaded for each company, in Microsoft's default template 300 - Inventory.Load order: Microsoft's default template 300 - Inventory loads Commodity pricing templates at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionPdsComdPricingTemplate columns and relations Microsoft data model
Everyone

8Sources