AM Enterprise 2023 Sample Reports

The Items Listings 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, substitute items, quantities on hand in each warehouse and bin, costs, prices, adjustments, reorder information, transaction log, and much more.

Each of the Item Listings 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 Item Listings available in AccountMate.

Inventory Listing

The Inventory 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.

You can select to show in the report the inventory item list prices, item remarks, and units of measurements assigned to the item. You can filter the report to include only the items used in invoices/sales orders, only the items used in purchase orders, only the items used in work orders, or all items that meet the specified report criteria. You also have the option to generate this report only for inventory items assigned with active status, only for inactive items, or all items.

Item Specification Listing

The Item Specification Listing shows a summary of item specifications created and assigned to inventory using the Item Specification Maintenance function. This report allows you to review the specification types and codes assigned to individual inventory items. It is useful for reviewing the specification types and codes applied to each inventory item record.

You can select to generate this report for active, inactive or all items that meet the specified criteria.

Note: You must activate the Item Specification module to use the item specification features. The Item Specification module is available in AccountMate Enterprise 2018 and higher versions.

Inventory GL Account Listing

The Inventory GL Account Listing provides information on GL Accounts setup for the inventory items. This report is useful for reviewing the revenue and cost accounts set up for each inventory or item specification.

You can select to show on the report the details of the item specifications assigned to the inventory items. Options are available to display the Revenue and/or Contract GL Accounts set up for the inventory items. You can also choose to generate this report only for the active items, only for the inactive items, or both.

Inventory Unit of Measurement Listing

The Inventory Unit of Measurement Listing provides information on units of measurement assigned to each inventory item. Units of measurement represent the packaging scheme per unit of the inventory item. This report is useful for reviewing the unit of measurements assigned to inventory item records and transactions.

You can select to generate this report for inventory assigned with Item category, Service category or Other Charges category.

Kit Formula Listing

The Kit Formula Listing report provides information about the standard formula for each kit item. The report shows the component items that are needed to build a kit inventory item as well as the component item quantity and description. This report may include a kit inventory item that requires prebuilding or not. This report is useful for reviewing and monitoring the components included in a kit items standard formula.