However, the list on this page is a summary. The On-hand list page is assembled from a detailed on-hand inventory table that includes all available dimensions. In the field below the name of the target field, select a logical operator (for example, starts with, equal to, or greater than).In the Filters pane, find the field that you want to filter on.
Use the Filters pane to filter the on-hand inventory list so that it includes only records where the field values match the filtering criteria.
The value equals the Available physical value plus the Ordered in total value minus the On order value.Īpply filters to find the records that you're looking for If the check box is cleared, the value excludes expected receipts. Note: If the Reserve ordered items check box is selected on the Inventory and warehouse management parameters page, the value in this field includes expected receipts. The total quantity of on-hand inventory that can be reserved. Therefore, they can't be directly picked and delivered. Items that are reserved as ordered aren't physically available in inventory. The value in this field represents the total quantity of items in outbound transactions that have a status of Ordered reserved. The total quantity that is reserved on ordered receipts. The total quantity that is included on outbound orders or that has a negative quantity in various inventory journals. The total quantity that is included on inbound orders or that has a positive quantity in various inventory journals. The available physical quantity for all the dimensions that are shown in the grid. The value equals the Physical inventory value minus the Physical reserved value. The available (not reserved) quantity that is available in physical inventory.Īvailable physical is a calculated field. The total quantity that was physically reserved. The physical quantity that is available in inventory. For information about how this behavior can affect your results, see the examples later in this topic.įor each matching item, the On-hand grid provides the following columns of inventory information. These filters apply to the results, not to the source tables.
A QuickFilter at the top of the grid provides additional filtering options. In the On-hand grid, select any column heading to sort or filter by values in that column.In the Filters pane, select Apply to generate the list of matching on-hand inventory in the On-hand grid.For information about how this behavior can affect your results, see the examples later in this topic. Note that filters that you define here apply to source tables that might be aggregated later, according to the dimensions that you've selected to show.
It shows a few of the ways that the various filtering and sorting options work together, and how those options can sometimes produce unexpected results when they are combined.
This topic describes how to use the On-hand list page to inspect on-hand inventory details.