In case you would want to use a fixed date it would be better to use other inventory counting methods, if you don't want to manipulate standard tables with ABAP methods.
You would have to manipulate the last counting date in MARD table. And you would have to do this regularly since your new materials that are created within a year do not have this date, but you also would need to avoid to reset the last counting date for materials that have already been counted in this fiscal year.
The basic meaning of cycle count is to count every day or week or month a portion of your stock. And the most common problem which people have is the start with CC in a new SAP system, since all materials share the same creation date (migration date) and no old inventory documents exist.
Thus, assuming you count A items monthly, B items quarterly, C items 2 times a year and D items only once a year, you would get only A items to count in your January and February counts. A and B items in your March count, then again only A items in April and May, in June you would need to count A, B and C items on one day, then again only A items in July and August, while September will ask for A and B items. In December you have to count all material at once.
Exact such a scenario is usually not wanted. instead the count should be spread more equally for all materials over the year, so that you have almost the same number of items to count in each of your counts.
Hello Juergen,
What you are describing in your response is the exact precise issue we are facing right now. We look for an equal spread of counts over each day of the year to have the Cycle Counting propose us A items 4xYear, B items 2xYear, C items 1xYear. All the settings are in place, but we have no initial count date in the MARD records (no inventory was every executed for these items) and the materials are all older or have been loaded many years ago. So SAP MICN proposes to count everything now (20,000 mat/locs). With 240 work days, we would like to get 84 counts/day. What is the common / best practice solution to this issue? Do we need to run the list every day and just copy the first 90 items and create the counts for the first 90 items proposed on the list until we have done this for the entire year and then we can rely on SAP to make proper proposals next year? Our hope was that a more efficient solution is available. We would love to hear your thoughts!
Thank you!
Add comment