Report On Hand

This report displays a list of parts with the current quantity on hand.

The Modify Report button allows the following report filters to be customized:

OPTIONAL TAB

• Filter by Part Custom Field - Filter the report based on a custom field, select the custom field, and then type a value to filter by. Use % for wildcard searches. If the custom field is a checkbox, use true or false.
• Order By - Select how the parts are ordered: Part Num or Location.
• Location Group - Choose a specific location group to run the report for. Leave this field blank to run for all location groups.
• Location - Choose a specific location to run the report for. Leave this field blank to run for all locations.
• Part Number - Choose a specific part number to run the report for. Leave this field blank to run for all part numbers.
• Report Title - Allows the On Hand title at the top of the report to be replaced with custom text.
• Tracking - Show only parts with matching tracking. *Accepts all tracking except for serial number type tracking.
• Show Parts With Zero Quantity - Choose to show/hide parts with zero quantity by checking/unchecking this checkbox.
• Show Parts Without Tracking - Choose to show/hide parts without tracking by checking/unchecking this checkbox.
• Format Report for Exporting - Removes the page breaks and displays the report on one long page for exporting to CSV, Excel, and other formats.
• Show Serial Numbers - Choose to show/hide serial numbers by checking/unchecking this checkbox..

CUSTOM FIELDS TAB - This report can display 3 part custom fields. Enable Display field for each field that should be displayed on the report.

COLUMNS TAB - Choose which columns to show/hide on the report by checking/unchecking the checkbox next to each column name.

PRINTER TAB - Allows a default printer to be specified for the report in each location group.