AMLAN 12 Sample Reports


Manufacturing - 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 in each warehouse and bin, inventory costs, inventory quantities and usage, inventory adjustments, 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.


Click image to enlarge/reduce view


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 show the inventory items’ average and total costs, the unit prices and total sales value as well as the inventory items’ serial, lot and kit numbers, if applicable. You also have the option to exclude from the report the inventory items with zero on hand quantities and those with zero total cost.

You can 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. You can further filter the report to include only the active items, only the inactive items, or both.


Click image to enlarge/reduce view


Inventory Cost Listing

The Inventory Cost Listing provides the inventory items' cost related information including the cost method, average cost, standard cost, return cost, last received cost, and total cost. This report is helpful in comparing 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.


Click image to enlarge/reduce view


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.


Click image to enlarge/reduce 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 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, or in all modules.


Click image to enlarge/reduce view


FaceBook LinkedIn Twitter YouTube