Chapter 2: Initial Setup File Maintenance
Option 18Products By Warehouse List
This option prints a listing of the Products By Warehouse file. A sample output is shown below.
Expert Distributing, Inc.
04/18/91 12:40 pm KAY Page: 1
Products By Warehouse List
Phys
Product Warehouse Loc Alpha Class Type ABC Stk? Tax?
==================================================================================================================================
10 #10 3-1/2" White Round 10 Main Facility A-10 WHITE ROUND 010 010 A Y Y
Reorder Point 150 On Hand 291.00 Cost 34.913 Items/Unit 1
Reorder Quantity 100 On Order 61.00 Last Cost 110.000 Units Per Carton 1.00
Reorder Vendor 00000020 Committed 0.00 Total Cost 13965.00 Post to S/A N
Auto POs Y Requis'd 301.00 Estimated Freight % 0.00 Cycle Count 04
Uncosted 6.00
Quantity Breaks Price Breaks
Last Qty Purch 5.00 MTD Sales 1000.00 YTD Sales 6820.00 1.00 250.000
Last Purchase 05/29/89 MTD Units 4.00 YTD Units 31.00 10.00 245.000
Last Qty Sold 4.00 MTD Margin 440.00 YTD Margin 3400.00 25.00 240.000
Last Sale 08/01/89 50.00 220.000
100.00 200.000
10 #10 3-1/2" White Round 20 South End Facility B-02 WHITE ROUND 020 010 A Y Y
Reorder Point 100 On Hand 722.00 Cost 16.146 Items/Unit 1
Reorder Quantity 0 On Order 260.00 Last Cost 62.500 Units Per Carton 1.00
Reorder Vendor 00000020 Committed 0.00 Total Cost 14402.50 Post to S/A N
Auto POs N Requis'd 90.00 Estimated Freight % 0.00 Cycle Count 04
Uncosted 12.00
Quantity Breaks Price Breaks
Last Qty Purch 6000.00 MTD Sales 0.00 YTD Sales 0.00 1.00 320.000
Last Purchase 05/29/89 MTD Units 0.00 YTD Units 0.00 10.00 315.000
Last Qty Sold 0.00 MTD Margin 0.00 YTD Margin 0.00 25.00 310.000
Last Sale 50.00 305.000
100.00 295.000
10 #10 3-1/2" White Round 99 Drop Ship Warehouse D-09 010 Y Y
Reorder Point 0 On Hand 1.00 Cost 0.000 Items/Unit 1
Reorder Quantity 0 On Order 500.00 Last Cost 0.000 Units Per Carton 0.00
Reorder Vendor Committed 1.00 Total Cost 0.00 Post to S/A N
Auto POs N Requis'd 0.00 Estimated Freight % 0.00 Cycle Count 00
Uncosted 0.00
Quantity Breaks Price Breaks
Last Qty Purch 0.00 MTD Sales 0.00 YTD Sales 0.00 1.00 250.000
Last Purchase MTD Units 0.00 YTD Units 0.00 10.00 245.000
Last Qty Sold 0.00 MTD Margin 0.00 YTD Margin 0.00 25.00 240.000
Last Sale 50.00 220.000
100.00 200.000