C. Inventory Report
- Bart Rogacewicz
To get to the Inventory Report screen, click on Inventory -> C. Inventory Report.
The Inventory Report function is the best way to obtain a report of the current state of your inventory. The report can be generated based on Search Criteria, or Specified Items and can be narrowed down by Department, Category or Group. You can also choose the Show Primary Supplier checkbox to display the primary supplier column.
When using the Search Criteria method, the report can be generated based on
Item Status : Choose the Item Status between the following : Active Items, Inactive Items or All Items.
QOH Status : Choose what QoH base to generate the report by. Choices are Greater than Zero, Zero or Greater, Equal to Zero, Zero or Less and Less than Zero.
Last Sold on or After : Enter the date based on which you'd like to display the results.
When using the Specified Items method, simply type the search string in the Item field.
Simply click "Generate Report" when ready.
To print the report page, click the "Print" button or press the "Enter" key when the "Print" button is highlighted.
If you'd like to export the report to a file, click the "Export Data" button or press the "Enter" key when the "Export Data" button is highlighted.
NOTE: Export to Excel only works on full versions of Microsoft Excel/Office. It does NOT work with the Office Starter 2010 and other starter/third party versions. If using any one of these, export to a Comma Separated Values (CSV) instead.
The user may also clear all the data displayed on the screen by clicking the "Clear" button or by pressing the "Enter" key when the "Clear" button is highlighted.