BeyondERP.Newsletter
Menu

Inquiry page · Warehouse management

Physical on-hand inventory

An inquiry page that shows the physical on-hand inventory of items, which you can filter by site, warehouse and item number.

Used by
Product designer, Product design manager, Inventory accountant and 15 more roles
Business process
Analyze inventory levels
Menu item
WHSInventPhysicalOnhand
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 shows the physical on-hand inventory of items, which you can filter by site, warehouse and item number.
What you do hereUse this page to check how much of an item is physically on hand, meaning purchased, received and registered.
Physical on-hand inventory 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 processAnalyze warehouse operations › Analyze inventory levels
Menu pathWarehouse management › Inquiries and reports › Physical on-hand inventory
Related pagesOn-hand by location 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.

Steps from Microsoft

  1. Go to Warehouse management > Inquiries and reports > Physical on-hand inventory.
  2. In the Item number field, specify the item you are looking for. You can also use the Site and Warehouse fields to filter the list.
  3. Select Refresh at the right side of the Action Pane.
  4. To change the set of columns shown in the list, select Display dimensions on the Action Pane.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Item numberThe item whose physical on-hand inventory you want to look up.Microsoft Learn
SiteFilters the list of items to one site.Microsoft Learn
WarehouseFilters the list of items to one warehouse.Microsoft Learn
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Technical architect

5Technical

Menu itemWHSInventPhysicalOnhand Checked in Dynamics 365
FormWHSInventPhysicalOnhand Checked in Dynamics 365
TableInventSumShown as “ON-HAND INVENTORY” in Record infoKey field: ItemId, InventDimIdChecked in Dynamics 365
Data entitiesInventWarehouseOnHandCDSEntityCDS inventory on-hand by warehouse Microsoft data model
Who can open itPrivilegesView on-hand physical inventory WHSInventPhysicalOnhandViewDutiesInquire into related inventory status InventRelatedInventoryStatusInquire
18 security rolesProduct designer BOMProductDesignerProduct design manager BOMProductDesignManagerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkMaterials manager InventMaterialsManagerQuality control clerk InventQualityControlClerkQuality control manager InventQualityControlManagerReceiving clerk InventReceivingClerkShipping clerk InventShippingClerkAccounting manager LedgerAccountingManagerBuying agent TradeBuyingAgentCustomer service manager TradeCustomerServiceManagerCustomer service representative TradeCustomerServiceRepresentativePurchasing manager TradePurchasingManagerSales manager TradeSalesManagerSales representative TradeSalesRepresentativeWarehouse manager WMSWarehouseManagerWarehouse worker WMSWarehouseWorker
Checked in Dynamics 365
Roles to set it up and use itTo use itWarehouse manager WMSWarehouseManagerWarehouse worker WMSWarehouseWorkerShipping clerk InventShippingClerkReceiving clerk InventReceivingClerkMaterials manager InventMaterialsManagerGive people one of these roles. On this system, 18 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Display dimensionsChecked in Dynamics 365
Developer

6Developer

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

7Sources