The Product Enquiry is a powerful reporting tool that provides a complete overview of any product in your inventory. It shows you:
Current stock levels across warehouses.
Pending incoming and outgoing stock movements.
Product allocations and availability.
This tool is perfect for an up-to-date snapshot of what's happening with a product, and includes the ability to generate a PDF report with all this information.
Using the Product Enquiry
Navigate to Reports > Inventory > Product Enquiry from the main menu and populate the Warehouse and Product filters to generate a basic report with the product's On Hand, allocated quantity and location data.
Filter the Product Enquiry
Use the filter fields on the left of the Product Enquiry to specify the report's results:
Product (Required): Enter a Product Code or Product Description to search for your item. You must select a product to generate the report.
Warehouses (Optional): Choose specific warehouses from the dropdown, or leave blank to include all warehouses. Selecting multiple warehouses will show combined stock totals
Review the report
Once you've selected a product, the Product Enquiry will update to display its results in the fixed fields on the right of the page.
Product Enquiry fields | Description |
Bin Location | When filtered for a single warehouse, the Bin Location field will populate the product's warehouse bin location. When filtered for multiple warehouses or no warehouse, the field will be blank. |
Unit of Measure | Displays the product's base unit of measure. |
Barcode | Displays the barcode number of the product's base unit of measure. |
Never Diminishing | Indicates if the product is a Never Diminishing Product (NDP). |
On Hand | Displays the product's total Stock On Hand (SOH) quantity for the selected warehouses. Click on On Hand to open the Stock On Hand Enquiry. |
On Purchase | Displays the product's total base quantity ordered on Placed status Purchase Orders for the filtered warehouses. Click on On Purchase to open the Purchase Enquiry. |
On Assembly | Displays the product's total base quantity due to be assembled from open Assemblies for the filtered warehouses. Click on On Assembly to open the Production Enquiry. |
On Order | Displays the product's total base quantity allocated to open Sales Orders for the filtered warehouses. Click on On Order to open Product Allocations. |
In Assembly | Displays the product's total base quantity allocated to open Assemblies as a component for the filtered warehouses. Click on On Assembly to open Product Allocations. |
On Transfer | Displays the product's total base quantity ordered on Placed status Purchase Orders for the filtered warehouses. Click on On Purchase to open the Purchase Enquiry. |
On Quote | Displays the current total base unit quantity saved to open Sales Quotes for the filtered warehouses. Click on On Quotes to open View Quotes. |
Available | Displays the product's total stock availability for the filtered warehouses. |
Export the report
Download a PDF version of the Product Enquiry's results by clicking Print in the top right corner. The PDF report, titled "Item Enquiry", provides a complete snapshot of your product's status, including the same details as the Product Enquiry's fields, as well as:
Created by: The email address of the user who generated the report.
Created date: Exact date and time when the report was generated.
The PDF layout and formatting are standardised and cannot be customised. This ensures consistency across all reports but means you cannot change which fields appear or how they're arranged.