|
Accounts Receivable - 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, inventory transactions listing, 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 the basic information about the inventory items. It shows the item numbers and description, 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 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.
Inventory Upsell Item Listing
The Inventory Upsell Item Listing provides information on the upsell inventory items assigned for a particular item. It allows you to see both the inventory item and its related upsell items. This report is useful for cross-referencing inventory items with its pre-assigned upsell items.
You can generate this report for active items only, inactive items only or both. You can also select to include upsell remark, if any.
Click on the image to enlarge view.
Inventory Substitute Item Listing
The Inventory Substitute Item Listing provides information on the substitute inventory items assigned for a particular item. This report allows you to see both the inventory item and its substitute items. It is useful for cross-referencing inventory items and their designated substitutes.
You can generate this report either for active items only, inactive items only or all 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 only the items used in invoices/sales orders, only the items used in purchase orders, only the items used in work orders, or all selected items. You can also choose to include in the report the inventory items' average and total cost 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.
Click on the image to enlarge view.
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. This report is helpful in comparing each inventory item's various costs.
You can 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. You can also select to generate the report for active items only, inactive items only or both.
Click on the image to enlarge view.
Inventory Price Listing
The Inventory Price Listing provides the inventory items' price-related information. It lists the last sale price and the date the inventory items were last sold. This report is useful in reviewing the inventory items' current prices. It also serves as a reference for any necessary price adjustments.
You can generate this report for active items only, inactive items only or all items. You also have the option to include 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.
Multi-Level Price Listing
The Multi-Level Price Listing provides information on the various price levels that have been set up for each inventory item. This report is useful for monitoring and evaluating the multi-level prices set up for each price code assigned to the inventory items.
You can select to generate report for active items only, inactive items only or all selected items. You can further select to include only the items for which multi-level prices have been set up.
Click on the image to enlarge view.
Multi-Currency Price Listing
The Multi-Currency Price Listing provides information on each item's prices in any of the various currencies set up in AccountMate. This report is helpful in reviewing the prices, in specific currencies, used in the last created sales order or invoice created for each inventory item.
Click on the image to enlarge view.
Inventory Adjustment Report
Inventory adjustments are changes in inventory item cost and quantities that are not attributable to sales or purchases. The Inventory Adjustment Report provides information on the details of inventory adjustments processed through the Inventory Adjustment function and Update Physical Count function. 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 generate this report to include the inventory item's serial #, lot # and kit #.
Click on the image to enlarge view.
Inventory Transactions Listing
The Inventory Transactions Listing shows the details of inventory item transactions that are entered in the Sales Order or Accounts Receivable module. This report lists all the inventory item transactions within a specific date range based on the entry date and/or invoice date. This report is useful in monitoring, reviewing and analyzing sales of the inventory items.
You can select to show multi-currencies in this report.
Click on the image to enlarge view.
|
