Search our Help.

Stock On Hand Enquiry

Follow

The Stock On Hand Enquiry report enables you to find the stock on hand at any date based on a number of filters. 

Go to Reports | Inventory | Stock On Hand Enquiry. The available filters and columns are illustrated in the figure.

Filters and Column Descriptions

  • Product Group: If you only want the Stock On Hand for a particular product group, then you can specify the product group.
  • Product Code and Product Description: If you only want the Stock On Hand for a particular product, then you can specify the product details.
  • Warehouse: The following options are available:
    • Blank: Displays a total across all warehouses
    • All: Displays a breakdown for every warehouse
    • Specific warehouse you have created
  • Supplier Code and Supplier Name:  If you only want the Stock On Hand for products of a particular supplier, then you can specify the supplier details.
  • Show Products:  Select "Stock on Hand", "Stock on Hand or Allocated" or "All" (includes products with no stock on hand)
Column

Description

Sale Days

The number of days it has been since the last completed sale of the specified product. 

Price Tiers

Default Sell Price and Price Tier prices (Sell Price Tier 1 to 10).

On Purchase

Total stock assigned to Placed and Costed purchase orders. Click on the link to open the Purchase Enquiry report. 

Qty On Hand

The stock on hand quantity for the product.

Allocated Qty

The total stock which has been allocated to a sales order, assembly or warehouse transfer. Click on the link to open the Product Allocations report.

Available Qty

Stock quantity available for sale (Available Qty = Qty on Hand - Allocated Qty).

Avg Cost

Average Landed Cost for the product (Average Landed Cost = Total Cost / Total Stock On Hand). Click on the link to open the Costing Analysis report.

Total Cost Total Landed Costs

 

Note: The following Hidden columns can be added to the grid: Bin Location, Product Group, Supplier Code, Supplier Name, and Unit. For more information about adding hidden columns and customizing the grid, see Customizing grid columns.

Was this article helpful?
0 out of 0 found this helpful