The fictional shop below received 120 components from one supplier lot. Its component records account for every piece, split between unissued stock and two production jobs. To finish the comparison, the shop needs the batch records that connect those jobs to finished pieces, and the stock or shipment records that show where those pieces are recorded at the cutoff.
In one version, those records account for all 120 pieces once. In the other, five still lack a link to a finished batch, even though the receipt and issue totals balance. Give those five their own line and identify the missing record.
Start with the receipt and its lot references
Open the receipt that identifies the component and the supplier’s lot. Put the supplier’s label beside the internal item and batch references used on the shop’s records. Keep the document that connects them. If two rows carry a similar lot label, check the item, supplier and receipt before treating the labels as a match.
Microsoft’s Dynamics 365 trace uses an item number and a recorded tracking dimension such as a batch number. It shows one legal entity at a time and traces one level of a bill of materials or formula. The date filter selects records by creation date. Results reflect information available when the trace runs. Microsoft Learn on item tracing
For the worksheet, give the trace a cutoff and record when the evidence was collected. Check which movements are posted through the cutoff and preserve the records you used. A date filter and the time you extract the data answer different questions from whether an individual movement belongs in the Day 7 trace. Leave pending or later-posted rows outside this version and note any material differences to check.
All quantities and references in the example are fictional. The Canadian shop has one legal entity and one plant. Receipt R-17 shows 120 pieces of component C-2. The supplier’s label V17 maps to internal lot L17 in the receipt record. One component goes into each finished piece in a single production step. The exercise has no scrap, rework, substitutions, other outputs, transfers or inventory adjustments. These boundaries keep each row on the same piece-count basis.
Reconcile the issues before following the output
Use the posted material issues to check how many components actually went to each job. A job’s planned requirement helps identify what to look for. The posted row provides the item, actual lot, piece count and job reference for this trace.
The fictional records through Day 7 show three component quantities.
25 components remain unissued in the scoped component records.
70 components were issued to job A-10 from L17.
25 components were issued to job B-20 from L17.
The first check is 25 + 70 + 25 = 120. The two job issues represent 95 of the received pieces. Keep the issue records against their job references so someone else can rerun the check. If one issue appears in two views, match its posting reference before including it. The two views can point to the same movement.
Balancing the receipt and issues establishes where the component records lead. Next, check the finished output connected to each job. Without that link, the issue records leave a separate question about where the components appear in the finished records.
Match the finished batches to stock and shipments
The job record connects A-10 to 70 posted finished pieces in batch FA-10. Two dispatch rows identify that batch. SH-01 lists 30 pieces and SH-02 lists 20. That gives 50 matched pieces shipped by the cutoff. The stock record identifies the remaining 20 finished FA-10 pieces on site. For B-20, the posted output identifies 25 pieces in finished batch FB-20, all recorded on site in this version.
Check the shipment reference alongside the finished-batch reference. A sales order can help you find the shipment record, but the order quantity alone cannot establish the quantity dispatched. Similarly, the stock line here describes what the matched records show at the cutoff. Physical presence or later customer receipt would require separate evidence.
The end of the trace now has three categories.
25 unissued components in the component records.
50 finished pieces with matched shipment records.
45 finished pieces recorded on site, comprising 20 from FA-10 and 25 from FB-20.
That accounts for all 120 pieces on the example’s one-for-one basis. The 95 components issued and 95 finished pieces are intermediate counts along the same chain. Once you have included the finished pieces in the shipment or on-site categories, adding either intermediate count to the terminal total would count those pieces twice.
Leave a separate line for the five unresolved pieces
Return to the same Day 7 cutoff and change only the B-20 evidence. The posted component issues, the unissued balance and the FA-10 records stay the same. B-20’s aggregate completion total is still 25. This time, the owner can confirm a finished-batch connection and on-site stock record for only 20 of those pieces.
The first check still balances at 120. The later records now account for 25 unissued + 50 shipped + 40 finished on site = 115 in matched terminal categories. Keep five pieces unresolved. The arithmetic then totals 120, with a visible difference between the matched categories and the amount still needing evidence.
The job total gives the owner a place to look. For the five pieces, ask the person responsible for production records for the dated B-20 completion row, the finished-batch assignment and its link back to the material issue. Then check whether a matching stock or shipment record exists at the cutoff. An unresolved link establishes no physical location or disposition for those five. If the information comes in later, keep the Day 7 version and document which evidence supports the update.
Copy the lot-trace worksheet
Give the trace a named owner and keep supporting record versions next to the rows. Repeat the issue, output and shipment lines for each distinct posting.
Receipt and scope. Entity and site ___ / cutoff and extraction time ___ / receipt reference ___ / item and unit ___ / quantity received ___ / supplier lot to internal lot link and evidence ___.
Component movement. Unissued quantity and record ___ / posted issue reference and date ___ / job ___ / quantity and lot ___ / receipt-to-issue arithmetic ___.
Finished output. Posted completion reference and date ___ / job and matched finished batch ___ / confirmed count and unit relationship ___ / evidence that ties the output to the lot ___.
Terminal record. Finished batch ___ / matched shipment references and amounts ___ / recorded stock on site ___ / distinct rows counted once ___.
Control and exception. Unissued plus matched on site plus matched shipped ___ / unresolved quantity ___ / reconcile to receipt ___ / missing link or supporting record ___ / responsible person and next check ___.
A reader should be able to use the worksheet to repeat the trace, find each connection and see which quantity remains open. If the separate question is whether to keep, return or sell confirmed stock, our guide to inventory ageing before a sale shows how to weigh condition, requirements and the options actually available.
This guide is for general information and education. The fictional example illustrates a record trace. Confirm your own records and their scope before relying on a comparison.
Subscribe to Deal Flow Canada for practical owner guides and Canadian deal updates.


