2Initial Setup Opening Entries
Option 8Reset 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 Orders application
- Open requisitions quantities, based on posted material requisitions in the Inventory Control application
This function also prints a report that shows the entire Products By Warehouse file and the following quantities:
- Old and new on order
- Old and new committed
- Old and new open requisitions
Select “Reset Products By Warehouse Quantities” from the Utilities option on the Opening Entries menu. The Reset Products By Warehouse Quantities entry screen is shown below.
Reset Products By Warehouse Quantities screen
Data items for the preceding screen are described below:
- Reset Committed Quantity?
This field specifies whether or not to reset the Committed field on Products By Warehouse records based on open sales orders. By default, the system displays ‘N’ in this field. You can enter ‘Y’ to override the display.
This option can only be selected if the Order Entry application is part of your system.
- Reset On Order Quantity?
This field specifies whether or not to reset the On Order field on Products By Warehouse records based on open purchase orders. By default, the system displays ‘N’ in this field. You can enter ‘Y’ to override the display.
This option can only be selected if the Purchase Orders application is part of your system, and if all receipts in Purchase Orders and all warehouse transfers in Inventory Control have been posted.
- Reset Open Requisitions Quantity?
This field specifies whether or not to reset the Requis’d field on Products By Warehouse records based on open material requisitions. By default, the system displays ‘N’ in this field. You can enter ‘Y’ to override the display.
This option can only be selected if all material requisitions have been posted.
Below is a sample 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