Updating On-Hand Quantities after Inventory Counts

Use the Update Physical On Hand utility to update on-hand quantities in the system for an inventory count. This utility auto-loads the counts for a count control file using the count data entered in Physical Count Load-In utility.

Before using the Update Physical On Hand utility, run your final full Count Variance Report to aid you in resolving any inventory-related problems that might occur at your site following the count

To update your on-hand quantities after an inventory count:

From the Phys menu, select Update Physical On Hand to display the Update Physical On Hand screen.
In the Count ID# field, enter the count control file ID of the inventory count for which to update on-hand quantities.

The system displays the following information:

Field	Description
Title	Title assigned to the count control file.
Branch	Branch in which the count occurred.
Last Control #	Last control number assigned to product in the count control file.

In the Ctrl#/Prc Line field, press F10 and select one of the following options for which to run the program:

Note: This option enables you to update portions of the physical inventory counts, instead of waiting for all counts to be verified.

Option

Description

Ctrl#

Runs the program for a range of control numbers.

In the Start Control # field, enter the first control number in the range for which to run the program.
In the Ending Control # field, enter the last control number in the range for which to run the program.

Note: The Price Line field is not accessible.

Prc Line

Runs the program for an individual price line.

In the Price Line field, enter a price line for which to run the program.

Note: You can only run the program for one price line at a time.

In the Cost Basis field, select the same global cost basis to value your inventory that you used on the full Count Variance Report.
In the Price Date field, enter the date to be used for selecting the correct price sheet for valuing inventory adjustments.

Note: The system enters the count date as the default date in this field. If a count date does not exist, the system uses the lock date as the default date.

In the Nulls = 0 field, enter Y or N to indicate how null entries are being applied to the count.

Note: We recommend entering Y in this field as you did for the full Count Variance Report.

In the G/L Acct field, select the general ledger account to receive inventory adjustments as the result of the updates.
Use the Update hot key to begin the update.
At the prompt asking whether you have picked all post dated orders, enter Y or N to indicate whether post dated orders have been picked.

The system updates your on-hand quantities.