AM SQL/Express 13 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 in each warehouse and bin, inventory costs, inventory quantities and usage, inventory adjustments, master or parent items that are suggested for manufacture based upon their reorder points and quantities, 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 pieces of information. This report helps you monitor the inventory items and determine the physical location of each item. It also serves as reference when creating new inventory item records.

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 items are stored in each warehouse, among other details. You can use this report as reference in managing the inventory items; 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. It lists the inventory item's unit cost, cost method, average cost, standard cost, and return cost as well as the last received cost and last landed cost from the latest landed cost accrual transaction recorded in the Purchase Order module. This report helps compare each inventory item’s various costs.

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

Inventory Material Analysis Report

The Inventory Material Analysis Report provides information about the inventory item quantities and usage. This report is a handy tool in reviewing the current availability and turnover of inventory items, in planning the production or purchase of the inventory items, and in reviewing the inventory items availability for sale or for use as components in the manufacture of other inventory items.

You can choose to include in the report only the active inventory items, only the inactive inventory items, or all the inventory items regardless of their status.

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 number 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 adjustment, only adjustments from recalculation, only adjustments from cost method change, or show all adjustment types.

Item Requiring Production Report

The Item Requiring Production Report provides information on the master or parent items that are suggested for manufacture based upon their reorder points and inventory quantities (e.g. on hand, in process, etc.). This report is useful in easily identifying the inventory items that need to be manufactured.