Jump to content

  • Quick Navigation
Photo
- - - - -

Does anyone know of a simple traceability software?


  • You cannot start a new topic
  • Please log in to reply
7 replies to this topic

792404

    Grade - Active

  • IFSQN Active
  • 22 posts
  • 0 thanks
0
Neutral

  • United States
    United States

Posted 26 December 2021 - 12:22 AM

Does anyone know of a simple traceability software where we can keep track of lot codes and where they ship to? Thanks, Mike



mgourley

    Grade - FIFSQN

  • IFSQN Fellow
  • 1,323 posts
  • 958 thanks
233
Excellent

  • United States
    United States
  • Gender:Male
  • Location:Plant City, FL
  • Interests:Cooking, golf, firearms, food safety and sanitation.

Posted 27 December 2021 - 08:20 PM

Pretty simple to just do that in Excel or Access.

 

Marshall



792404

    Grade - Active

  • IFSQN Active
  • 22 posts
  • 0 thanks
0
Neutral

  • United States
    United States

Posted 27 December 2021 - 11:14 PM

Thanks, I will look into how to set that up. How do most companies deal with traceability?

Mike



mgourley

    Grade - FIFSQN

  • IFSQN Fellow
  • 1,323 posts
  • 958 thanks
233
Excellent

  • United States
    United States
  • Gender:Male
  • Location:Plant City, FL
  • Interests:Cooking, golf, firearms, food safety and sanitation.

Posted 27 December 2021 - 11:30 PM

Mike,

 

Traceability, at it's most basic comprises the following:

1) Record of materials (raw materials/packaging) received - Date received, quantity of materials received, lot number of materials received, supplier of materials received.

2. Record of materials used - How much of what lot number of what material went into what product.

3. Record of finished products shipped - How much product was shipped where.

 

To do proper traceability, you need to be able to show "one step forward/one step back".

 

In your OP however, you state that you just want to track lot codes and where they ship to.

That's really a simple five column Excel Sheet:

Date

Product

Lot #

Quantity

Shipped To

 

Marshall


Edited by mgourley, 27 December 2021 - 11:32 PM.


792404

    Grade - Active

  • IFSQN Active
  • 22 posts
  • 0 thanks
0
Neutral

  • United States
    United States

Posted 28 December 2021 - 12:20 AM

I guess the question would be, what is the best solution for recording traceability so that it can be found when needed for test recall/recall?

Mike



mgourley

    Grade - FIFSQN

  • IFSQN Fellow
  • 1,323 posts
  • 958 thanks
233
Excellent

  • United States
    United States
  • Gender:Male
  • Location:Plant City, FL
  • Interests:Cooking, golf, firearms, food safety and sanitation.

Posted 28 December 2021 - 12:48 AM

The best solution is to ensure that your people are properly recording lot numbers and quantities.

The best electronic traceability system in the world is worthless if the people that are entering the data are not entering the correct data.

 

We have a fairly robust system where I work, but the results of our traceability system exercises show that now and again, we can't account for 100% of what we are trying to trace. So, I have put in place daily reconciliations of what the people on the floor document that they are putting into inventory and what actually is input into the stock management program.

 

As with all things, it really comes down to training your people so that they understand why it is so important to properly record information that deals with traceability.

 

If you choose to use Excel or Access, you have to limit the inputs by your people so that they are all the same by using drop downs or other data validation.

 

98760 Chocolate Bars and Brand X Chocolate Bars may be the same thing, but if you are doing a quick Find in Excel or are doing a quick filter in Access, they are not the same thing.

 

I know these are really general answers to your questions, so if you can provide some more specifics about what you are actually trying to trace, it might give people more insight to better answer your questions.

 

Marshall



kingstudruler1

    Grade - SIFSQN

  • IFSQN Senior
  • 404 posts
  • 140 thanks
92
Excellent

  • United States
    United States

Posted 30 December 2021 - 06:38 PM

Most larger companies use a ERP/MRP software of some type.    They are not simple but quite complex, and certainly not inexpensive.   

 

Most erp/mrp systems will have a recall report of some kind where you enter a item # and lot # and it provides a report with all of the raw inputs, manufacturing info, product on hand, and where product shipped, etc.   That part is simple.   

 

As mgourley stated - garbage in = garbage out.    improper set up, data errors, rougue transactions, etc can quickly create a mess that goes on for an extended period of time across many lots.   


eb2fee_785dceddab034fa1a30dd80c7e21f1d7~


Leila Burin

    Grade - MIFSQN

  • IFSQN Member
  • 140 posts
  • 42 thanks
16
Good

  • Spain
    Spain

Posted 09 January 2022 - 04:05 PM

Hello 

SAP is a great tool

Leila






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users