Inventory Reports
Menu File | 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), 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), 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
Receipts
Adjustments
Item Types
Warehouses
Inventory Totals
Inventory History
Other
An ODBC driver is available (free upon request for end-user versions of BS1 costing over $199) for creation of custom reports via MS Access or Crystal Reports, mail merge with MS Word, and to import BS1 data to MS Excel, etc. There is also a free utility for importing and exporting data. Source Code is available so that programmers can modify the built-in reports and screens, and add new features. | 
