Implementing cycle count

[Former Member]

Hi MM Experts,

I have to implement SAP cycle count at material(inventory)level in my organisation.

Each material is to be counted atleast once a year.

To do this I know that I have to set the cycle count indicator in the material master plant data view.

As I have about 10000 materials, I want them to be distributed equally amongst the working days of my organisation.

For example if we have 10000 materials and 250 working days - 10000 / 250 = 40

Which gives 40 materials to be counted each day.

As the base count date is set to the last counted date, is there a way that I can change the last counted manually that I'll be able to distribute the total number of materials equally amongst the total working days.

If there is a method where I can prepare an excel sheet and upload it to the system, can someone please guide me on how to do it.

Thanks in advance.

Regards,

Randi

[Former Member · Accepted solution]

Do you want to upload the documents via Excel? Try doing the ABC segmentation first.

Anyway, if you want to do it via Excel, try looking at BAPI_MATPHYSINV_COUNT.

[Former Member · Accepted solution]

Hi Paulo,

Thanks for the response.

Yes I have already done the ABC segmentation.

What I need to do is to give my own dates as the base count date for each material.

Can u pls let me know where the last counted date is maintained and a way to change it(possibly using excel upload)

Regards,

Randika

[Former Member · Accepted solution]

The system calculates the planned count date for all stock types as folllows: Date of last physical inventory of unrestricted-use stock + predefined interval

If a material needs to be counted, the inventory program will create a batch input session for creating physical inventory documents but it will be based on the last date of physical inventory.

Have you considered using MI31 instead? That will give you full flexibility on what materials you wish to count.

[Former Member · Accepted solution]

Hi Paulo,

Yes I tried this transaction and it generates the inventory document based on the current planned count date for each material.

Is there a way that I can change the default planned count date for each material.

If I can set the count date for each material my problem will be solved to a greater extent.

Regards,

Randi

[Former Member · Accepted solution]

Hi,

Can someone please guide me how to assign different "last counting dates" to a material manually and do a table update.

Regards,

Randi