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:
| Group | Option | What it produces |
|---|---|---|
| Batches | Batch report by number / by item | Each batch of each item and warehouse with its stock |
| Outgoing items without a batch | What went out of a batch-tracked item without saying which batch | |
| Batch summary by number / by item | Per batch: what there was at the start of the period, what came in, what went out and what is left | |
| Batches by expiry date | Batches in stock, from the soonest to expire to the latest | |
| Incoming batches | By item, number, date or supplier | Each receipt of a batch with its document and its supplier |
| Outgoing batches | By item, number, date or customer | Each issue of a batch with its document and its customer |
| Batch movements | By item, number or date | Incoming and outgoing together |
| Traceability | Detailed by document | Where each batch came from and who it was delivered to, document by document |
| Detailed by item | The same, and below each production run what happened to what was manufactured | |
| Summarised by batch / by batch and warehouse | One line per batch, destination and type of stock movement | |
| Serial numbers | Serial numbers by item | Serial 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.
- Expiring up to: only the batches that expire on that day or earlier, already expired ones included. Empty, all of them are listed.
- Warehouse, Item and Item family narrow it down as in the other reports.
- Include batches without an expiry date: adds at the end the batches in stock that have no expiry date. Unticked they are left out, because there is nothing to sort them by.
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?
- In Warehouse → Batches and traceability, Traceability group, click Detailed traceability by product.
- 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.
- 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.
- 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?
- Customer: keeps only the sales to those customers.
- Supplier: keeps only the purchases from those suppliers.
- Sales agent: keeps only the documents with a sales agent in that range.
- Documents (All, Sales, Purchases, Production or Warehouse) and Document from/to: the type and the number of the document.
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 see | What has happened | What to do |
|---|---|---|
| ‘No batch in those ranges.’ | No stock movement with a batch meets the ranges | Widen 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 report | Narrow it down by date, item or batch |
| The production run appears with no product below it | The manufactured product isn’t batch-tracked | This is correct: there is no batch to follow |
| The reports come out empty even though you buy with batches | The items aren’t batch-tracked, or batch management is switched off | Check 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 failed | Try 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
- How do I raise or lower the prices of many items at once?
- How do I view and correct an item’s stock?
- How do I count the warehouse and balance the stock?
- How do I add a warehouse?
- Managing the warehouse
- How do I move stock from one warehouse to another?
- How do I run the stock report?
- How do I follow the traceability of a batch or a serial number?
- How do I work with batches and expiry dates?
- How do I work with serial numbers?
- How do I work with sizes and colours?