BeyondERP.Newsletter
Menu

Page · Retail and Commerce

Quantity on hand

An inquiry page that shows a summarised view of on-hand inventory, filtered and broken down by product, storage and tracking dimensions, with physical, reserved, ordered and available quantities.

Used by
Product designer, Product design manager, Maintenance clerk and 28 more roles
Business process
Maintain inventory levels
Menu item
RetailInventOnHandQuantity
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 a summarised view of on-hand inventory, filtered and broken down by product, storage and tracking dimensions, with physical, reserved, ordered and available quantities.
What you do hereUse this page to see where goods are, what is available, what is expected and what is reserved, and to drill into the inventory and warehouse transactions behind each figure.
ExampleFor example, add the Location storage dimension to see one row per warehouse location instead of one row per warehouse.
Quantity on hand 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 pathRetail and Commerce › Inventory management › Quantity on hand
Related pagesInventory transactions Microsoft Learn Inventory and warehouse management parameters Microsoft Learn Inventory lookup (POS) 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 Retail and Commerce > Inventory management > Quantity on hand.
  2. In the Filters pane, specify the product and locations to view, then select Apply.
  3. On the Action Pane, select Dimensions and tick the dimensions to show in the grid; select OK.
  4. Review the Physical inventory, Available physical, On order and Total available columns.
  5. Select Transactions or Warehouse transactions to see the transactions behind a value.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Physical inventoryThe quantity physically in inventory.Microsoft Learn
Physical reservedThe quantity that has been physically reserved.Microsoft Learn
Available physicalPhysical inventory minus physical reserved.Microsoft Learn
Ordered in totalQuantity on inbound orders or positive journal lines.Microsoft Learn
On orderQuantity on outbound orders or negative journal lines.Microsoft Learn OnOrder
Ordered reservedQuantity reserved against expected receipts, not yet physically available.Microsoft Learn
Available for reservationOn-hand quantity that can still be reserved.Microsoft Learn
Total availableAvailable physical plus ordered in total minus on order.Microsoft Learn

Test checklist

  1. Filter on a store item and select Apply.
  2. Add the Warehouse dimension and check one row per warehouse.
  3. Reserve a quantity on a sales order and check Physical reserved rises and Available physical falls.
  4. Check Total available = Available physical + Ordered in total - On order.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: An inquiry: filters and the dimensions you show change only the view. Filters in the Filters pane apply to the detailed source rows, not to the aggregated rows shown. Microsoft Learn
Technical architect

5Technical

Menu itemRetailInventOnHandQuantity Checked in Dynamics 365
FormInventOnhandItem 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 inventory per item InventOnhandItemViewDutiesInquire into related inventory status InventRelatedInventoryStatusInquireInquire into related inventory status InventRelatedInventoryStsInqrWithoutRepInquire into inventory status InventStatusInquireInquire into service orders SMAServiceOrderProgressInquireMaintain service orders SMAServiceOrdersMaintainInquire into warehouse operation progress WMSWarehouseOperationProgressInquire
32 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 LedgerAccountingManager MCRTestUserRoleProduction manager ProdProductionManagerProduction supervisor ProdProductionSupervisorProject assistant ProjProjectClerkProject manager ProjProjectManagerRetail service RetailServiceRetail store manager RetailStoreManagerService dispatcher SMADispatcherField service technician SMAFieldServiceTechnicianService delivery manager SMAServiceDeliveryManagerBuying agent TradeBuyingAgentCustomer service manager TradeCustomerServiceManagerCustomer service representative TradeCustomerServiceRepresentativePurchasing manager TradePurchasingManagerSales clerk TradeSalesClerkSales manager TradeSalesManagerSales representative TradeSalesRepresentativeWarehouse manager WMSWarehouseManagerWarehouse worker WMSWarehouseWorker
Checked in Dynamics 365
Roles to set it up and use itTo use itRetail service RetailServiceRetail store manager RetailStoreManagerSales manager TradeSalesManagerSales clerk TradeSalesClerkSales representative TradeSalesRepresentativeGive 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 information(Action Pane without tabs): Transactions, Warehouse transactions, Intercompany on-hand, Quantity adjustment, Released product details, DimensionsChecked in Dynamics 365
Developer

6Developer

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

7Sources