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,

  1. From the Action > Line menu within the entry form select Inventory Inquiry.
  2. 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.
  3. Save your changes.