See the “Initialize Last Cycle Count Dates” command.
Initialize Last Cycle Count Dates
Use Initialize Last Cycle Count Dates to initialize the Last Cycle Count Date field in part records for selected warehouses, prior to use of the inventory count functions in the Epicor application. This date indicates when individual parts were last cycle counted and appears on cycle count reports.
When running the Perform Part Selection option on the Cycle Count Schedule Maintenance Actions menu, it uses the Last Cycle Count date, in conjunction with the cycle count interval factors defined for specific parts, to calculate the dates on which individual parts should be reselected for cycle counting.
The Initialize Last Cycle Count Dates program assigns (and spreads) the last count dates for the selected ABC items across the last x number of months, where x is the cycle count interval defined for the ABC code category in ABC Code Maintenance. However, it uses as an override any part/warehouse parameters that have been defined for the ABC code category in the Part Maintenance > Part > Sites > Warehouses > Cycle Count\Physical Inv sheet, or part/site parameters that have been defined in the Site Configuration Control > Modules > Inventory > Cycle Count/Physical Inv > ABC Code > Detail sheet.
I looked into that … couldn’t find the Last Date on any of the templates.
Here’s the summary (30 day period starting in February):
Set in System:
The Part Help shows this:
Last Cycle Count
Displays the date on which this part was last cycle counted in this warehouse. If this is a new record, it is automatically set to the current system date when saved. The Epicor application uses this date to determine when the part should be counted again in this warehouse. This field is for display only.
So these dates look like they were set when we uploaded our data.
You would run the Initialize Last Cycle Count Date after you have ABC codes assigned to all parts as it uses the ABC Code assignment to determine the Last Cycle Count Date.
Then run a BAQ to see if the Last Cycle Count Dates are appropriate.
Then on any existing Cycles where you have selected parts, unselect the parts from the Action menu and redo that step, it should update then.
BTW - How long is your Cycle Count Period?
Also you might want to change your Site/Warehouse Cycle Count Method to ‘Random’ instead of ‘Repetitive.’
Since the Select Part calculation compares Last Counted to the ABC Frequency it will sometimes ‘front load’ your cycles to get caught up. One trick is that after Selecting Parts you can remove parts from Cycles and the next Period’s Select Parts will pick them up. I’ve used this trick to even out Cycle Counts across the year. Once it’s even, you can switch the Cycle Count Method back to ‘Repetitive’ and it should keep it even-ish.