Welcome to the group!
I respect that you want this to work right, but do at least understand that
- What you are seeing is very normal
- I get the sense that not a lot of people have ever tried to conquer this
- Most of us (like my company) just do the part selection manually (ish).
This was a good recent thread:
Post 25 is where I explain what we currently do where I work. We count ALL axles one day and all windows the next day, etc. Nothing in the system can do that for us. But it is a really logical way to get a hold of the inventory.
We still use Cycle Count Maintenance and all of the other stuff. We just pick the parts with our own separate logic (using a dashboard to streamline it).
As for getting it all to work by the rules, you will still probably have to massage the part selection for a while. Yes, fine, let it pick the parts if you want, but then delete or move some/many of them to a different cycle if there are too many at once.