Finding the current inventory position
Enter the required information in some or all of the following fields on the form header to specify which parts of the inventory you want to inquire on,
- From the Action > Line menu within the entry form select Inventory Inquiry.
-
Specify this information:
- Item Code
- You must enter a valid item code in this field.
- Warehouse Code
- You can specify a warehouse to be inquired on.
- Location ID
- You can specify a location to be inquired on.
- Batch Reference From and To
- You can enter a range of batch references to be inquired on.
- Historic Date From and To
- You can enter a date range in order to inquire on historic data.
- Project Date From and To
- You can enter a date range in order to inquire on projected inventory. That is, anticipated receipts and issues.
- All History
- Check this check box to include all historical data in the inquiry.
- All Projected
- Check this check box to include all projected data in the inquiry. That is, all anticipated receipts and issues.
The following fields are automatically populated once you have completed the above fields:
- Base Item Unit
- The unit of measure that the item is held in on the Item Master. For example, cartons.
- On-Hand Quantity
- The total of receipts of the item minus allocated issues.
- Allocated Quantity
- The total of quantities that have been allocated for anticipated issues.
- Unallocated Quantity
- The on-hand quantity minus the allocated quantity.
- Reserved Quantity
- The total quantity of all issues matching the selection criteria that have the reserved flag set on the issue plus all finished receipt note lines awaiting the transfer stage.
- Unreserved Quantity
- The total of all issues matching the selection criteria that do not have the reserved flag set on the issue.
- Available Quantity
- The On-Hand Quantity minus the Allocated Quantity minus the Reserved Quantity.
- Projected Issue Quantity
- The total of anticipated issues. For example, sales orders which have not yet been actualized.
- Projected Receipt Quantity
- The total of anticipated receipts. For example, purchase orders which have not yet been actualized.
- Overdue Issue Quantity
- The total of sales orders or movement orders that should have been delivered by the current date, but have not been.
- Overdue Receipt Quantity
- The total of purchase orders or movement orders that should have been received by the current date, but have not been.
The rest of the Inventory Inquiry form contains detailed information about the individual receipts that make up the current inventory specified in your inquiry.
Note: If you do not enter a Location ID or Warehouse Code in the inquiry parameters, the Summary tab shows the details at Warehouse level. If you enter a Warehouse Code in the inquiry parameters, the balance of the reserved quantity that has no location assigned to it is displayed as the Location ID. - Save your changes.
Related topics
- Setting up the Item Master