On-hand Inventory Report

This view allows generating various printable reports of the inventory. Click on the On-hand Inventory Report button.

 The next window will open.

Note:  There are 2 links under these buttons: How to disable popup blockers and How to print reports.

On-hand Inventory Report has 4 main filter options: Status, Date, Sort By, and Advanced Filters.

Use these filters in order to generate reports on items with specific information.

Status

You may choose one from 4 options: Balanced, Zero Balanced, All, and New. 

Balanced

Will generate a report showing only items that are currently in the inventory

Zero Balanced

Will generate a report showing only new items and items that currently do not have inventory

All

Will generate a report showing all items with & without inventory

New

Will generate a report showing only items that have never had inventory

Sort By

Here you may specify how the information in the report will be sorted: by Item Code, by Manufacturer, or by Description.

It means if you, for example, want to sort the data by Item Code, the very first column will display the data according to the Item Code.

Date

Enter the date or choose from the calendar by clicking on the  icon. The report wll display the data according to the chosen one.

Advanced Filters 

There are various advanced filters for generating reports:

Item, Manufacturer, Location, Condition, Ratio, Master Package Type, and Unit Package Type.

The Items combo box

Select the item needed to include in the report by clicking on this combo box and choosing the item:

 

Manufacturer

Select the items' Manufacturer, for which to generate a report by clicking on this combobox and choosing the manufacture:

Location

Select the items' Location, for which to generate a report by clicking on this combobox and choosing the location: 

Condition

Select the items' Condition, for which to generate a report by clicking on this combobox and choosing the condition: 

 

Ratio

Select the items' Ratio, for which to generate a report by clicking on this combobox and choosing the ratio:

Master Package Type

Select the items' Master Package Type, for which to generate a report by clicking on this combobox and choosing the master package type: 

Unit Package Type

Select the items' Unit Package Type, for which to generate a report by clicking on this combobox and choosing the unit package type: 

There are also 2 buttons: Generate Report and Refresh. 

Click Refresh to refresh the window.

Click Generate Report in order to generate report.

Report Viewer Toolbar

The Report Viewer window will open. It displays the generated report. The window contains the following Toolbar:

Export the Report

Select the Export Options by clicking button. 

Select the necessary Export format from the list.

Click Ok.

Next window will appear.

Open or Save this file on youe PC. If you do not want to perform any, click Cancel.

Printing the report

Select the Print Options by clicking button.

Then click Ok.

Next window will open.

Save file on your PC. If you do not want to perform this action, click Cancel.

The rest buttons

Refresh button allows updating the current report. 

 

Go to the First Page button allows fast moving to the first page of the report.

 

Go to the Previous Page button allows moving to the previous page of the report.

 

Go to the Next Page button allows moving to the next page of the report.

 

Go to the Last page button allows moving to the last page of the report.

 

Go to Page button allows moving to the page you choose. Enter the necessary page number and click

 

      

 

Zoom View allows selecting appropriate size of the report.

 

For additional information click on the following links:

Item Activity Report

Forecasted Inventory Report

Warehouse Activity Report

Warehouse Forecast Report

Volume Report