Inventory Reports

Inventory | Reports

Most reports can be filtered by specifying selection criteria such as warehouse and item type, to provide additional levels of reporting.

Value by Item

This report shows inventory quantity on hand, unit cost, and value summarized by item.

Value by Item /Warehouse

This report shows inventory quantity on hand, unit cost, and value for each item in each warehouse.

Value by Type

This report shows inventory value summarized by item type.

Value by Type /Item

This report shows inventory quantity on hand, unit cost, and value grouped by item type then summarized by item.

Value by Type /Item /Warehouse

This report shows inventory quantity on hand, unit cost, and value grouped by item type, for each item in each warehouse.

Value by GL Account /Item

This report shows inventory quantity on hand, unit cost, and value grouped by Inventory GL Account then summarized by item.

Perpetual by Item

This report shows opening balance (quantity on hand), transactions and resulting balance for each item for the selected period.

Perpetual by Item /Warehouse

This report shows opening balance (quantity on hand), transactions and resulting balance for each item in each warehouse for the selected period.

Perpetual by Type /Item

This report shows opening balance (quantity on hand), transactions and resulting balance for each item, grouped by item type, for the selected period.

Perpetual by Type /Item /Warehouse

This report shows opening balance (quantity on hand), transactions and resulting balance for each item in each warehouse, grouped by item type, for the selected period.

Perpetual Summary by Item

This report shows opening balance (quantity on hand), transaction type totals (receipts, adjustments, sales, usage), and closing balance for each item for the selected period.

Perpetual Summary by Type /Item

This report shows opening balance (quantity on hand), transaction type totals (receipts, adjustments, sales, usage), and closing balance for each item, grouped by item type, for the selected period.

Lists

These list screens have a print option, and can be filtered and sorted in different sequences.

Items has options to print the materials and resources with costs for a selected item or all manufactured items.

Physical Count

Adjustments

Item Types

Warehouses

Inventory Totals

Inventory History

Other

An ODBC driver is available (free upon request for end-user versions of Pilot) for creation of custom reports via MS Access or Crystal Reports, mail merge with MS Word, and to import Pilot data to MS Excel, etc.