Cycle count not counting correct number of items

[Former Member]

We have a batch job that runs MICN overnight to create physical inventory count sheets for particular plants/storage locations. In one particular plant/storage location, we typically get around 20 items on our daily count sheets. Today we got almost 300. I tried a few things to see if I could trace the issue:

1. checked the cycle count indicator in the material master. All of them are "B" which is set to count 4 times a year (so approximately once every quarter.)

2. I checked the last count date. All materials were counted in the normal once quarterly interval until now. The latest count was in July for most material, so I wouldn't expect them to come up until October, yet they came up today.

3. I checked for any material master changes and there were none.

4. I checked the last movement of these materials and most haven't moved in over a month.

Does anyone know what else might have caused the? Where else can I look?

Thanks in advance for any help.

[Former Member]

Thanks for the reply. It turned out that someone changed our company calendar making a seven day workweek rather than five. This pushed all of our cycle counts up significantly. This has been changed back so we should be good.

Thanks again for your response.

[JL23]

check the creation date of materails accounting view.

from OSS note 518418:

In principle, the program calculates the planned date of physical inventory according to the following formula:
planned date = base date + Interval (Trans.OMCO/Tab.XT159C-ININV)
Usually, the base date is the 'date of the last physical inventory'. Depending on the type of the stock or the batch management requirement, this date is read from one of the following table fields:
MARD-DLINL (Normal materials)
MCHB-CHDLL (Batch materials, separately valuated materials)
If no physical inventory has been carried out yet and if this date field is therefore empty, the system uses the creation date of the material as basis date. The basis date then comes from one of the following table fields:
MSTA-ERSDA (Normal materials)
MCHB-ERSDA (Batch materials, separately valuated materials)
Since the cycle counting physical inventory always runs for the current fiscal year, the earliest possible physical inventory date is the 01.01. and the latest possible physical inventory date is the 31.12 of the current year.
If the date of the physical inventory is a non-working day, the program automatically proposes the next possible workday.