Skip to content

What batch and traceability reports do I have?

These are the reports from the usual Batch control and traceability menu: which batches there are, how they came in and went out, and the full traceability you hand over in a health inspection. Traceability also follows a batch through production: from the raw material to the customer who bought the product manufactured with it, and the other way round.

Where are they?

In the Warehouse → Batches and traceability menu, separate from the warehouse reports. The options are the same as in the Desktop ERP, split into groups:

GroupOptionWhat it produces
BatchesBatch report by number / by itemEach batch of each item and warehouse with its stock
Outgoing items without a batchWhat went out of a batch-tracked item without saying which batch
Batch summary by number / by itemPer batch: what there was at the start of the period, what came in, what went out and what is left
Batches by expiry dateBatches in stock, from the soonest to expire to the latest
Incoming batchesBy item, number, date or supplierEach receipt of a batch with its document and its supplier
Outgoing batchesBy item, number, date or customerEach issue of a batch with its document and its customer
Batch movementsBy item, number or dateIncoming and outgoing together
TraceabilityDetailed by documentWhere each batch came from and who it was delivered to, document by document
Detailed by itemThe same, and below each production run what happened to what was manufactured
Summarised by batch / by batch and warehouseOne line per batch, destination and type of stock movement
Serial numbersSerial numbers by itemSerial numbers in stock, with their warehouse and their date in

The ‘by item’, ‘by date’ or ‘by customer’ options are the same report with a different split: when you open them, the Subtotals by field is already filled in, and Movements says whether the outgoing movements, the incoming ones or both are included. You can change them before clicking View.

How do I see which batches expire first?

With Batches → Batches by expiry date. It lists the batches that have stock, sorted by expiry date: at the top, what expires first, which is the first thing to sell or withdraw. Each row gives the Expiry date, the Status, the item, the batch, the warehouse and the Stock, with the total at the end.

The Status is the same as in the item record: Expired if the date has passed, Expiring soon if it expires within the next 30 days and Valid if there is longer to go.

Items with serial numbers are not listed: the expiry date goes by batch. The date is the one entered when the batch was received.

How do I get the traceability of a batch for an inspection?

  1. In Warehouse → Batches and traceability, Traceability group, click Detailed traceability by product.
  2. Type the batch in Batch from and Batch to, or the item in Item from and Item to. The item, warehouse, item family, customer, supplier and sales agent codes have a magnifying glass (or F2) and show the name next to them.
  3. Choose the direction:
    • Forward: who it reached. This is the question for a product recall. Only what went out of the batch is shown: which customers it was sold to and what it was used in.
    • Backward: where it came from. This is the question for a customer complaint. Only what came into the batch is shown: which supplier it was bought from and which components it was made with.
  4. Click View to see it on screen, Print for paper or Download PDF.

An empty range doesn’t restrict anything. With no range at all you get the traceability of every batch, which can be long.

You can get there directly from the item record: on the Batches tab, click the batch and then Detailed report.

What is the traceability showing me?

One section per batch, with its header (Warehouse, Batch and the item) and its total.

In the detailed version, each row is a stock movement of the batch: Date, Name of the customer or supplier and Document. Item, Description and Batch say where it ended up: the same batch, except in a production run, where you see the product that was manufactured with it (or, going backward, the component it came from). Expiry date is that batch’s.

In and Out are units of the batch itself, and the total adds up only the rows shown. Stock is what is left of the batch after that stock movement, also counting the movements in the other direction even though they are not shown; in the total row, what is left of the batch. So, going forward, a sale of 1 from a batch bought as 5 shows stock 4.

In the by item version, below each production run you see, indented with one dot per level, the rows for what happened to what was manufactured: which customers it was sold to and, if it was in turn used to manufacture something else, the next level. Its quantity goes in the Product column and doesn’t add to incoming, outgoing or stock: they are units of another item.

The summarised version has no documents: it puts on one line everything that went to the same destination by the same type of stock movement (all the sales, everything consumed in a product).

Why do customers outside the dates I set appear?

Because the ranges restrict the stock movements of the batch, not what hangs off a production run. If you ask for January’s flour, you get January’s production; but the customers of the bread made with it all appear, even if it was sold in February.

This is intentional and it is what the Desktop ERP did too: in a recall you have to notify all the customers of the product, not just the ones from that month.

What counts as ‘customer’, ‘supplier’ and ‘document’ in the ranges?

Documents are searched in all financial years of the company: a batch bought last year appears with its purchase.

If something goes wrong

What you seeWhat has happenedWhat to do
‘No batch in those ranges.’No stock movement with a batch meets the rangesWiden the dates or remove a range
Notification: ‘There are more than 100.000 stock movements: the report is incomplete.’With no ranges, the company has too many stock movements for a single reportNarrow it down by date, item or batch
The production run appears with no product below itThe manufactured product isn’t batch-trackedThis is correct: there is no batch to follow
The reports come out empty even though you buy with batchesThe items aren’t batch-tracked, or batch management is switched offCheck the Traceability of the item record or of its item family (Work with batches and expiry dates)
‘Could not generate the traceability PDF.’The layout failedTry again; if it keeps happening, tell support

See also: Follow the traceability of a batch or a serial number · Work with batches and expiry dates

More about Warehouse