InventoryCS > Inventory > Reporting menu > IN On Hand window
IN On Hand window
This report provides on-hand quantity information about all inventory items specified. If this report is run in detail, each purchase of inventory currently on hand and the associated cost is presented.
This report is useful when adjusting inventory levels after taking a physical count. It is also useful for reconciling your General Ledger to your inventory records.
Process For All IN Codes / IN Code 
This check box allows you to include stock items with any Inventory Code on the report. If you leave this unselected, you must select an individual Inventory Code to include in the report. The default for this check box is checked.
Sort By / Additional Filter 
These drop-down lists allow you to sort the report or filter data using one of the predefined or user-defined fields, and to specify the range of values that you wish to include.
Start and End Ranges: Stock Number, Description, Product Type, Vendor, and Location 
The Start and End boxes allow you to define the range of items to include on the report. You can include a single item by entering the same value in both boxes. These default settings include all items that meet the remaining criteria set in the window. Type in the fields or use the Lookup to make your selections.
Print Detail / Print Condensed 
Use the Print Detail and Print Condensed buttons to specify the level of detail you want to include in the report.
Print Detail: This option will print individual purchase detail for each item on the report. This is the default option.
Print Condensed: This option will print a condensed version of the report. The condensed report is similar to the detailed report, but prints only the following:
Stock number and item description
Stock location
Last order date
Quantity on order
Quantity on hand
Print Last Cost 
Select this check box if you want to include the last cost paid for each stock item on the report. The default for this check box is unchecked.
Skip Zero Quantity 
Select this check box if you want to exclude items with a current on-hand quantity of zero. Leave this check box empty to include all items that meet the remaining criteria in the window, regardless of their on-hand quantity. The default for this check box is unchecked.
Use a custom report 
This check box is only available if you defined a custom report for this window in Controller. Select this check box if you want to run a custom report instead of the default report. The drop-down is enabled after you select the check box and you can choose the custom report you want to run. 
 
Published date: 08/16/2021