Defining and Maintaining a Cycle Count
A combination of parameters constitutes a cycle count header, identified by the cycle count name. You use this name to identify any activity pertaining to this cycle count.
You can define and maintain an unlimited number of cycle counts in Oracle Inventory. For example, you can define separate cycle counts representing different sets of subinventories in your warehouse.
Prerequisites
When determining cycle count classes based on ABC analysis, you must compile an ABC analysis and assign your compiled items' ABC classes. See: Overview of ABC Analysis.
To define a new cycle count:
2. Enter a unique name for the cycle count.
3. Enter the workday calendar to use for this cycle count.
Inventory uses this calendar to determine the days on which to automatically schedule cycle counts.
To enter control and scope information for your cycle count:
1. Select the Control, Scope alternative region.
- Optionally, enter the date on which the cycle count becomes inactive. As of this date, you cannot generate schedules or perform any counting activities for this cycle count.
- Enter the number of workdays that can pass after the date the count request was generated, before a scheduled count becomes a late count.
- Enter the sequence number to use as the starting number in the next count request generator. The count sequence number uniquely identifies a particular count and is used in ordering the cycle count listing.
- Determine whether you can enter counts for items not scheduled to be counted (Unscheduled Entries).
- Determine whether to display system on-hand quantities during count entry.
3. Determine whether Inventory automatically assigns a status of Recount to out-of-tolerance counts and includes them in the next cycle count listing.
If you turn this option on, navigate to the Maximum field and enter the maximum number of times Inventory can generate an automatic recount request. Once this number is reached the adjustment must be approved or rejected.
4. Determine the subinventories to include in the cycle count.
If you choose Specific subinventories, you can navigate to the Subinventory region and select the subinventories to include in the cycle count.
To enter serial number control and autoschedule information:
2. Select the count option to determine whether to exclude serialized items from the cycle count (Not Allowed), create one count request for each serial number (One Per Request), or create multiple serial details in a count request (Multiple Per Request).
3. Select the detail option:
Quantity and Serial Numbers: Serial number and quantity are required and are validated when entering adjustments.
Quantity Only: Serial number entry is optional if the count quantity matches the system quantity, regardless of whether the serial numbers match. If you do not enter serial numbers, the count is marked as completed, and no adjustments are performed. If you do enter serial numbers, both quantity and serial numbers are validated when determining whether adjustments are required.
4. Select the adjustment option:
Adjust if Possible: If a discrepancy exists between the count quantity and system quantity or if the entered serial numbers do not correspond to the serial numbers already in the specified location, then the system will attempt to make adjustments if the adjustment variance and value are within tolerances. These adjustments consist of receipts and issues of the appropriate serial numbers to and from the specified location and are applicable only to instances in which new serial numbers or shipped serial numbers are counted.
Review All Adjustments: No automatic adjustments are attempted.
5. Select the discrepancy option to indicate whether an adjustment is attempted when a count includes a serial number already assigned to the same item elsewhere in the system.
If you turn automatic scheduling on, enter the following information:
Frequency: Indicate whether to schedule cycle counts Daily, Weekly, or By period. Inventory uses this information, along with the count frequency of each cycle count class, when performing automatic cycle count scheduling. The value you enter here dictates the window of time within which you can enter counts against a schedule bucket.
Schedule Interval Example
If you choose weeks as your schedule interval, Inventory schedules a week's worth of counts each time the automatic scheduler executes. You then have that week to complete all these counts. On the other hand, if you choose days, Inventory schedules only that one day's counts, and you need to complete those counts on that given day.
Last Date: Inventory displays the last date this cycle count was automatically scheduled.
Next Date: Inventory displays the first workday for the next schedule interval when this cycle count is scheduled. You can enter a later date in this field if you want to override the automatic schedule and skip one or more intervals. If your schedule interval is Weekly or By period, the date you enter must be the first workday of the period for which you want to generate schedule requests.
Next Schedule Date Example
Assume your schedule interval is Weekly and you last ran your schedule on Monday, March 20. Your calendar workdays were specified as Monday through Friday. When you ran your schedule on March 20 the Next Scheduled Date was set to March 27. You know that during the week of March 27 you are doing a physical inventory so you do not wish to do cycle counting. You can set Next Scheduled Date to April 3, the first weekday of the following next week. Inventory does not generate any cycle count requests for the week of March 27-31, and when you schedule counts on April 3, Inventory generates requests only for the week of April 3-7.
7. Optionally, determine whether to automatically generate requests to count items with an on-hand quantity of zero.
To define adjustments and ABC information:
1. Navigate to the Adjustments, ABC alternative region.
Never: Inventory automatically posts adjustment transactions where entered counts differ from system balances.
If out of tolerance: Inventory does not automatically post adjustment transactions for counts outside a specified approval tolerance. You must approve such adjustments before posting.
Always: You must approve all cycle count adjustments, regardless of tolerance levels, before Inventory can post any of them.
3. If you choose to require approval for adjustments If out of tolerance, enter positive and negative tolerances.
Qty Variance: Enter the percentage variances of count quantity to on-hand quantity beyond which adjustments are held for approval.
Adjustment Value: Enter the adjustment values beyond which adjustments are held for approval.
Hit/Miss Analysis: Enter the percentage variances of count quantity to on-hand quantity beyond which Inventory considers a count entry a miss for hit/miss reporting.
- Group: Enter the ABC group name on which to base the cycle count item initialization or update.
- Option: Choose one of the following options:
- None: Do not change to the list of cycle count items.
- (Re)initialize: Use the ABC group you specified to load all items and their ABC assignments into the list of items to include in your cycle count. If you already had items defined for your cycle count, this action deletes existing information and reloads the items from the ABC group.
- Update: Use the ABC group you specified to insert new cycle count items.
- If you chose the update option:
- Indicate whether to update classes. If an item's ABC class assignment in the ABC group you specified is different from the cycle count class this item is assigned, Inventory updates the cycle count class for the item with the ABC assignment in the specified ABC group.
- Indicate whether to delete unused item assignments that are no longer referenced in the specified ABC group.
To enter ABC classes to include in your cycle count:
To define cycle count items:
See Also
Customizing the Presentation of Data in a Folder
Generating Automatic Schedules
Purging Cycle Count Information.
Approval Options and Tolerances