Hello,
Could anyone recommend a system how to effectively and efficiently rack lot numbers of finished goods? Basically, a way to track where lot numbers of a finished good were sold to.
Thanks a lot!
Elaine
Posted 06 April 2015 - 03:26 PM
Hello,
Could anyone recommend a system how to effectively and efficiently rack lot numbers of finished goods? Basically, a way to track where lot numbers of a finished good were sold to.
Thanks a lot!
Elaine
Posted 06 April 2015 - 05:27 PM
Elaine,
Lot number tracking "systems" as you have put it are very often just a subset functionality of whole business software solutions run onsite on your company computer systems or via the internet in the cloud. They are called ERP's (Enterprise Resource Planning) systems. In your question you reference "finished goods", but I would point out that tracking lots of finished goods is of little meaning unless they are linked to lots of the ingredients that went into the finished goods. To be of practical use for traceability, recall and market withdrawal, tracking is far more sophisticated that just finished goods. ERP systems allow a business to track lot numbers of incoming ingredients through storage and use in your facility, to outgoing finished goods.
ERP's are generally very expensive. even those marketed to small and medium size businesses approach and exceed $100,000. Besides the initial cost, the cost of training and system maintenance can add up quickly depending on your company circumstances.
You may have heard ERP names like Oracle, Sage, Exact, Aspen, Just Food
I have worked with two ERP solutions and would not recommend either one of them for a food business! Besides not being specifically for food and beverage, their service and problem resolution was an untimely, nightmare like travesty.
Any given ERP may have been initially designed e.g., for a nuts and bolts manufacturer and later as an after-thought applied to a food manufacture. If you bought such a solution, it would in fact work for food, but for the life of the system you would have to adjust to your food production room being called the "shop floor". In other words in would continually be in your face that your expensive ERP is not the best suited to a food operation.
I have never heard of an intermediate technology for tracking lots except the old manual data input into excel, but you did say "effectively and efficiently". Maybe other members have ideas for tracking that are unknown to me.
Thanked by 1 Member:
|
|
Posted 06 April 2015 - 06:11 PM
I agree with much of what xylough says.
If you have some type of ordering system (so you can see history of which customers order which products), but are not at a full-scale ERP solution, you can have your shipping department write the lot numbers on the pick tickets.
It doesn't sound very efficient - and may not be, given your business - but take a look at various factors:
- do you have many, many skus?
- what's the shelf life of your product?
- do you have many, many customers?
- have you had a recall before?
- what is the likelihood of a recall?
- is shipping documentation readily accessible?
- do you have a good customer service team who can help identify customers by the types of products they buy?
If you are selling just a couple of items to lots of customers, this is probably not a good solution. But if you know that certain customers take only selected items, this may be a possible way to go.
Posted 06 April 2015 - 07:29 PM
You can use a quality management software. Our clients manage this data using our system. Of course, it is not as wide-range as ERP, but it definitely does the job effectively AND only costs a fraction of an ERP system.
In detail, what they do is scan in the UPC code to the system using handheld devices and record (from a drop-down box, for example) where it was shipped to. You can also configure other types of information in the same template, for example, the COA, shipment checks, time and dates, usernames, etc.
Posted 09 April 2015 - 02:29 PM
It may be useful to know (at the very least) what your product is as some products are more easy to trace than others.
Get FREE bitesize education with IFSQN webinar recordings.
Download this handy excel for desktop access to over 180 Food Safety Friday's webinar recordings.
https://www.ifsqn.com/fsf/Free%20Food%20Safety%20Videos.xlsx
Check out IFSQN’s extensive library of FREE food safety videos
https://www.ifsqn.com/food_safety_videos.html
0 members, 0 guests, 0 anonymous users