Using Stock Age in Allocations


Does anyone have any suggestions for how we can take the age of stock into account when allocating orders using Fulfilment Workbench, without fully delving into Lot Tracking?




So first the warning… Epicor uses the Lot Tracking functionality for this, so you’d be mostly re-writing something that already exists, therefore spending more time in the future maintaining something that will someday not work at all anymore (and probably need to be completely rewritten).

Disclaimer done, how are you maintaining the age of your stock currently? How do you know the receipt date of the items currently in your warehouse?

Hi Ernie,

Thanks very much for your reply.

At the moment we’re not maintaining the age of our stock at all, albeit we can obviously get an indication of how old the stock is by looking at when it was transferred into the warehouse bin. This means that there is no stock rotation happening, which was OK when we were a smaller business, but we have grown in recent years and this is starting to present issues with old stock staying in our warehouse.

Lot Tracking seems to be a bit overkill with lots of work needed to maintain it?

Depends on what you mean by “lots of work”. Any kind of stock rotation requires that you segregate your inventory by date (probably in your case date received). Without computer assistance, that means somebody has to write the receipt date on each bag/box/roll/whatever, and your materials crew needs to look at each one when they pull to make sure they’re pulling the right one. WITH computer assistance, when a receipt occurs a lot number gets assigned (by default it’s a manual process, but it can be automated), the date gets stored automatically, tag(s) get printed and attached, and there are fewer steps where errors (or bad handwriting) might occur. And dashboards can be written so that anyone at any time can see the gray-haired length of your inventory.

Yes, there is work involved. But if keeping track of stock rotation is becoming a priority, that might be the price to be paid.