Use this option to generate count sheets for recording physical inventories. The sheets, which can be organized by either warehouse area or stock number, include the following information:
|
Warehouse Locations |
Stock Item Descriptions |
Warehouse Area Codes |
|
Stock Numbers |
Units of Measure |
Aisle/Bin Numbers |
As an option, you can also include stock item prices, quantities, and extended amounts. The quantity is the number of units stored in your database, while an item's extended amount is its quantity multiplied by the price.
The last column in the form provides a line for entering the physical count of each stock item. Spaces are also included with each sheet for entering the inventory date and initials of the person taking the counts.
The page's criteria fields reference fields in the Inventory Catalog. The Discontinued field, which is a checkbox in the catalog, lists the following options in the report page:
|
N-Active Items |
Selects stock items that are not marked as discontinued. This excludes all discontinued items. |
|
Y-Discontinued Items |
Selects stock items marked as discontinued. This excludes all active items. |
|
Blank |
Selects records without considering the Discontinued setting. This includes both active and discontinued items. |
Menu Path: Warehouse Inventory > Reports > Warehouse Reports > Inventory Count Report
Generating Warehouse Inventory Count Sheets
-
Select Warehouse Inventory > Reports > Warehouse Reports > Inventory Count Report to display the Inventory Count Report page.
-
In the Report Sort Options section, select one of the following:
By Area
To sort the report alphabetically by warehouse code and then by warehouse area code.
By Stock Number
To sort the report alphabetically by warehouse code and then numerically by stock number.
-
In the Additional Report Options section, select the Include Price Information checkbox to list stock item prices, quantities, and extended amounts in the report.
-
Click OK.
-
In the Report Criteria section, enter criteria identifying the records to include, and then click OK. To run an advanced search, use the Advanced button.
-
In the Print window, specify how to generate the report, and then click OK. The report's default file name is inv_ct_a.rpt if you are sorting by area or inv_ct_s.rpt if you are sorting by stock number.