Cycle Count Parts with Inactive Bins

If I make a bin inactive, is the part # never allowed to be cycle counted again, even if it no longer uses that inactive bin as it’s primary?

I have made some bins inactive and even though it is not the primary bin for my part, it was, once upon a time. Even though I have changed the primary bin for this part, I cannot put this part # into a cycle count batch. I get an error message stating that the part has an inactive bin. I found a connection to the inactive bin in the part maintenance screen → General tab → Sites tab → Warehouses tab → Bin Information tab. I have deleted that as well. Still getting the same error message.

Welcome to the group, Tanya!

Short answer is no, I don’t see how that should matter.

A couple questions.

  1. This will sound stupid, but do you have any quantity in an inactive bin? It’s happened to me before.
  2. Is the part serialized? It is possible that a serial number’s location in inactive. I don’t mean the location in Part Tracker. I mean the location in Serial Number Tracker.

I have seen the message before, but never for creating a count; I’ve only seen it when trying to post a count.

Thank you so much for responding!

No stupid questions, anything asked may trigger another thought!

  1. I have checked the bins and they do not have any quantity.
  2. None of the parts are serialized.

I have this issue with 4 different part numbers now and each one has a different (now inactive) bin somehow still tied to them. I cannot find any way that that are staying connected (other than transactions in history).

Any brain storm is welcome!

That’s really weird to me. We have redone the whole building here, so ALL of the primary bins changed and all the old ones are inactive. No issues. It’s just a field in PlantWhse.

Do you use Kanban? Meaning this part of Part Entry:

image

I gather you are good with BAQs. That is the PartBinInfo table.

Or perhaps here (PartWhse.KBBinNum):

image

Just to recap, the places I know to look for an inactive bin are:

  • PartBin.BinNum
  • PlantWhse.PrimBin
  • SerialNo.BinNum
  • PartBinInfo.BinNum
  • PartWhse.KBBinNum

But I only expect the bold ones to matter for cycle counting.

So you’d do a BAQ on WhseBin, filtering to inactive only, and join to one of these tables at a time.