Item Balancing Register (ICR795)

Using Reports

Use this program to reset quantities for on-hand, on-order, committed, backordered, and LIFO/FIFO cost layers. The register first prints all out-of-balance items, then offers an optional update to reset the quantities to match the printout.

Only run this program only if any quantities in Sales Orders, Purchase Orders, Or Inventory are out of balance.

To access this program, choose Inventory Control-->Reports & Prints -->Item Balancing Register.

Use the following fields balance inventory quantities:

1. Warehouse

Enter the warehouse to balance. The entry must be a valid warehouse code. Press Enter (CR) to default to the warehouse assigned to the terminal.

2. Beginning Item

Enter the beginning item to balance in the warehouse. Press Enter (CR) to default to FIRST. Press F2 or $image\find_shg.gif$ to search.

3. Ending Item

Enter the ending item to balance in the warehouse. Press Enter (CR) to default to LAST. Press F2 or $image\find_shg.gif$ to search.

4. Balance On Hand

Indicate whether to balance the warehouse/item on-hand quantities. Press Enter (CR) to default to N. Balancing sets the on-hand quantities stored in the warehouse/item file equal to the on-hand quantities stored in the serial/lot number file.

5. (Balance) On Order

Indicate whether to balance the warehouse/item on-order quantities. Press Enter (CR) to default to N. Balancing sets all on-order quantities in the warehouse/item file equal to quantities for IC warehouse transfers, manufacturing production, and orders in the purchase order system.

6. (Balance) Committed

Indicate whether to balance the warehouse/item committed quantities. Press Enter (CR) to default to N. Balancing sets all committed quantities in the warehouse/item file equal to what is committed for the sales order system, IC warehouse transfers, and manufacturing production.

7. (Balance) Serial/Lot Committed

If you entered Y in the Committed field, you can also Indicate whether to balance the serial/lot committed quantities; otherwise, this field is skipped. Press Enter (CR) to default to N. Balancing sets the serial/lot committed quantities in the serial/lot file equal to what is in the sales order system, IC warehouse transfers, and manufacturing production.

8. (Balance) Backordered

Indicate whether to balance the backordered quantities. Press Enter (CR) to default to N. Balancing sets all backordered quantities in the warehouse/item file equal to what is on backorder in the sales order system.

9. (Balance) Lifo/Fifo

Indicate whether to balance the quantities for LIFO/FIFO cost layers. Press Enter (CR) to default to N. Balancing sets on-hand quantities for each layer in the LIFO/FIFO cost layers file equal to the quantities for the item in the warehouse/item file, reflecting sales orders, and IC warehouse transfers.

10. Check the register. OK to update?

After the register is printed, verify the printout. If everything is correct, enter YES to continue. The program proceeds with the update. Otherwise, enter N. The update is not performed, and the system returns to the menu.

Item Balancing Register (ICR795)

Using Reports

Use the following fields balance inventory quantities:

See Also

Using Reports