AM12 Sample 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 have the option to display on the report the item unit prices, inventory item remarks, and/or to one or both the units of measurement used for sales and purchase transactions. You can filter the report data to include only the inventory items that are designated for use in invoices and sales orders, only those that are designated for use in purchase orders, only those that are designated for use in work orders, or all inventory items that meet the specified criteria. You can further filter the report to include only the active items, only the inactive items, or both.

Warehouse Quantity Listing

The Warehouse Quantity Listing provides information on inventory item quantities in each warehouse that your company maintains. This report is useful for determining which inventory items are stored in each warehouse, among other details. You can use this report as a tool for inventory management, particularly in determining each inventory item’s current volume level, availability, and movement within a specific warehouse.

You have the option to exclude from the report the inventory items with zero on hand quantities and those with zero total cost. You also have the option to show the inventory items’ serial, lot and kit numbers, if applicable, as well as show the inventory items’ average and total costs, the unit prices and total sales value. You can choose to show in the report the inventory item specifications, to show both the specifications and subtotal for each item specification, or not to show item specifications at all. You can filter the report to include only the active items, only the inactive items, or both. You can further filter the report to include only the items that are designated for use in invoices/sales orders, only those designated for use in purchase orders, only those designated for use in work orders, or all items that meet the specified criteria.

The report can be filtered further to show only the items from drop ship warehouses, only the items from non-drop ship warehouses or items from all warehouses.

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 filter this report to include only the items designated for use in invoices/sales orders, only those designated for use in purchase orders, only those designated for use in work orders, or all items that meet the specified criteria. You can further filter this report to include only the active items, only the inactive items, or both.

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 and cost adjustments recorded in AccountMate. 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 and cost adjustments made during a specific period and for verifying the authenticity of the adjustment transactions that affect the inventory quantities, costs and balances.

You have options to show in the report the inventory items’ serial numbers, lot numbers, and kit numbers, if any. If you generate this report from the Sales Order, Accounts Receivable, Purchase Order or Manufacturing module, you can filter the report to show only the inventory adjustments recorded in each of those modules or in all modules. If you generate this report from the Inventory Control module, you can filter the report to show the inventory adjustments recorded in the Inventory Control module only, in the Accounts Receivable/Sales Order module only, in the Purchase Order module only, in the Manufacturing module only, in the Return Authorization module only or in all modules.

You can select to generate the report to show only inventory adjustments, only the cost adjustments, only cost adjustments from disassembled kit items, only cost rounding adjustments from purchase orders, only receipt cost adjustments from merchandise returns, only standard cost variance adjustments, only physical count adjustments, only adjustments from recalculation, only adjustments from changing cost methods, or show all adjustment types.

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 filter this report to include only the items with quantity levels that are equal to or less than their respective reorder points, only those items that have zero quantities on hand, or all items that meet the specified criteria in the report interface. You can further filter the report to include only the active items, only the inactive items, or both. Checkboxes are available for you to mark if you want the report to to display the vendors from whom you can place the order for out of stock items or those which on-hand quantities are below reorder point, to display the vendor from whom the last purchase transaction of the specific item was made, to include the items that are designated for use in purchase orders, and/or to include those items that are designated for use in work orders.

Purchase Requirement Report

The Purchase Requirement Report provides information on the inventory items and their quantities that are suggested for purchase based upon the reorder points set up for each item. These pieces of information includes the warehouse, lead time, unit costs, last received costs, available quantities, on-order quantities, safety stock levels, reorder points, quantities below reorder points, and suggested reorder quantities. This report can only be generated for inventory items that are available for use in purchase orders as set up in each inventory item record. This report is useful for monitoring and determining the inventory items that need to be purchased as of the report date.

You have the option to show in this report all inventory item quantities. You can filter this report to include only the items with quantity levels that are equal to or less than their respective reorder points, only those items that have zero quantities on hand, or all that meet the specified criteria in the report interface. You can further filter the report to include only the active items, only the inactive items, or both.