Automated RF Cycle Count Task Selection

In RF cycle counting, Warehouse Operation Queuing selects items based on phantom scheduling to be counted the following day. Three control maintenance records are involved in setting up Warehouse Operation Queuing to work with RF cycle counting:

Control Maintenance Records	Function
RF Cycle Count Max Entries	Total amount of products/locations to place in the queue daily. Negative quantities and invalid locations are sent to the queue no matter what the maximum entry is, meaning that the queue could hold more entries than the maximum number on a daily basis.
RF Cycle Count Min Cycle Repeat Days	The number of days in between cycle counting for A ranked items. The system uses this base number to calculate number of days for subsequently ranked items. For more information, see below.
RF Cycle Count Use Rank Number	The rank identifier assigned to each branch. Note: Assign ranks to products in Product Rank Maintenance.

The RF system selects items based on the parameters defined by these control maintenance records. Every time Warehouse Operation Queuing runs, the RF system searches the entire product file, regardless of any ranks. It builds a list of all products and locations with a negative on-hand quantity, as well as product with invalid locations.

The queue then loops through the entire product file again to check each product's rank and cycle count repeat days versus last cycle count date. It uses the following equation to run these checks:

If Last Cycle Count Date < (Today's Date - Ranked Item Cycle Count Days), then generate cycle count in-process record. Where Ranked Item Cycle Count Days = value defined in the RF Cycle Count Min Cycle Repeat Days control maintenance record for the branch x the following values:

A ranked items = base number
B ranked items = base number x 1.5
C ranked items = base number x 2

D ranked items = base number x 2.5
E ranked items = base number x 3
F ranked items = base number x 3.5

For example, the system would calculate the Ranked Item Cycle Count Days as follows if the base value defined in the RF Cycle Count Min Cycle Repeat Days control maintenance record is 30 days:

A ranked items = 30
B ranked items = 45
C ranked items = 60

D ranked items = 75
E ranked items = 90
F ranked items = 105

Using the above Ranked Item Cycle Count Days values, the system would add the following items to the queue if the Last Cycle Count Date = 01/05/05, Today's Date = 03/05/05:

If 01/05/05 < 03/05/05 - 30, then add A ranked items with the 01/01/05 last count date to queue:

03/05/05 - 30 days = 02/03/05, and 01/05/05 < 02/03/05; therefore, add A ranked items with the 01/01/05 last count date to queue.

If 01/05/05 < 03/05/05 - 45, then add B ranked items with the 01/01/05 last count date to queue:

03/05/05 - 45 days = 01/19/05, and 01/05/05 < 01/19/05; therefore, add B ranked items with the 01/01/05 last count date to queue.

If 01/05/05 < 03/05/05 - 60, then add C ranked items with the 01/01/05 last count date to queue:

03/05/05 - 60 days = 01/04/05, and 01/05/05 > 01/04/05; therefore, do not add C-F ranked items with the 01/01/05 last count date to queue.

This method of selection allows for a mix of products to be queued for cycle counts. The products to cycle count are listed in sequence with the layout defined in Zone Maintenance. With such a mix, you can cycle through your entire inventory.

Note: Remember that immediate cycle counts are added to the queue on top of these products. You should always count immediate cycle count items first. We recommend that you check for immediate cycle count items on an hourly basis.