IC145 - Stock Status Report Run this program to print the Stock Status Report. Run this report to determine item availability based on the actual supply and demand. This report prints the following quantity totals. These totals are derived from open customer orders created in the Order Entry and Requisitions systems, purchase orders created in the Purchase Order system, work orders in the Work Order system, case carts in the Case Carts system, and open intransit transfers created in the Inventory Control system. Unallocated Allocated Backordered Stock-On-Hand Picked On-Order Intransit Available Item records print in item number sequence and includes the buyer code, inventory major and minor classes, movement class, auto PO flag, leadtime, and stock unit of measure. This information is derived from the Item Master and Item Location file(s) (IC11, IC12 or IC10). Updated Files CKPOINT - Used in backout or restart information. ICCOMPANY - Used to validate the existence of the company. ITEMLOC - Used to update the activity flag if the update option is selected. Referenced Files APCOMPANY - Used to validate the Accounts Payable company and obtain the vendor group. APCPYVND - The Vendor Company Codes file contains default codes assigned a vendor or alternate vendor location at the company level. APHLDINV - The Hold file contains records of vendors, invoices, and payments that are on hold. APVENCLASS - Used in an Accounts Payable common routine. APVENGROUP - Used to validate the vendor group. APVENMAST - Used to validate the vendors. GLCODES - Used in a General Ledger common routine. ICBIN - Used to validate and extract bin number information. ICCATEGORY - The GL Account Category file is a master file that defines the inventory and offset general ledger accounts used to post inventory transactions. ICLOCATION - Used to validate the existence of the location. ICRPTGRP - Used to validate the report group. ITEMMAST - Used to print the item number description and unit of measure. MAJORCL - Used to validate the major class. MINORCL - Used to validate the major-minor class. RQLOC - Used to retrieve Requisition location names. WHDEMAND - The Demand file contains all the records that the Warehouse system needs for processing demands. WHDEMNDHDR - The Demand Header file contains document header records. |