1. Using Inventory Management
  2. How Cycle Count Sequences Are Generated

How Cycle Count Sequences Are Generated

This topic discusses how cycle count sequences are generated.

Settings That Affect Count Sequences

Count sequences are generated using the automatic schedule parameters that you define on the Define Schedules and Approvals page, and the manual schedule parameters that you define on the Manage Manual Count Schedules page.

How Count Sequences Are Generated

Count sequences are generated for each item number, revision, lot number, subinventory, and locator combination for which on-hand quantities exist. Count sequences are ordered first by subinventory and locator, then by item, revision, and lot. A unique sequence number is assigned to each count sequence. You can use this sequence number for reporting, querying, and rapid count entry.

Example 1: Count Sequence Generation

Assume that an inventory organization has the following on-hand quantities:

  • Locator B1.1.1: 100 EA

  • Locator: B1.1.2: 10 EA

  • Locator: B1.1.3: Does not include any on-hand quantities

Assume that the cycle count schedule has this information:

  • Item: PLT100

  • Subinventory: BULK

  • Count Zero Quantity: No

  • No locator is specified at the schedule level

Using the on-hand quantities and cycle count scheduling information described, the count sequences generated are:

  • Item: PLT100; Subinventory: BULK; Locator: B1.1.1; Suggested Quantity: 100 EA

  • Item: PLT100; Subinventory: BULK; Locator: B1.1.2; Suggested Quantity: 10 EA

Note that cycle count sequence generation would differ if these changes existed:

  • For a lot- or revision-controlled item, generation of cycle count schedules would result in different count sequences for different revisions and lots, depending on whether the item is lot-, revision-, or lot/revision-controlled).

  • If the item is serial number-controlled, the serial number options that are defined in the cycle count properties determine that either different cycle count sequences are generated for each serial number, or one cycle count sequence is generated for multiple serial numbers.

Example 2: Count Sequence Generation

Assume that an inventory organization has these on-hand quantities:

  • Locator B1.1.1: 100 EA

  • Locator: B1.1.2: 10 EA

  • Locator: B1.1.3: Does not include any on-hand quantities

Assume that the cycle count schedule has this information:

  • Item PLT100

  • Subinventory: BULK

  • Count Zero Quantity: Yes

  • No locator is specified at the schedule level

  • The Item/locator combination exists between Item PLT100 and all of the locators in the BULK subinventory

The count sequences generated would be the following:

  • Item: PLT100; Subinventory: BULK; Locator: B1.1.1; Suggested Quantity: 100 EA

  • Item: PLT100; Subinventory: BULK; Locator: B1.1.2; Suggested Quantity: 10 EA

  • Item: PLT100; Subinventory: BULK; Locator: B1.1.3; Suggested Quantity: 0 EA