ssolberg
VIP Member
First let me say we have a "simple" inventory and so pretty simple physical cycle counts on the inventory. I was recently asked "how can I find out what I HAVEN'T counted this year". So of course I went hunting for a date of some sort. I know that when cycle counts are done, they write a PI entry in F4111 (even when it is a zero variance) but that isn't much help since I'm looking for things that I DON'T have.
So then I found the Next Cycle Count Date and it got interested in how that was getting filled and it also didn't seem to be consistent. In reading the manual, it does talk about "how" this date is calc'd, just that it can be done via the Proc. Opt. in Cycle Count Update and it is based on the Cycle Count Category Code (we don't use ABC codes). It appears for the most part, they are using a variety of codes but how does it figure out what the next date is to be based on the code? Is it using the numeric value in the second description line to calc a future date? For example, I see a part with A10 on it and the second line says "365". Does that mean it will take the date of the cycle count update (for that part) and calc a date 365 days in the future for the Next Cycle Count Date? That's cool if that's how it works...
In looking at about 2/3 of the parts, that appears to be roughly correct. But... I am finding some parts that have, for example, a Next date of 5/12/06 so I was assuming this part had not been counted "this year" but I look in the Cardex, and sure enough, it was counted on 5/12/06? Any ideas why some of my parts might NOT have a correctly calc'd next date?
Any other ideas on how to find out parts that have NOT been counted?
So then I found the Next Cycle Count Date and it got interested in how that was getting filled and it also didn't seem to be consistent. In reading the manual, it does talk about "how" this date is calc'd, just that it can be done via the Proc. Opt. in Cycle Count Update and it is based on the Cycle Count Category Code (we don't use ABC codes). It appears for the most part, they are using a variety of codes but how does it figure out what the next date is to be based on the code? Is it using the numeric value in the second description line to calc a future date? For example, I see a part with A10 on it and the second line says "365". Does that mean it will take the date of the cycle count update (for that part) and calc a date 365 days in the future for the Next Cycle Count Date? That's cool if that's how it works...
In looking at about 2/3 of the parts, that appears to be roughly correct. But... I am finding some parts that have, for example, a Next date of 5/12/06 so I was assuming this part had not been counted "this year" but I look in the Cardex, and sure enough, it was counted on 5/12/06? Any ideas why some of my parts might NOT have a correctly calc'd next date?
Any other ideas on how to find out parts that have NOT been counted?