Create a Non-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, a controlled cycle, change a controlled 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.
Click Add if cycles exist.
Enter data in these fields:
Field Name |
Type / Max Length |
Action / Description |
Branch |
Optional |
Select the branch for which you want to select items to count. If you leave blank, the program defaults to your login branch. |
Cycle number |
Required |
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. |
Requested by |
Optional |
Enter the name of the person or department that requested this cycle. |
Cycle date |
Required |
Accept the login date, select a different date, or enter a date shortcut. |
Book or tag format |
Required |
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) |
Create random cycle? |
Optional |
Leave blank if you want to enter non-random selection criteria or select to create a random cycle. If you select, see Create a Random Cycle. |
Annual physical inventory cycle? |
Conditional |
If you did not
select Random?, select
if this is your annual count or leave blank if it is a cycle count. |
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 tool crib
selection option: |
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. |
Set your options:
Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
Click the Selection tab to select specific or a range of warehouses, bin locations, items, or planners. For a complete physical inventory, leave all options blank.
OR
Click List
and then select Item number to
enter a list of items or select Planner
to enter a list of planner codes. See Create
a List of Items or Select Items by Planner
Code.
Note
The program ignores any item that is included on another cycle for this
branch.
Click the Program tab to set these program specific options:
Field Name |
Type / Max Length |
Action / Description |
Select only negative locations? |
Optional |
Select if you want to only select locations with negative inventory balances. |
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 if you want the program to include items that are due to be counted and to skip items that are not. Items are due to be counted when: Cycle date > (Last count date + Count frequency) For example, if the last count was June 15 and the count frequency is 30, then the item is due to be counted on or after July 15. Check the Last count field in the Item History Inquiry (IMHQ) and the Count freq field in the Branch Item Inquiry (IMBQ) program. |
Select date for items not counted since |
Conditional |
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. |
Select month/period of usage history |
Optional |
Enter the number of months or periods to be used in the calculation of the current usage percent. |
Select mfg usage percentage rate |
Conditional |
If you entered a number of months/periods, enter a manufacturing usage percent. The program selects items whose current usage is less than this percent. For example, enter 60.00 to select items with a current usage less than 60%. The program calculates current usage percent: (Qty on hand / Total units used) x 100 |
Include non-controlled items? |
Optional |
Select to include items that do not have lot or serial numbers. |
Include lot-controlled items? |
Optional |
Select to include items that have lot control numbers. |
Include serialized items? |
Optional |
Select to include items that are controlled by serial number. |
Select max no of items to be selected |
Optional |
Enter the maximum number of different items you want to include in this cycle. |
Exclude items with zero qty on hand? |
Optional |
Select if you do not want to include items with an on hand quantity of zero. |
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. |
Choose the appropriate options:
To |
Do This |
||||||||
Create this cycle |
Click Process. |
||||||||
Save these options for future use |
Click Save. |
||||||||
Enter a list of items or planner codes |
Click List and then:
|
||||||||
Exit this cycle |
Click Exit. |
(Optional for a controlled cycle) If you want to assign a range of tag numbers, click Tag assignment. See Assign Tag Numbers.
(Optional) Click Prog opts and set your options:
Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
Click Sort to set sort options.
Click the Selection tab to select tag numbers, location, or status.
Click the Program tab to set this program-specific option:
Field Name |
Type / Max Length |
Action / Description |
Display tag numbers as a range? |
Optional |
Select if you want to list the tag numbers as a range or leave blank if you want to list each tag number. |
Choose the appropriate options:
To |
Do This |
||||||||||
Display the list in reverse order |
Click For/Rev. Click again to display the list in its original order. |
||||||||||
View your options |
Click Prog opts. See Step 9. |
||||||||||
Display tag range detail |
Click Detail. Click Cancel to return to this display. |
||||||||||
Change the selected tag numbers |
Click Tags and then:
|
||||||||||
Print the tag number listing |
Click Print. See Print. |
||||||||||
Exit this tag listing |
Click Exit. |
Select the cycle you created and click Book/Tag. The program directly accesses the options for this program, unless you previously cleared the View this screen each time? Runtime option and clicked Save. If you did so, Click Prog opts to review your options.
Review your options:
Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
Click the Sort tab to set sort order.
Click the Selection tab to select specific records.
(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. |
Choose the appropriate options:
To |
Do This |
Review the inventory book on the screen before printing |
Click View. See Background: Book Printing for a list of what displays. |
Print an inventory book or set of tags |
Click Print.
See Background: Book Printing or
Background: Tag Printing for a list
of what prints. |
Save these options for future use |
Click Save. |
Exit this cycle |
Click Exit. |
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 OK. |
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 for a controlled cycle |
Click Tag assignment. See Assign Tag Numbers. |
Exit the program |
Click Exit. |