Inventory Control Reports & Prints Overview
Most inventory reports have the option of printing in item, alpha, item class or vendor order. In addition to the order, the user may choose the range to be printed. For example, if the order selected is item number, field of the beginning and ending item number is required.
- The Stock Status Report provides a report listing the on hand quantity of each item, the value (cost) of the item and extension giving the total valuation of each item. The report may be printed by warehouse giving the value of each warehouse. The value (cost) may be selected when printing the report. Therefore, the user may see the value of a warehouse based on the standard, average, last or manual cost.
- The Surplus Stock Report provides a report listing all items at or above their maximum stocking levels.
- The Item Sales Report provides a report listing sales based on the accumulated sales history stored for each item or item by warehouse. The report includes month-to-date, year-to-date, and prior year figures in unit or dollar amounts.
- The Inventory Turns Report provides a report listing the number of inventory turns per item and provides warehouse totals. Inventory turns are calculated as the unit sales divided by the average on hand.
- The Movement Class Report provides a report listing item by warehouse code in movement class order. The movement class is determined by the percentage of sales of the item in the last year.
- The Seasonal Item Report provides a report listing seasonal items along with usage information. The report may also recalculate seasonality of items and optionally reset the seasonality flag in the warehouse/item file.
- The Warehouse/Item Listing provides a report listing all items assigned to each warehouse. On hand, on order and committed quantities may be included. This listing is especially useful for verifying stocking information after the initial warehouse setup.
- The Item Ledgercards Listing prints a list of the transaction types chosen that have affected the item’s on hand quantity. Warehouses may be selected.
- The Item Listing provides a report listing all items in the inventory file, along with specific information regarding each item. The user may print either package (units of measure, conversion factors, etc.) or general (item class, alpha sort, etc.) information.
- The Substitute Item Listing provides a report listing each item and its substitute items. Substitute items are maintained through the Item F/M program and may be used in sales orders as a substitute (replacement) when the item ordered is not available.
- Item Interchange Listing prints a list of all item interchange numbers. The item interchange file is a storage place for interchangeable or superseded part numbers listed for one stock item.
- The Catalog Item Listing allows listing of catalog items to be printed. Catalog items are items that are provided by a vendor but are not stocked.
- The Safety Allowance Reset may be used to recalculate and update the safety allowance. Initially, all items are assigned the standard safety allowance percent. However, after 12 periods of usage has been maintained the standard percent may be too high or too low depending on individual item usage and the amount of safety stock used.
- The Vendor Review Cycle Reset may be used to recalculate and update the vendor’s review cycles. Initially, you establish the vendor review cycle. However, after the system maintains 12 periods of purchasing, the review cycles may be too high or too low depending on the total purchases and buying target ($) you set for each vendor.
- The Item Label Print program allows labels to be printed from the information stored in the item file. Each label includes the item number and description. Optional information includes the unit of measure, standard pack, item class and location.
- The Bar Code Label Print program prints bar code labels of item numbers.
- The Item Notes Print program prints the notes for any items in the item file.
- The Item Balancing Register resets quantities for on-hand, on-order, committed, backordered, and LIFO/FIFO cost layers. It needs to be run only if quantities become out of balance due to a system malfunction or user error.
- The IC Code List prints a listing of the various IC codes including item classes, item price classes, general ledger posting tables, adjustment codes, unit of measure codes, and warehouses.