4Reports and Inquiry
Option 1Stock Status Report
The Stock Status Report lists products by warehouse and product class and identifies the number of stockkeeping units on hand, committed, requisitioned, on order, and available.
Here is a sample Stock Status Report:
Expert Distributing, Inc.
05/23/91 04:17 pm KAY Page: 1
Stock Status Report
On Open Net On Available
Product Description Unit Hand Committed Reqs Available Order + On Order
================================================================================================================================
Warehouse
Product Class
20 #4 12" Gold Plated Black Round Each 0.00 0.00 0.00 0.00 0.00 0.00
Warehouse 10 Main Facility
Product Class 10 Standard
10 #10 3-1/2" White Round Each 291.00 0.00 301.00 10.00- 61.00 51.00
Product Class 30 Custom
20 #4 12" Gold Plated Black Round Each 325.00 2.00 186.00 137.00 75.00 212.00
Warehouse 20 South End Facility
Product Class 10 Standard
40 #58 10" Yellow Cylinder Each 182.00 0.00 85.00 97.00 300.00 397.00
Product Class 20 Special Order
10 #10 3-1/2" White Round Each 722.00 0.00 90.00 632.00 260.00 892.00
30 #56 10" Red Cylinder Each 592.00 62.00 165.00 365.00 30.00 395.00
Product Class 30 Custom
20 #4 12" Gold Plated Black Round Each 575.00 2.00 0.00 573.00 25.00 598.00
Warehouse 30 North End Facility
Product Class 20 Special Order
40 #58 10" Yellow Cylinder Each 265.00 2.00 59.00 204.00 365.00 569.00
Product Class 30 Custom
20 #4 12" Gold Plated Black Round Each 730.00 0.00 0.00 730.00 135.00 865.00
30 #56 10" Red Cylinder Each 1030.00 10.00 0.00 1020.00 135.00 1155.00
Warehouse 99 Drop Ship Warehouse
Product Class 10 Standard
10 #10 3-1/2" White Round Each 1.00 1.00 0.00 0.00 500.00 500.00