Stock On Hand Enquiry
Follow
George Sutton
Updated : Created :
The Stock On Hand Enquiry enables you to review your stock on hand, as it was at the end of any given date. This allows you to review your inventory's current standing, as well as compare it to previous dates.
Go to Reports | Inventory | Stock On Hand Enquiry. The available filters and columns are outlined below:
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:
- Global: 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. The supplier must be set as the default supplier for products otherwise you will see no products in the report results.
- 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. Note: Avg Cost is rounded to 2 decimal places when displayed in this report. |
| Total Cost |
Total Landed Costs Note: Due to rounding the Avg Cost, you may see a difference in the total cost when multiplying quantity by average cost. |
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 How to Create Default Grid Layouts