Update On-Hand Balances

Use the Physical Inventory Update (HCU) program to update on-hand inventory balances based on deviations recorded in Inventory Deviation Listing (HDL) and update the general ledger if you have inventory interfaced to the GL. See Background, Overview: Interfacing Inventory to GL, and Road Map for more information.    

The program displays the cycles that you have set up with the Cycle Count Preparation (HCP) program. See Cycles for a description of the columns.

  1. Select the cycle that you want to update and click Select.

  2. Set your options:

    1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.

    2. Click the Sort tab to set the sort order.

  3. Choose the appropriate options:

To

Do This

Review the preview update on your screen

Click View. See Background for a list of what displays.

Print the preview update

Click Print. See Background for a list of what prints.

Note
The preview update prints immediately if the option Allow device override? in the Date-Output Device Maintenance (ZE) program is not selected.

If this option is selected, the program prompts Output device. Accept the default device that displays, which is specified in the Date-Output Device Maintenance program, or enter the name of a different device.

Save these options for future use

Click Save.

Exit the program

Click Exit.

If you selected the Print GL jrnl in preview mode? run time option in this program, the preview Interface Journal displays or prints after the preview update.

Note
If the program displays the message Final register/update not allowed, the Allow final reg upd? field is not selected in your record in the User Maintenance (UIM) program. Click Close.

The program prompts Register is complete, proceed with update?

  1. Click OK if the update is correct or click Cancel if it is not.

    If you selected the Inventory interfaced to GL? option in the System Options Maintenance (XM) program (Inventory Control Options), when you enter PROCEED the program updates the general ledger and displays the message GL journal GJH [number] has been created. Click OK to acknowledge the number.

If you selected the Print journal after register? option for this journal in the System Options Maintenance (XM) program (GL Journal Options), the final update prints.

If you selected R for the Post from R=Register or J=Journal option for this journal in the System Options Maintenance (XM) program (GL Journal Options), the program updates the general ledger.

  1. Choose the appropriate options after the final update prints:

To

Do This

Display the selected batch

Click Select.

Display cycles from a specific cycle

Click Restart. The program prompts Branch and Cycle number. Enter the first branch and cycle you want to display or leave blank to begin the display with the first cycle in the file.

Display the previous set of records in the file

Click Page up.

Display the next set of records in the file

Click Page down.

Exit the program

Click Exit.