LAN 9 Sample Reports
|
Inventory Control - 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, substitute items, quantities on hand in each warehouse and bin, costs, prices, adjustments, reorder information, transaction log, 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 and last sale price, among other pieces of information. This report helps you monitor the inventory items. It also serves as a reference when creating new inventory item records. You can select to generate this report only for inventory items assigned with active status, only for inactive items, or all items. You can also choose to show 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 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. 
Click on the image to enlarge view. Inventory Upsell Item Listing
The Inventory Upsell Item Listing provides information about your predefined upsell items. It allows you to see both the inventory item and its related upsell items. This report is useful for cross-referencing inventory items with the upsell items assigned to them. You can generate this report only for inventory items assigned with active status, only for inactive items, or all items. You can also opt to show in the report the upsell remarks, if any. Note: You must activate the Upsell Management module in order to use the upsell features. The Upsell Management module is available in AccountMate 7 for SQL/Express/LAN and higher versions. 
Click on the image to enlarge view. Inventory Substitute Item Listing
The Inventory Substitute Item Listing provides information on the items assigned as substitutes of a particular item. This report allows you to see both the inventory item and its substitutes. This report is useful for cross-referencing inventory items with the substitute items assigned to them. You can select to generate this report only for inventory items assigned with active status, only for inactive items, or for all items. 
Click on the image to enlarge view. FIFO/LIFO Inventory Listing
The FIFO/LIFO Inventory Listing provides information on inventory items that are assigned with the First-In-First-Out (FIFO) or Last-In-First-Out (LIFO) costing method. This report is useful for reviewing the values of inventory items using the FIFO or LIFO inventory valuation. You can select 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 items that meet the specified criteria. You can also select to show only the items using the FIFO cost method, only the items using the LIFO cost method or all items using both FIFO and LIFO cost methods. You can further select to generate the report only for items assigned with an active status, only the inactive items, or both. 
Click on the image to enlarge view. Specific ID Inventory Listing
The Specific ID Inventory Listing report provides information on inventory items that are assigned with the Specific ID costing method. This report is useful for reviewing the values of inventory items using specific ID inventory valuation. You can select to generate this report only for active items, only for inactive items, or both. You can also select 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 all items that meet the specified criteria. You can also opt to exclude from the report the inventory items for which serial numbers are not assigned. Options are available to include in the report the inventory items’ serial numbers, lot numbers and kit numbers, if any. 
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 created in AccountMate. 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 can generate this report only for inventory items assigned with the active status, only for inactive items, or all items. The report can be filtered 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. You can also choose to show in the report the inventory item's average and total costs as well as sales price and total sales value. There are available options to display in the report the inventory items’ serial numbers, lot numbers, and kit numbers. You may also opt to exclude from the report the inventory items with zero on-hand quantities and those with zero total cost. 
Click on the image to enlarge view. Bin Quantity Listing
The Bin Quantity Listing provides information on an inventory item's on-hand quantities in the specific bin of each warehouse where the item is physically stored. This report is useful for reviewing the physical location of the inventory item's units within a warehouse. It also serves as a reference for reviewing the quantities available in each bin. You can generate this report for active items only, inactive items only or both. You can include in the report 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 criteria. You can also opt to exclude in the report those inventory items with zero on-hand quantity. You can further select to include in the report the inventory item’s serial numbers, lot numbers and kit numbers, if any. 
Click on the image to enlarge view. Lot Quantity Listing
The Lot Quantity Listing provides information on the lot-controlled inventory items' quantities on hand and pertinent information. The report is useful in reviewing and monitoring lot-controlled items’ on-hand quantities and assigned lot numbers. You can select to include in the report the lot-controlled inventory items’ serial numbers and kit numbers, if applicable. 
Click on the image to enlarge view. Inventory Cost Listing
The Inventory Cost Listing provides the inventory items' cost related information including the 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 opt to generate this report 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 on the image to enlarge view. Inventory Price Listing
The Inventory Price Listing provides the inventory items' price-related information including 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 when creating invoices, analyzing an inventory item's relative prices, and making any price adjustments. You can choose to generate this report only for active items, only for inactive items, or for all items. You can also opt to generate this report for items used in invoice/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 inventory items. You can select to generate this report for active items only, inactive items only or both. You can further select to generate this report only for those items which multi-level pricings 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 useful for reviewing the prices, in specific currencies, used in the last sales order or invoice created for each inventory item. You can choose to generate this report for items whose multi-currency prices are set in Accounts Receivables transactions only, in Sales Order transactions only or in both. 
Click on the image to enlarge view. 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. Options are available for you to mark if you want the report to include the items that are designated for use in invoices/sales orders, in purchase orders or in work orders or to include all items that meet the specified criteria. 
Click on the image to enlarge view. Master Bin Replenishment Report
The Master Bin Replenishment Report provides information on the replenishment levels of inventory items for each bin in a particular warehouse. This report is useful for monitoring which bin has a quantity below its replenishment level; thus, it serves as a reference for prioritizing replenishments for specific bins. You must enter the warehouse where the inventory items you want to include in the report are located. You can opt to show in the report only the items with on-hand quantities that fall below the set replenishment level or to show all the selected items. 
Click on the image to enlarge 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 adjustments recorded using the Inventory Adjustment and Update Physical Count functions. 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 select to include in the report only the inventory adjustments recorded in the Inventory Control module, in the Accounts Receivable/Sales Order module only, in the Purchase Order module only, in the Manufacturing module only, or to include all inventory adjustment transactions. You also have an option to show in the report the inventory items’ serial numbers, lot numbers and kit numbers, if any. 
Click on the image to enlarge view. Inventory Cost Adjustment Requirement Report
The Inventory Cost Adjustment Requirement Report provides information on inventory items whose costs are out of balance due to rounding variances. This report displays the inventory item's total cost, system-calculated cost and a suggested adjustment amount to reconcile the total cost and the system-calculated cost. This report is useful in evaluating any discrepancies in the inventory item costs. You can use this report as a reference when posting inventory adjustments. 
Click on the image to enlarge view. Inventory Lot Expiration Report
The Inventory Lot Expiration Report provides information about the expiration dates of the lot-controlled inventory items. This report guides you in better management of perishable inventory items and in determining which inventory items should be first held for sale. You can configure to include in this report the lot-controlled inventory items with non-zero on-hand quantities. You can opt to show the lot-controlled items’ serial numbers and kit numbers, if any. 
Click on the image to enlarge view. Inventory Lot Recall Report
The Inventory Lot Recall Report provides information about the lot-controlled inventory items that were recalled. This report aids in tracking and monitoring the recalled lot-controlled items. You can generate this report only for lot-controlled items with non-zero on-hand quantities, only for sold items, or for all selected items. 
Click on the image to enlarge view. Inventory Serial Number Report
The Inventory Serial Number Report provides details on transactions involving serialized inventory items. This report is useful for tracking and reviewing each transaction involving serialized inventory items. You can select to include in the report the following transactions involving serialized inventory items: sales invoices, sales order shipment, purchase order receipts, built kit, work order processing, assignment/amendment of serial numbers, warehouse inventory transfers, bin inventory transfers, and inventory adjustments. 
Click on the image to enlarge view. Inventory Transaction Log
The Inventory Transaction Log provides details of transactions involving the inventory items for a specific period. It shows the transaction numbers and the transaction types among other details. This report is useful for reviewing and tracking inventory transactions within a specified period. You can select to include in the report the details of the inventory adjustments comprising the inventory balance as of a certain date. 
Click on the image to enlarge view. |
