Traceability & recall

Both directions, while the caller is still on the line.

Backwards from a finished case to every supplier lot inside it. Forwards from a lot to everywhere it went and what it became — the question a recall actually asks.

Lot A4471 · pork shoulderrecall drill
Received fromDanao Meats · 04 Sep212 kg
Used in batchBR-4471 Longganisa118 kg
Used in batchBR-4473 Chorizo74 kg
Shipped toAyala, IT Park, Mactan3 outlets
Soldbetween 06 and 11 Sept184 kg
Still on handrecoverable now8 kghold
Datche AI
A supplier just called about lot A4471. Where did it go?
Tracing both directions…
3 outlets, 2 batches
184 kg sold, 8 kg still on the shelf — while the caller is on the line
both directions · 1.4 seconds
What it is

Lot and batch genealogy through receiving, production, transfer and sale, in both directions, walked from the records each time it is opened.

How it works

What it actually does.

01

A drill you can run any Tuesday

Pick a lot, ask both questions, and time it. Run it in front of your auditor and traceability stops being a promise and becomes evidence.

  • Walked from the records at the moment you ask, so it cannot drift from the books.
  • The scope is exact — four customers instead of forty is a different year.
  • Certificates of analysis held with the lot they describe.
BatchHeldReleased
24-0917 · pork belly0 kg624 packsQA passed
24-0918 · bulk2 batchesawaiting QA
24-0919 · foodservice0 kg412 packsQA passed
24-0916 · retail48 kgrecalled 14 Sep

A batch that is held cannot be picked, sold or transferred. The rule is in the database, so it holds whichever screen somebody tries.

02

It holds after we leave

Traceability here is the shape of the data, not a report somebody maintains. It is still true in year five with nobody minding it, which is the only kind that matters.

  • Stock with no lot number is listed, because it cannot be traced later.
  • Cold chain logs attach to the batch, so record and goods never travel separately.
  • Every movement that put stock somewhere has something taking it off somewhere else.
What it costRecall 24-0916 · posted
DebitCredit
Recall expense₱3,204.00 
Inventory — finished goods ₱3,204.00
Balanced ₱3,204.00₱3,204.00

A recall is a movement like any other. Nothing is deleted, so the history still shows what happened and when.

Questions

The ones people ask about this.

How far back does it go?

As far as the records do. Every movement is kept, so the walk is limited by when you started rather than by a retention window.

Does it cover things we made, not just bought?

Yes — that is the harder half. A production run links the input lots to the output lot, so the walk crosses the kitchen rather than stopping at it.

What about items with no lot number?

They are listed as untraceable stock, with a value, because that figure is the real size of the gap in a recall.

See it on your own figures.

Bring one ordinary day from your business and we will run it through in front of you, on your own items and your own prices.