Describe on-hand inventory capabilities
You can check the inventory status of a product on the On-hand inventory page. On-hand inventory of a product changes based on the inventory transactions associated with the product. You can access the on-hand inventory from the Inventory management > Products > Released products page. Select any product and navigate to the action pane menu Manage inventory > View > On-hand inventory to display the on-hand stock of the item.
You can select the Dimension button in the action pane. A dialog box appears, where you can select the dimensions for which you want to see the inventory breakup.
You can also turn on the Save setup, so that the selected dimensions are always available in the On-hand page.
Based on the selected dimensions, the On-hand page displays the stock quantity.
In the preceding screenshot, the on-hand quantity is displayed in the breakup of site and warehouse as per the selected dimensions.
The On-hand page has several fields, as follows:
The Physical inventory field shows the physical quantity that is available in the inventory.
The Physical reserved field shows the quantity of items that is already reserved for outbound transactions, including sales order, production issue, and transfer.
The Available physical field is a calculated field that displays the physical inventory, which isn't reserved; that is, physical inventory minus the physical reserved quantity.
In the Available physical on exact dimensions field, you can find the available physical quantity for all the dimensions that are shown in the grid.
In the Ordered in total field, you can find the total quantity that is included in inbound orders or that has a positive quantity in various inventory journals.
In the On order field, you can find the total quantity that is included in outbound orders or that has a negative quantity in various inventory journals.
The Ordered reserved field shows the total quantity of items in outbound transactions that have a status of Ordered reserved. These items aren't physically available for picking and delivery.
The Available for reservation field shows the total quantity for on-hand inventory that can be reserved.
The Total available field is a calculated field that displays the available physical value plus the ordered in total value minus the on-order value.
On the On-hand page, you can find the Transaction button in the action pane. Selecting this button displays all the transactions related to the item.
The Quantity adjustment button in the action pane helps you to create a counting journal to adjust the inventory. We discuss the details of inventory counting later in this unit.
The Intercompany on-hand button in the action pane displays the on-hand stock of the selected item in all the other legal entities, where this product is released.
On-hand mobile workspace
On-hand inventory refers to the inventory that is available now. Typically, companies have multiple shipments and multiple receipts of inventory every day. These movements constantly change the on-hand inventory status. The Inventory on-hand mobile workspace displays the cross-company on-hand inventory status, so you can gain the latest insights into inventory data on the mobile device of your choice. Regardless of whether you work in the warehouse, purchasing, sales, manufacturing, or management, or have other roles, you can access on-hand inventory data anytime and anywhere.
The mobile workspace provides an instant view of the on-hand status across facilities. It lets you view on-hand inventory across facilities, current material reservations, and unreserved on-hand inventory. You can also enter item numbers to query on-hand inventory, and you can perform a filtered search for on-hand products or variants.
The mobile workspace provides the following features:
Search by product number or product name to view the on-hand inventory status for a product.
View the following information on selected products:
On-hand inventory per site
On-hand inventory per warehouse
On-hand inventory per location
On-hand inventory per batch (for batch-controlled products)
On-hand inventory per inventory status
View product on-hand inventory by:
Physical inventory, representing the total amount.
Physical reserved, representing the reserved amount.
Available physical, representing an available amount that has no reservations.
The following video explains the on-hand inventory of a product.
Managing inventory is one of the most important functionalities of Supply Chain Management. Inventory management links various enterprise resource planning (ERP) transactions that impact inventory control and influences the organizational business viewpoint.
Inventory counting
Inventory counting involves a process of creating and posting an inventory counting journal to count a specific item at a location in the warehouse.
Inventory counting includes the following steps:
Create an inventory counting journal - When creating the inventory counting journal, select the name you want to use and the worker you want to use.
Create journal lines - Input the item number, site, warehouse, location, and item count into the journal.
Post the inventory counting journal - When you post an inventory counting journal, if the counted amount differs from the amount that is reported in the On-hand field, an inventory receipt or issue is posted, the inventory level and value are changed, and ledger transactions are generated.
View inventory transactions - Here you can find any related transactions that are created when you post your inventory counting journal.
Reason codes
Reason codes let you analyze the results of a counting process and any discrepancies that occur during that process. You can specify the reason for doing the count, such as a broken pallet or a stock adjustment that is based on inventory samples.
Define a strategy for reason codes
We recommend you define a strategy for working with reason codes. For example, try to answer the following questions:
Should reason codes be mandatory for warehouses?
Should reason codes be mandatory or optional on some items?
How many reason codes do you require?
How should users of barcode scanners use reason codes? Should the reason codes be preselected, mandatory, or not editable?
Do warehouse workers require different reason code behavior on mobile scanners? If the answer is yes, you can create more menu items and assign them to different people.
Where reason codes apply
You can create multiple reason code policies, and each reason code policy can have two counting reason code policies. The counting reason code policies can be used at the warehouse level or the item level.
You can set up reason code policies to specify whether selection of a reason code should be an optional or mandatory action in one of the following counting journals:
Cycle Count (mobile device)
Spot Count (mobile device)
Threshold Count (mobile device)
Adjustment In (mobile device)
Adjustment Out (mobile device)
Counting Journal (rich client)
You can also set up reason codes for individual warehouses and for items. The reason code setup for products can disregard the setup for warehouses. If the Mandatory parameter is set in the configuration of reason codes for warehouses or items, the counting journal can't be completed and closed until a reason code is provided.
Reason codes for warehouses
You have the following options when configuring reason codes for warehouses:
Blank – The parameter that is set up for the item is used to determine whether counting journals are mandatory for the product.
Mandatory – A reason code is always needed on counting journals for the warehouse.
Optional – A reason code isn't needed on counting journals for the warehouse.
Reason codes for products
You can use the following options when configuring reason codes for products:
Blank – The parameter that is set up for the warehouse is used to determine whether counting journals are mandatory for the product.
Mandatory – A reason code is always required on counting journals for the product. This setting overrides any reason code setting at the warehouse level.
Optional – A reason code isn't required on counting journals for the product. This setting overrides any reason code setting at the warehouse level.
Use reason codes in counting journals
In a counting journal, you can add reason codes for counts of the following types:
Cycle Count
Spot Count
Threshold Count
Adjustment In
Adjustment Out
Reason codes are added to the journal lines in counting journals of the Counting journal type.