3File 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