Skip to Content
author's profile photo Former Member
Former Member

Cycle count not counting correct number of items

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 08, 2009 at 08:21 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 08:39 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.