BeyondERP.Newsletter
Menu

Report page · Cost management

Item prices

A report that prints item prices as per a date, either from the active prices or from a selected costing version.

Business process
Maintain product costs
Menu item
output:InventPriceOverview
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 report that prints item prices as per a date, either from the active prices or from a selected costing version.
What you do hereUse this report to review item prices for a date, with the option to show prices by site and by product dimensions.
Item prices 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 processManage active products › Maintain product costs
Menu pathCost management › Inquiries and reports › Predetermined cost reports › Item prices
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 itBefore and after you activate the pending costs of a costing version, and before inventory revaluation or period end.
How oftenOn demand, at each costing version update.
What the output showsOne line per item (and per dimension when VIEW options are on) with its price as per the date, from active records or the selected version. A missing price usually means no record exists for that site or date and no fallback was set.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Predetermined cost reports > Item prices.
  2. Enter the As per date the prices should apply to and, if you only want one site, select a Site.
  3. Select ACTIVE and a Costing type to print the active cost records, or select VERSION, choose the Version and set Fallback to print the pending or active records of one costing version.
  4. Under VIEW, turn on Configuration, Size, Color, Style, Site and Version when prices differ by those dimensions or you need to see which version each price comes from.
  5. Filter on the items or item group in Records to include, run the report and compare the printed prices with what you expect to activate.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads item cost records; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:InventPriceOverview Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManagerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:InventPriceOverview
Everyone

7Sources