BeyondERP.Newsletter
Menu

Report page · Inventory management

Physical inventory by inventory dimension

A report that shows physical inventory as of a date, with options to show zero lines and to break the figures down by inventory dimension.

Business process
Maintain inventory levels
Menu item
output:InventDimPhys
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 shows physical inventory as of a date, with options to show zero lines and to break the figures down by inventory dimension.
What you do hereUse this report to see physical inventory by the inventory dimensions you switch on, and filter by item, site or warehouse before running it.
Physical inventory by inventory dimension 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 › Inquiries and reports › Physical inventory reports › Physical inventory by inventory dimension
Related pagesOn-hand list 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 itWhen you need physical on-hand quantities per dimension today or on a past date, for example for a count or an audit.
How oftenOn demand.
What the output showsPhysical inventory quantities per item and per dimension you switched on, as of the date you entered. On-hand cleanup routines remove closed zero-quantity records, so past-date results can miss a batch or location that has since dropped to zero.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Inquiries and reports > Physical inventory reports > Physical inventory by inventory dimension.
  2. Apply filters such as Item, Site and Warehouse before you run it, as the notice at the top of the dialog advises, so the report doesn't read all on-hand records.
  3. Enter the As on date to see physical inventory on a past date, and switch Show zero lines to Yes only if lines with zero quantity are needed.
  4. Use Closed transactions if dimensions whose transactions are already closed should be included.
  5. Under View, switch on the dimensions to break the figures down by, such as Warehouse, Location, Batch number or License plate.
  6. Run the report and compare the quantity per dimension with what is physically there.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
As of dateRuns the report for a past date instead of today.Microsoft Learn
Closed transactionsIncludes dimensions whose transactions are already closed.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads on-hand data. Note that cleanup routines can remove data it uses for past dates. Microsoft Learn
If you change it laterOn-hand cleanup removes zero-quantity rows, so past-date results (As of date or Closed transactions) can miss dimensions that have since dropped to zero. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:InventDimPhys Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itQuality control manager InventQualityControlManagerWarehouse manager WMSWarehouseManagerMaterials manager InventMaterialsManagerProduction supervisor ProdProductionSupervisorAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 16 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources