BeyondERP.Newsletter
Menu

Job page · Inventory management

Pricing calculation

A page where you enter the commodity prices of raw materials and the dates they apply to.

Used by
Accounts payable manager, Auditor, Purchasing manager and 1 more role
Business process
Develop sales pricing strategy
Menu item
PdsComdPricingRun
Main table
PdsComdPricingRun
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 enter the commodity prices of raw materials and the dates they apply to.
What you do hereUse this page to record changing commodity costs so that the cost and sales price of the products made from them can be updated.
ExampleFor example, a company that makes apple sauce enters the weekly exchange price of apples, such as 0.14 per pound for one week and 0.15 for the next.
Pricing calculation 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 › Pricing calculation
Set up firstCost basis type Microsoft Learn
Used next byCreate price and margin data 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 itWhenever the purchase price of a commodity raw material changes on its exchange, before you recalculate costs and prices of the products made from it.
How oftenAs often as the commodity is priced: daily, weekly or monthly, depending on the market.
What the output showsA pricing calculation record for the cost basis, site and date range, with one line per commodity item and its new cost. A wrong sales price later on usually traces back to a wrong cost or date range here.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Commodity pricing > Pricing calculation.
  2. Select New, then select the Cost basis type (the commodity market, such as NYMEX) and enter the Site.
  3. Set the Run effective date and Run expiry date to the period the commodity prices apply to, for example the whole month when prices are set at the start of the month.
  4. Select Save, then select Commodity pricing. Add a line for each raw commodity with the Item number, Warehouse and New cost. Several commodities with the same cost basis and dates can share one pricing calculation.
  5. Save and close the page, then check that each commodity line shows the cost you entered for the right dates before you create price and margin data.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Cost basis typeThe commodity market that the prices come from.Microsoft Learn CostBasisType
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneYes, until used: You can change or delete the pricing calculation before you run Create price and margin data. Trade agreements created from it later must be handled separately. Microsoft Learn
If you change it laterRecords commodity costs that Create price and margin data uses to recalculate cost and sales prices of formula items. Microsoft Learn
Technical architect

5Technical

Menu itemPdsComdPricingRun Checked in Dynamics 365
FormPdsComdPricingRun Checked in Dynamics 365
TablePdsComdPricingRunShown as “Pricing calculation” in Record infoKey field: PricingRunId, CostBasisType, InventSiteIdChecked in Dynamics 365
Who can open itPrivilegesMaintain commodity pricing calculation PdsComdPricingRunMaintainView commodity pricing calculation information PdsComdPricingRunViewDutiesCommodity 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=PdsComdPricingRun
Table definitionPdsComdPricingRun columns and relations Microsoft data model
Everyone

7Sources