Home  Contact Us  Site Map
AccountMate 7 Sample Reports
Print Page
Text Size  

Purchase Order - Inventory Reports
The Inventory Reports are especially designed to help you monitor the various transactions involving the inventory items. These reports provide a wide variety of inventory item information including a list of inventory items, quantities on hand, costs, adjustments, reorder information, and much more.

Each of the Inventory Reports is especially designed to provide several options so you can narrow down data to the specific information needed. Read the information below to get a closer look at each of the Inventory Reports available in AccountMate.
Inventory Item Listing

The Inventory Item Listing provides basic information about the inventory items. This report shows the item numbers and descriptions, class, product line, type, units of measurement, status, cost method, standard cost per unit, last sale price, among other information. This report helps you monitor the inventory items. It also serves as a reference when creating new inventory item records.

You can select to generate this report for active items only, inactive items only or both. You can also select to include in the report the unit price and item remarks, and to show any one or both the units of measurement used for sales and purchase transactions. You can further select to generate this report for items used in invoices/sales orders only, items used in purchase orders only, items used in work orders only or all selected items.


Click on the image to enlarge view.
Warehouse Quantity Listing

The Warehouse Quantity Listing provides information on inventory item quantities in each of the warehouses that your company has maintained. This report is useful for determining which inventory items are stored in each warehouse, among other details. You can use this report in managing the inventory items, particularly in determining each inventory item's current volume level, availability, and movement within a specific warehouse.

You can select to generate this report for active items only, inactive items only or both. You can also select to include the items used on invoices/sales orders only, items used in purchase orders only, items used in work orders only or all selected items. You can also choose to include in the report the inventory item's average and total costs as well as its unit price and total sale value. You may opt to exclude in the report the inventory items with zero on-hand quantities and those with zero total cost. You can further select to include in the report the inventory item's serial #, lot # and kit #.


Click on the image to enlarge view.
Inventory Cost Listing

The Inventory Cost Listing provides the inventory items' cost related information including the unit cost, cost method, inventory cost, standard cost, and return cost. This report is helpful in comparing each inventory item's various costs.

You can select to generate this report for active items only, inactive items only or both. You can also opt to generate this report for items used in invoices/sales orders only, items used in purchase orders only, items used in work orders only or all selected items.


Click on the image to enlarge view.
Inventory Adjustment Report

Inventory adjustments are changes in inventory item quantities and costs that are not attributable to sales or purchases. The Inventory Adjustment Report provides information on the details of inventory adjustments recorded through the Inventory Adjustment and Update Physical Count functions. These pieces of information include the warehouse and bin, item numbers and descriptions, adjustment dates and remarks, units of measurement, adjustment quantities, unit costs, and adjustment values. This report is useful for monitoring the inventory adjustments made during a specific period and for verifying the authenticity of the adjustment transactions that affect the inventory quantities and balance. You can also select to include in this report the inventory item's serial #, lot # and kit #.


Click on the image to enlarge view.
Inventory Reorder Report

The Inventory Reorder Report provides information on inventory items that need to be reordered from vendors. This report gives you the specific inventory items that are out of stock or whose on-hand quantities reach the reorder points. This report is useful in maintaining optimum inventory levels. It can also be used as a reference when re-ordering stocks.

You can select to generate this report only for items suggested to be reordered, only for out of stock items or all selected items. You can opt to include the items used in invoices/sales orders, items used in purchase orders only, items used in work orders only, or all selected items. You also have an option to show active items only, inactive items only or both.


Click on the image to enlarge view.
Print