Create a Random Cycle

Use the Cycle Count Preparation (HCP) program to select items for a physical inventory count by creating a random cycle, a non-random cycle, delete a cycle, and print an inventory book or set of tags. See Background and Road Map for more information.

The program displays existing cycles. See Cycles for a description of the columns.

  1. Click Add if cycles exist.

  1. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

Branch

Optional
4 alphanumeric

Select the branch for this cycle or leave blank to default to your login branch.

Cycle number

Required
12 alphanumeric

Enter NEW or # if you want the program to assign a cycle number. Use the Batch Number Setup (XBC) program to set up a numbering scheme.

OR

Enter a unique identifier (12 alphanumeric characters maximum) for the cycle number. You can do this only if the Allow manual assignment? option in Batch Number Setup is selected for this program.

Requested by

Optional
15 alphanumeric

Enter the name of the person or department that requested this cycle.

Cycle date

Required
10 date

Accept the login date, select a different date, or enter a date shortcut.

Book or tag format

Required
1 alphanumeric

Select B to print an inventory book or select T to print inventory tags.

Include floor stock items

Required

Y: Include floor stock (items with a floor stock record or a floor stock field value of 1)
N
: Do not include floor stock (default)
O
: Only include floor stock

Create random cycle?

Optional

Select to create a random cycle or leave blank if you want to enter selection criteria. If you leave blank, see Create a Non-Random Cycle.

Annual physical inventory cycle?

Conditional

If you selected Create random cycle?, leave blank.

Upd cycle on hand qty at time of count?

Optional

Select if you want to update the system at the time of the count or leave blank if you want to lock the count at the time of HCP generation.

Use controlled tag assignment?

Optional / Conditional

Select if you want to assign tag numbers to the cycle count batch or leave blank if you do not.

Include tool crib items

Required

Select a tool crib selection option:

Y
: Include tool crib items
N
: Do not include tool crib items (default)
O
: Only include tool crib items

Warehouse

Optional
2 alphanumeric

Select a warehouse to restrict the cycle count to a specific warehouse. Leave blank for all warehouse locations to be considered.

  1. Choose the appropriate options:

To

Do This

Accept the data and continue

Click OK. The program displays the message Cycle no [number] has been created for branch [number]. Click OK to acknowledge.

Exit the record without saving it

Click Cancel.

Update the record

Click Apply.

Delete a saved cycle

Click Delete.

  1. 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 Selection tab to select specific locations or items.

    3. Click the Program tab to set these program-specific options:

Field Name

Type / Max Length

Action / Description

Select items due to be counted?

Optional

Select if you want the program to include items that are due to be counted and to skip items that are not or leave blank to use the Select date for items not counted since option.

Items are due to be counted when:

Cycle date > (Last count date + Count frequency)

For example, if the item's last count was June 15 and the count frequency is 30, the item is due to be counted on or after July 15. If the item has never been counted, it will be included in the cycle unless excluded by another option.

Check the Last count field in the Item History Inquiry (IMHQ) program and the Count freq field in the Branch Item Inquiry (IMBQ) program.

Select date for items not counted since

Conditional
10 date

If you left Select items due to be counted? blank, select a cutoff date, enter a date shortcut, or leave blank to use your login date.

The program includes items that were last counted since the cutoff date:

Cutoff date > Last count date


For example, if the cutoff date is July 1 and the item's last count was June 15, the item will be included in the cycle. If the item has never been counted, it will be included in the cycle unless excluded by another option.

Check the Last count field in the Item History Inquiry (IMHQ) program.

Sample size for ABC class A through J

Optional
9 numeric

Enter the number of items in each class that you want to be selected.

Do not make an entry if you opt to select a maximum number of items.

Select max no of items

Optional

Select if you do not want to set the sample size by ABC class.

Exclude items with zero qty on hand?

Optional

Select if you do not want to include items with an on hand quantity of zero.

  1. Click the Program2 tab to exclude item statuses:

Field Name

Type / Max Length

Action / Description

Exclude item status

Optional

Select any of ten possible status codes to exclude items with those statuses.

Item statuses are defined in the Item Status Codes (TISM) program and assigned to items in Enterprise Item Maintenance (IM) and Branch Item Maintenance (IMB).

  1. Choose the appropriate options:

To

Do This

Create this cycle

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

Save these options for future use

Click Save.

Exit this cycle

Click Exit.

  1. Select the cycle you created, if necessary, and click Book/Tag.

  1. 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. Click the Selection tab to select specific records.

    4. (Conditional) Click the Program tab to set this option if you are printing tags:

Field Name

Type / Max Length

Action / Description

Continuous form?

Optional

Select to print tags on continuous-form paper or leave blank to print them on cut sheet paper.

Continuous-form paper feeds continuously through a dot-matrix printer. The paper is perforated to enable you to tear tags apart.

Cut-sheet paper feeds into a laser printer one sheet at a time. Three tags print per 8.5 x 11" sheet. Horizontal perforations every 3-2/3" enable you to tear tags apart.

  1. Choose the appropriate options:

To

Do This

Print an inventory book or set of tags

Click Print.  See Background: Book Printing or Background: Tag Printing for a list of what prints.

Note
The book or tags print 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 this cycle

Click Exit.

  1. Choose the appropriate options when you click Exit:

To

Do This

Add another cycle

Click Add.

Delete the selected cycle

Click Delete. See Delete.

Display the selected cycle

Click Select.

Print the cycle listing

Click Print. See Print.

Print a full inventory book or full set of tags for this cycle

Click Book/Tag. See step 7.

Enter beginning and ending tag numbers and general location

Click Tag assignment. See Assign Tag Numbers.

Exit the program

Click Exit.