Test a chain of events, not a lot-number field
A product can store a lot number without preserving the connections needed to explain where the goods came from and where they went. During a purchase evaluation, ask the vendor to trace a controlled lot through several ordinary transactions. The evidence should connect the records rather than depend on an employee recognizing the same text in unrelated screens.
Choose a test item and define the identifiers the company needs to retain: supplier lot, internal lot, item code and serial numbers where applicable. Identify who captures each value and at what stage. A trace cannot reliably reconstruct an identifier that was never recorded at receipt or shipment.
Microsoft's item-tracing documentation describes tracing by an item and tracking dimension, such as batch or serial number. It also explains limitations, including a trace confined to one legal entity and a snapshot that does not update after the trace runs. These examples show why the scope and freshness of a tracing result need explicit examination.
Have operations, quality and finance agree the business question the sample should answer. A customer list, a quantity balance and a cost record are related outputs, but they serve different purposes. This evaluation does not certify compliance with a product-specific recall rule or replace the company's established response procedures.
References: Microsoft: Item and raw-material tracing, scope and limitations
Create a lot with several known outcomes
Use a hypothetical receipt of 100 units in one lot. Ship 30 units to customer A and 20 to customer B, retain 40 in stock and record 10 as consumed in an approved internal process. The four destinations account for all 100 units. Prepare that expected population before asking the software to trace it.
Add another lot of the same item with a similar identifier. The trace should distinguish the lots and avoid including unrelated shipments solely because they share the product code. Test the identifier exactly as staff will scan or type it, including any significant leading zeros.
Move some retained units between warehouses or bins. Inspect whether the trace preserves the movement without counting the same units as additional receipts. A long list of transaction lines can look thorough while being difficult to reconcile to the actual quantity.
Keep the sample simple enough to verify manually. A huge demonstration containing years of realistic-looking transactions can conceal a broken connection. The initial test should make each missing or duplicated branch obvious before the team evaluates performance on a larger population.
Trace from a customer shipment back to receipt
Start with customer B's shipped document and ask the ordinary user to find the associated lot and supplier receipt. Follow the supported links through the system. Record any point where the user must leave the application or ask someone to interpret an external spreadsheet.
If the company repacks or manufactures goods, include the link between an input lot and the resulting output identifier. Ask the demonstrator to use the production or repacking process proposed for the company. Simply copying the supplier lot into a note does not establish a controlled relationship between consumed and produced goods.
Test a finished item containing inputs from more than one lot where that pattern is relevant. The result should show all applicable input relationships with the scope the product supports. If the application only follows one level at a time, have the user demonstrate the additional steps needed to reach the original source.
Inspect the supporting documents available from the trace. A procurement decision should account for whether receiving evidence, production records and shipment details remain accessible to the appropriate reviewer. An identifier chain without usable source records may leave substantial investigation work elsewhere.
Trace forward without confusing shipped and planned goods
Return to the original receipt and trace forward. Confirm that customers A and B appear with the correct shipped quantities. Then inspect the 40 units remaining in stock and the 10 units consumed. Reconcile the result to the known population rather than counting the number of nodes displayed.
Create an open order allocated to part of the remaining lot, but do not ship it. Ask where the proposed system shows that commitment. A list of posted shipments and a list of pending orders answer different questions; the report should make their statuses clear.
Change the open order after the trace has been generated. Determine whether the displayed result refreshes automatically, requires rerunning or represents a retained snapshot. The user should know which version they are looking at and when it was produced.
If goods move through another legal entity or an external warehouse, demonstrate the boundary. Identify the reference and additional system needed to continue the investigation. A product's tracing capability within one database should not be presented as complete coverage of an external party's records.
Introduce a return and an incorrect identifier
Return five of customer A's shipped units through the supported workflow. Inspect how the trace represents the original shipment, return and current stock position. The total historical shipped quantity and the amount still with customers are different measures; the reviewer needs labels that prevent those totals from being confused.
Make a controlled identifier error on a separate unposted test receipt and correct it using the proposed operating process. Then ask how an error discovered after posting would be handled. The vendor should show the supported correction path and explain which earlier and later records remain linked.
Test a transaction with required tracking information missing. Determine whether the system blocks completion, records an exception or permits a gap. If the implementation relies on a warehouse integration to supply the identifier, repeat the case through that integration rather than testing only manual entry.
Ask how a lot is placed on hold under the company's intended workflow and which actions the hold actually prevents. Inspect an already allocated order as well as a new one. Record the product's behavior without assuming that a status label automatically blocks every downstream process.
Accept a trace the team can reproduce and retain
Have a company user run the backward and forward exercises without the salesperson selecting the right starting record. Time the work and note the external lookups needed. The result should reveal whether the trace is practical for the people who will perform it under time pressure.
Retain the criteria, generation time, relevant quantities and source references from the accepted result. Ask which export preserves the relationships and which merely produces a flat list. Include any required connector, scanning configuration or reporting component in the commercial scope.
Accept the feature when the controlled lot's destinations reconcile, the source can be identified and known limitations remain visible. The company should leave with a repeatable investigation process and clear ownership of the data captured at each handoff, rather than confidence based solely on a populated lot-number field.
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.