Use this report to provide a listing of inventory sorted by warehouse/ location, project, or inventory abbreviation. The report prints two separate totals for each sort criterion. The first total is the total amount for the specified sort criterion and the second total is the recognized inventory total.
The recognized inventory amount is based upon your selection in the Inventory Recognition Point drop-down box in the Inventory Settings screen. If you selected "Acceptance" in the Inventory Recognition Point field, only quantities in location types On-Hand and In-Shipping will be recognized. If you selected "Receipt" in the Inventory Recognition Point field, the recognized inventory amount is the sum of the quantities in the On-Hand, Incoming-Inspection, Reinspection, In-MRB, and In-Shipping location types.
Print this report whenever current inventory quantities and amounts are needed.
You can print this report for warehouse/location, by project ID, or by inventory abbreviation.
The Stock Status Report provides current inventory information that is continuously updated and therefore may need to be retained.
Select the appropriate radio button.
Select this radio button to print the report by warehouse/location.
Select this radio button to print the report by project.
Select this radio button to print the report by inventory abbreviation.
Use this group box to select a specific range of warehouse information that will appear on the report.
Select the range of warehouses to be printed. The system-defined selections are "All," "One," "Range," "From Beginning," and "To End."
Enter, or use Lookup to select, the warehouses that are the starting and/or ending points to be printed on this report.
Use this group box to select a specific range of location information that will appear on the report.
Select the range of locations to be printed. The system-defined selections are "All," "One," "Range," "From Beginning," and "To End."
Enter, or use Lookup to select, the locations that are the starting and/or ending points to be printed on this report.
Use this group box to select a specific range of project information that will appear on the report.
Select the range of project IDs to be printed. The system-defined selections are "All," "One," "Range," "From Beginning," and "To End."
Enter, or use Lookup to select, the project IDs that are the starting and/or ending points to be printed on this report.
Use this group box to select a specific range of inventory abbreviations that will appear on the report.
Select the range of inventory abbreviations to be printed. The system-defined selections are "All," "One," "Range," "From Beginning," and "To End."
Enter, or use Lookup to select, the inventory abbreviations that are the starting and/or ending points to be printed on this report.
Select this checkbox to print all inventory locations with the exception of On-Hold locations. This will disable the Select Inventory Types group box. If you do not select this checkbox, only those locations that are selected in the Select Inventory Types group box will be printed.
This group box contains the various inventory types in the system. Select the appropriate checkbox to print that type of location point. Location types that are left blank will not print. Location type is a system-defined code used to classify inventory records by locations. The system-defined types are listed below.
Select this type to indicate that this location contains parts that should not be counted as available.
Select this type to indicate that this location contains parts that have been received but have not been accepted or rejected.
Select this type to indicate that this location contains parts that have been through the MRB process.
Select this type to indicate that this location contains parts that are available for use.
Select this type to indicate that this location contains parts that have already been accepted or rejected but need to go back through that process.
Select this checkbox to include in-shipping type inventory on the report.
The information that is entered in this screen and saved as a parameter is stored in the FUNC_PARM_CATLG table. This screen also relies on the settings in the ITEM_SETTINGS_CORP table. Information is also stored in and/or pulled from the following tables: INVT, INVT_ABBRV_CD, INVT_PROJ, INVT_WHSE_LOC, ITEM, ITEM_PROJ_CST, PROJ, VIN_STK_STS, WHSE, WHSE_LOC.