BeyondERP.Newsletter
Menu

Inquiry page · Warehouse management

On-hand by location

An inquiry page that shows the locations of a warehouse and, for the selected location, the on-hand inventory it holds.

Used by
Product designer, Product design manager, Maintenance clerk and 26 more roles
Business process
Analyze inventory levels
Menu item
WHSOnHand
Main table
WMSLocation
Data entity
WMSWarehouseLocationEntity
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 locations of a warehouse and, for the selected location, the on-hand inventory it holds.
What you do hereUse this page to check the on-hand inventory of a site, warehouse or location.
On-hand by location 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 › On-hand by location
Related pagesPhysical on-hand inventory 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 > On-hand by location.
  2. Use the fields at the top of the page to define the site, warehouse and location you want to look up.
  3. Select Refresh at the right side of the Action Pane.
  4. Select a row in the Locations section to see the on-hand inventory for that location in the On hand section.

Source: 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 itemWHSOnHand Checked in Dynamics 365
FormWHSOnHand Checked in Dynamics 365
TableWMSLocationShown as “LOCATIONS” in Record infoKey field: inventLocationId, wMSLocationIdChecked in Dynamics 365
Data entitiesWMSWarehouseLocationEntityWarehouse locations Microsoft data model
Who can open itPrivilegesMaintain on-hand inventory records WHSOnHandMaintainView on-hand inventory details WHSOnHandViewDutiesMaintain quality inspection InventQualityInspectionMaintainInquire into related inventory status InventRelatedInventoryStatusInquireInquire into inventory status InventStatusInquireMaintain physical quantity adjustment WMSPhysicalQuantityAdjustmentMaintainMaintain warehouse operation master WMSWarehouseOperationMasterMaintain
29 security rolesProduct designer BOMProductDesignerProduct design manager BOMProductDesignManagerMaintenance clerk EntAssetMaintenanceClerkMaintenance manager EntAssetMaintenanceManagerField Service Integration User FieldServiceIntegrationUserInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkMaterials manager InventMaterialsManagerQuality control clerk InventQualityControlClerkQuality control manager InventQualityControlManagerReceiving clerk InventReceivingClerkShipping clerk InventShippingClerkAccounting manager LedgerAccountingManagerProduction manager ProdProductionManagerProduction supervisor ProdProductionSupervisorProject assistant ProjProjectClerkProject manager ProjProjectManagerRetail service RetailServiceRetail store manager RetailStoreManagerProcess engineer RouteProcessEngineerService delivery manager SMAServiceDeliveryManagerBuying 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 set it up or change itWarehouse worker WMSWarehouseWorkerQuality control clerk InventQualityControlClerkTo use itWarehouse manager WMSWarehouseManagerProduction supervisor ProdProductionSupervisorField Service Integration User FieldServiceIntegrationUserProcess engineer RouteProcessEngineerShipping clerk InventShippingClerkGive people one of these roles. On this system, 29 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Work details, Set as defaultChecked in Dynamics 365
Developer

6Developer

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

7Sources