Road Map: Physical Inventory Update

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 and Overview: Interfacing Inventory to GL for more information.

Before you run this program each time

You should run these programs in this sequence:  

  1. Cycle Count Preparation (HCP) to select items to be counted and print a full inventory book or a set of inventory tags.

  2. Physical Count Entry (HCE) to enter the quantity you counted of each item.

OR

Alternate Physical Count Entry (HAE) to enter counts from pre-printed physical inventory tags.

  1. Inventory Deviation Listing (HDL) to print the quantity on-hand, the quantity counted, the deviation, and cost variance for items with a deviation.

You may also run these programs:

  • Item Insertion (HCI) to add items to an active inventory cycle.

  • Physical Inventory Line / Tag Listing (HIR) to print a range of items by line or tag number so that you can check their counts.

  • Physical Inventory Missing Line / Tag Listing (HMR) to print a listing of missing lines or tags for an inventory cycle.

    OR

  • Missing Tag Report (HTQ) to print a report that shows tag numbers that have been entered in the Alternate Physical Count Entry (HAE) program and those that are missing.

Before you run this program the first time

You should run these programs:

  • System Options Maintenance (XM) (Inventory Control Options) to set the option Inventory interfaced to GL?

  • System Options Maintenance (XM) (GL Journal Options) to set these options for updating the general ledger: Print journal after register?, Print from GJ?, Post in D=Detail or S=Summary, Post from R=Register or J=Journal, and Erase posting files after posting?

  • Output Device Maintenance (XDM) to set up the output devices you plan to use.

  • Date-Output Device Maintenance (ZE) to select your default output device and set whether you can override that device.

  • User Maintenance (UIM) to give each user who will run this program permission to update general ledger; select Allow final reg upd?

  • GL Account Maintenance (GMM) to set up GL organization codes and GL accounts.

  • Posting Criteria Maintenance (XPC) to set default and specific GL organization codes and GL accounts for automatic posting to the general ledger. You set them up for these postings: CURR EXCH, FLOORSTOCK, INVENTORY, and INVTY ADJ.

After you run this program

You will most likely run these programs:

  • Item History Inquiry (IMHQ) to display the last date an item's physical inventory was updated and quantity that was updated.

  • Material Issues and Adjustments (IMI) to adjust inventory for post-count transactions and print the Inventory Adjustments Register and update the general ledger if you have inventory interfaced to the GL.