With the batch number and serial number overview in the Barcode Scan App you trace in a few clicks where a batch or serial number is and which route it has taken: from the goods receipt from the supplier, through transfers and production, to the delivery to the customer. All data comes from Exact Online.
In short:
- Batch number overview and Serial number overview per item: all numbers with quantity, warehouse and storage location.
- History per batch or serial number: a timeline with every stock movement.
- Every delivery shows the customer and sales order, every receipt the purchase order.
- Useful for recalls, complaints, shelf life and audits (HACCP, GMP, ISO).
- Works with the batch and serial numbers that are already in Exact Online. Nothing extra to register.
Why traceability?
In food, pharma, cosmetics, medical devices and technical wholesale you need to know quickly which customers received a particular batch (tracking) and where a product came from (tracing). Exact Online stores this data, but it is spread over receipts, deliveries and stock movements. The Barcode Scan App lists it per batch or serial number, also on the scanner in the warehouse.
Batch number overview
Go to Inventory, search for or scan the item and click Batch number overview. At the top you see the item details, such as item code, description, barcode, item group and default storage location. Below that is a table with all batch numbers of the item:
- batch number
- quantity in stock
- warehouse
- storage location
You can sort and filter on every column. For example, type part of the batch number to find the right batch straight away. For serial items the Serial number overview works the same way.
The history of a batch or serial number
Click a batch number. You see the expiry date and a timeline with every stock movement of that batch. Each movement shows the date, the type, the quantity, the warehouse and the storage location. Drafts are marked separately. Depending on the type you also see:
- Goods receipt: receipt number and purchase order, and therefore the supplier.
- Goods delivery: delivery number, customer name and sales order.
- Transfers: from and to which warehouse or storage location.
- Production and assembly: material issue, finished product receipt, by-products and assembly.
- Counts and adjustments: stock counts and manual adjustments.
From the timeline you click through to the receipt, delivery, sales order, warehouse or storage location. From a goods delivery you can also go straight to the history of the delivered batch.
Example: a recall
A supplier reports that batch L2026-114 of a raw material is defective. This is how you handle it:
- Open the item and the Batch number overview. You immediately see how much of the batch is still in stock and on which location. You can block that stock or set it aside right away.
- Open the history. The goods deliveries show the customers who received the batch.
- If the batch was used in production, you see the material issue on the work order. Then follow the batch of the finished product in the same way.
Make sure the chain is complete
Tracing is only as good as the registration. So record batch and serial numbers at every step:
- For incoming goods, scan the batch number or the supplier's GS1 barcode, or generate your own batch number and print a batch label.
- When picking, scan the batch, optionally with FEFO or FIFO as a help.
- For transfers and production, include the batch in the posting.
Read more about registration on batch and serial numbers and in the blog inventory management for food and pharma.
Frequently asked questions
How do I trace a batch number in Exact Online?
In the Barcode Scan App, open the item under Inventory and click Batch number overview. You see all batch numbers with quantity, warehouse and storage location. Click a batch number for its history: a timeline with every stock movement of that batch, from receipt to delivery.
Which customers received a particular batch?
In the history of a batch number, every goods delivery shows the delivery number, the customer name and the sales order number. In a recall you immediately see which customers received the batch.
Which supplier did a batch come from?
The history shows the receipt number and the purchase order for every goods receipt. The purchase order tells you the supplier.
Does this also work for serial numbers?
Yes. Serial number overview shows all serial numbers of an item and where they are. The history of a serial number shows the same timeline as for batch numbers.
Which movements are shown in the history?
All stock movements from Exact Online: goods receipts, goods deliveries, returns, warehouse and location transfers, stock counts, material issues and receipts of work orders, assembly and stock adjustments. Drafts are shown and marked as well.
Do I need to register anything extra?
No. The app uses the batch and serial numbers that are already in Exact Online. Do make sure you register them at every receipt, delivery and transfer, for example by scanning GS1 barcodes or batch labels. Then the chain is complete.