The Reports and Prints Submenu contains numerous reports with various options and parameters for selecting the report in a format most desired. For example, most reports allow printing an item, alphabetic, vendor or item class order. Additionally, the range of items, etc. maybe specified. The following are the Inventory Control reports:
1. The Stock Status Report provides a listing of 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.
2. The Surplus Stock Report provides a listing of all items that are at or above their maximum stocking levels.
3. The Item Sales Report provides a listing of 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.
4. The Inventory Turns Report provides a listing of the number of inventory turns per item and warehouse totals.
5. The Warehouse/Item Listing provides a listing of 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.
6. The Item Ledgercards Listing prints a listing of the transaction types chosen that have affected the item’s on-hand quantity. Warehouses may be selected.
7. The Item Listing provides a listing of all items in the Inventory Control 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.
8. The Substitute Item Listing provides a listing of 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.
9. Item Interchange Listing prints a listing of all item interchange numbers. The Item Interchange File is a storage place for interchangeable or superseded part numbers listed for one stock item.
10. The Item Catalog Listing prints a listing of catalog items. Catalog items are items that are provided by a vendor but are not stocked.
11. 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.
12. Bar Code Label Print Program prints bar code labels of item numbers.
13. The IC Code List prints a listing of the various IC codes including item classes, general ledger posting tables, adjustment codes, unit of measure codes, and warehouses.
14. The Item Balancing Register resets quantities for on-hand, on-order, committed, back-ordered, 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.