7Utilities and Special Edits
Option 5Reset Product/Warehouse Quantities
This function resets any of the following quantities in the Products By Warehouse file:
- Committed quantities, based on open sales orders in the Order Entry application
- On order quantities, based on open purchase orders in the Purchase Order Control application
- Open requisitioned quantities, based on posted material requisitions in the Inventory Control application
If the Update On Hand with Warehouse Transfers? option in the Parameters file is set to ‘N’, do not run this function. If you have any warehouse transfer for which you have not yet posted receipts, the system has no way of knowing that these items are on order at the receiving warehouse. If this function is run, it will reset on order quantities based on open purchase orders, and the reset quantity will be understated by the quantity of the nonreceipted warehouse transfers.
This function also prints a report that shows the entire Products By Warehouse file and the following quantities:
- Old committed and old on order
- New committed and new on order
- Old open requisitions and new open requisitions
Asterisks are printed next to the products that have been changed.
Select “Reset Product/Warehouse Quantities” from the Utilities and Special Edits menu. The entry screen is shown below.
Reset Products By Warehouse Quantities screen
Data items for the preceding screen are described below:
- Reset Committed Quantity?
The system displays ‘N’ for this field. Enter ‘Y’ or ‘N’ to indicate whether or not you wish to recalculate and reset the Products By Warehouse committed quantity according to the current open sales orders in the Order Entry application.
This option can only be selected if the Order Entry application is part of your system.
- Reset On Order Quantity?
The system displays ‘N’ for this field. Enter ‘Y’ or ‘N’ to indicate whether or not you wish to recalculate and reset the Products By Warehouse on order quantity according to the open purchase orders in the Purchase Orders application.
This option can only be selected if the Purchase Orders application is part of your system, and if all receipts in Purchase Orders and warehouse transfers in Inventory Control have been posted.
- Reset Open Requisitions Quantity?
The system displays ‘N’ for this field. Enter ‘Y’ or ‘N’ to indicate whether or not you wish to recalculate and reset the Products By Warehouse Requis’d (requisitioned) field according to the current open material requisitions.
This option can only be selected if all material requisitions in Inventory Control have been posted.
The entered data is validated. Press RETURN to save the information on this screen and update the Products By Warehouse file.
Here is a sample Products By Warehouse Quantities Change Report from this function:
Expert Distributing, Inc.
06/06/91 04:55 pm KAY Page: 1
Reset Product/Warehouse Quantities Report
Old New Old New Old New
Product Wh Committed Committed * On Order On Order * Open Reqs Open Reqs *
==================================================================================================================================
Product 10 #10 3-1/2" White Round
10 0.00 0.00 61.00 0.00 * 251.00 701.00 *
20 0.00 0.00 260.00 6000.00 * 90.00 60.00 *
99 1.00 1.00 500.00 0.00 * 0.00 0.00
Product 20 #4 12" Gold Plated Black Round
00 0.00 0.00 0.00 0.00 0.00 0.00
10 2.00 2.00 75.00 0.00 * 324.00- 1124.00 *
20 2.00 2.00 25.00 6000.00 * 0.00 500.00 *
30 0.00 0.00 135.00 0.00 * 0.00 0.00
Product 30 #56 10" Red Cylinder
20 62.00 2.00 * 30.00 3001.00 * 165.00 120.00 *
30 10.00 10.00 135.00 0.00 * 0.00 0.00
Product 40 #58 10" Yellow Cylinder
20 0.00 0.00 300.00 0.00 * 70.00 40.00 *
30 2.00 2.00 365.00 0.00 * 59.00 0.00 *
Product 50 Special Test Product
40 0.00 0.00 0.00 0.00 0.00 0.00