Lot Numbers for Regulated Products

This topic has been beaten to death already. If a company requires lot tracking then QB is not the accounting software they should be using.

Allan,

Poor answer.

The question is how to use QB in this scenario !

Allan is correct. The correct answer to "How do you perform brain surgery with a rusty butter knife is the same - "Don't, it is the wrong tool." Any OTHER answer is a poor answer.

requires lot

numbers or

I would think that each of the "lots" are different products. If you have to track them separately, they would seem to be different critters.

I know of a bookstore that has four different books with the same ISBN. They have it as a trade book, a "hurt," a "remainder," and as "used." To them - but not the customer - these are four different books at four different prices from four different sources of supply. And, of course, the four need to be tracked differently.

The answer in this case is like having to choose between jumping out of a burning building and falling to your death, or staying and etc.... Your asking which of these two really bad methods can be used instead of asking what is a good fire extinguisher?

If cost is an issue, then make the mental leap and realize that a method outside of QB, perhaps in Excel or a simple Access database is your best solution.

You never did say how many products are involved and how many lots for each can be received in a year.

Bub,

Thanks for your real life example, unlike most others in this group that reply.

I guess then its a decision between

1) make separate names for each chemical and lot 2) make subitems based on the chemial name to represent each lot

In the sample company they use different brand of hockey sticks as subitems in inventory, however the parent item is named "hockey sticks".

Cheers

Or:

Hocky stick - Mod 12, Black Hocky stick - Mod 12, Blue Hocky stick - Mod 12, Red [...] Hocky stick - Mod 12A, Black Hocky stick - Mod 137, Black [...]

We have customers who so designate things like smocks, T-shirts, Greeting Cards, etc. How you subdivide stuff often depends on the level of specificity you need.