To select random products to cycle count:As part of your inventory control practices, you might have your cycle count teams spot check inventory to ensure that actual on-hand quantities match the on-hand quantities in the system. To make such spot-checking easy, use the Generate Random Cycle Counts utility to add a number of random products from the product file to the Cycle Count Queue. By counting random products, you ensure that all the products you carry in inventory are cycle counted at least once.
Using the Generate Random Cycle Counts utility, you can add products to the Cycle Count Queue based on the product's status and activity. Once a randomly-selected item has been added to the queue and counted, the system does not to select that item again until all products with the same product status have been counted, or you reset the random counter. If you count an item and then change its product status, the system does not flag the item to be recounted under its new product status until the rest of the products with the old product status have been counted.
Schedule the random cycle count generation to run after you have run your normal cycle count and have corrected any discrepancies. Otherwise, the system adds the random cycle count to your existing cycle count generation. After generating the random cycle count, select the products from the Cycle Count Queue and print the count sheets or cards to perform the actual cycle count.
To select random products to cycle count:
From the Phys menu, select Random Cycle Count Generation to display the Generate Random Cycle Counts screen.
In the Branch field, enter the branch for which to generate the random cycle count.
In the # of Products field, enter the number of random products to select.
Note: To ensure that you count all products in the Product File at least once a year, divide the number of products in the product file by 365 and schedule the application to run each day.
In the Product Status field, enter the product status of the products to include in the count.
Use the Status hot key to select multiple product statuses.
Note: Products with a product status of MiscChrg, Comment, and LotItem are not included in random cycle count generations.
In the ReInitialize Random Counter field, enter Y to restart the random counter for the current product status combination; otherwise, enter N to leave the random counter where it is for the current product status combination.
Note: We recommend reinitializing the random counter only when you are certain that you have cycled through all products in your inventory, or when there have been significant changes to how you perform cycle counts to warrant resetting the counter.
In the Only Stock Items With Activity in Last ___ Days field, enter the time frame in which to include stock products with transactions and on-hand quantities.
For example:
You want to include all stock products that had transactions or on-hand quantities within the last 30 days only. Enter 30 in this field. The system will include only those stock products with activity over the last 30 days.
In the Only Nonstock Items With Activity in Last ___ Days field, enter the time frame in which to include nonstock products with transactions and on-hand quantities.
For example:
You want to include all nonstock products that had transactions or on-hand quantities within the last 14 days only. Enter 14 in this field. The system will include only those nonstock products with activity over the last 14 days.
Note: The default value is 14, which assumes that you have shipped nonstock items to customers within the last 14 days. Enter a larger value if you hold onto nonstock items for longer periods of time.
In the Zero On-Hand Quantities (Include/Exclude) field, enter one of the following:
Include – Includes products with zero on-hand quantities in the cycle count.
Exclude – Limits the cycle count only to products with on-hand quantities.
You can now do one of the following to select products to count:
Use the Begin hot key to add random products to the Cycle Count Queue.
Use the Schedule hot key to schedule the adding of random products to the Cycle Count Queue on a regular basis.
Press Esc to exit the screen.
See Also: