BeyondERP.Newsletter
Menu

Inquiry page · Inventory management

On-hand list

An inquiry page that summarizes on-hand inventory, showing where goods are, what is available, what is expected and what is reserved.

Business process
Maintain inventory levels
Menu item
InventOnhandItem
Main table
InventSum
Data entity
InventWarehouseOnHandCDSEntity
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 isAn inquiry page that summarizes on-hand inventory, showing where goods are, what is available, what is expected and what is reserved.
What you do hereUse this page to filter stock by product, storage and tracking dimensions and break the results down by those dimensions.
ExampleFor example, adding the Location dimension adds a Location column and shows one row per warehouse location instead of one per warehouse.
On-hand list 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 › On-hand list
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.

Steps from Microsoft

  1. Go to Inventory management > Inquiries and reports > On-hand list.
  2. In the Filters pane, enter the product and locations you want to see, and select Apply.
  3. On the Action Pane, select Dimensions and choose the dimensions to show in the grid.
  4. Optional: set Save setup to Yes so the page opens with the same dimensions next time.
  5. Use the filter at the top of the grid or the column headers to narrow what is shown.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Physical inventoryThe physical quantity in inventory.Microsoft Learn
Physical reservedThe total quantity that is physically reserved.Microsoft Learn
Available physicalThe physical quantity that isn't reserved.Microsoft Learn
Ordered in totalThe quantity on inbound orders or with a positive quantity in inventory journals.Microsoft Learn
On orderThe quantity on outbound orders or with a negative quantity in inventory journals.Microsoft Learn OnOrder
Available for reservationThe on-hand quantity that can still be reserved.Microsoft Learn
Total availableAvailable physical plus Ordered in total minus On order.Microsoft Learn
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
If you change it laterFilters in the Filters pane work on the detailed source data, not on the summarized list, so results can look unexpected; grid filters work on the list itself. Microsoft Learn
Technical architect

5Technical

Menu itemInventOnhandItem Checked in Dynamics 365
FormInventOnhandItem Checked in Dynamics 365
TableInventSumShown as “On-hand inventory” in Record infoKey field: ItemId, InventDimId, ClosedChecked in Dynamics 365
Data entitiesInventWarehouseOnHandCDSEntityCDS inventory on-hand by warehouse Microsoft data model
Roles to set it up and use itTo use itQuality control manager InventQualityControlManagerWarehouse manager WMSWarehouseManagerMaterials manager InventMaterialsManagerQuality control clerk InventQualityControlClerkProduction supervisor ProdProductionSupervisorGive people one of these roles. On this system, 31 roles can open this page.Checked in Dynamics 365
Actions on the pageView: ViewBatch tracking: Batch trackingInspect: InspectRelated information: Related informationOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=InventOnhandItem
Integrate withInventWarehouseOnHandCDSEntity data entity Microsoft data model
Table definitionInventSum columns and relations Microsoft data model
Everyone

7Sources