Running the Select Items for Count Program

Select Inventory Count Alternatives (G4121), Select Items for Cycle Count.

Before you start the cycle count process, you must run the Select Items for Count program (R41411). The R41411 program creates a record for each inventory item to be counted and records the current on-hand quantity and cost for each item. The system then generates the Select Items for Count report, which lets you compare the actual on-hand quantity with the online records.

The system processes the information in this way:

• Selects items to be counted based on the data selection.

• Copies the current on-hand balance to the Quantity On-hand at Count field in the F4141 table.

• Creates a cycle count header in the F4140 table that contains the status codes for the processes that have been completed for Cycle Count items.

• Updates this data in the F4141 table for each item in the selected locations:

  • Item information.

  • Quantity on hand.

  • Amount on hand.

• Produces the Select Items for Count report, which lists the selected items for each location and the quantity on hand at the time of the count.

You can use data selection to group items by:

• Cycle count categories (for example, monthly and semiannually).

• ABC codes (for example, count A items monthly).

You cannot change this sequence for the Select Items for Count report:

1. Item number (short)

2. Lot

3. Location

See also:

• Running the Cycle Count Update Program.