A customer asks which of their coils supplied Bundle D. The warehouse clerk finds the bundle on the shipment. The original receipt names Coil A, but that coil no longer appears in the list of usable stock. How can the clerk show the customer where those sheets came from?
In this fictional job, the clerk starts with the bundle the dispatcher shipped. Its stock record links back to the cut that made it and the coil the operator fed into the line. The stock ledger lets the clerk tell the customer how much of the same steel each site still holds.
Start at the two bundles
The shipment names Bundle D and Bundle E, each with 40 sheets and a recorded stock weight of 2.900 t. The partner warehouse held both bundles until dispatch.
On the customer’s delivery document (the delivery challan), the clerk finds a loading weight of 2.880 t beside Bundle D. Its stock record carries the same bundle identity and the 2.900 t recorded at production. That identity lets the clerk trace the sheets back to the cut even though the two weights differ.
A planner can also estimate weight from the steel’s dimensions. If an operator confirms that estimate as the stock weight, the application records the confirmation. It stores weights in tonnes to three decimal places and keeps the counts with their units.
Trace Bundle D through the partner site
Bundle D’s production record leads to a narrow cut-to-length job at the partner site. The partner cut Coil B (6.000 t) into sheets. Of that coil, 2.900 t went into Bundle D, 2.900 t went into Bundle E, and 0.200 t was recorded as scrap.

One step further back, the slitting record shows that Coil B came from Coil A at the primary site. The transfer and receipt follow the same physical coil all the way to the partner. It kept its identity until the partner cut it. That is why the diagram shows Coil B once.
Each link preserves the input, the output, the operation, and the weight contributed. Even when several coils feed one operation, the clerk can see how much steel each supplied to a particular output. Here, a single link accounts for all 2.900 t in Bundle D.
Recreate the first split from its ledger entries
The receiving clerk recorded Coil A at 10.000 t. When the slitting result posted, one ledger entry removed Coil A from usable stock and the others recorded what the cut produced. The table shows the weight movements for that operation.
| Movement | Material | Recorded stock weight change |
|---|---|---|
| Consume source | Coil A | −10.000 t |
| Create usable output | Coil B | +6.000 t |
| Create usable output | Coil C | +3.700 t |
| Record classified output | Trim | +0.300 t |
| Sum | 0.000 t |
The zero in the last row means that every tonne going into the cut came out in one of those three pieces of stock. The planner can look up the two usable coils individually. The trim also has its own stock record, so the warehouse can account for it under the customer’s receipt.
The stock movements and their links to Coil A are saved in the same transaction. While a result awaits review, the reviewer can see the proposed outputs. Once the result posts, the planner can look up each new coil and trace it back to the cut that produced it.
After dispatch, the primary site still holds 3.700 t in Coil C and 0.300 t of trim. The partner holds 0.200 t of scrap. The 4.200 t still held and the 5.800 t dispatched account for the entire 10.000 t receipt. The delivery readings total 5.760 t. The 40 kg difference stays on the shipment record.
Which steel can the planner use?
Of the steel still on hand, Coil C is the piece a planner might use for another job. They check its current availability because another job may already have claimed some of it. The same distinction mattered before dispatch. Two dispatchers could both see Bundle D on screen. Once one prepared the packages, the other could no longer reserve that bundle.
What if the slitting record was wrong?
Suppose the clerk finds an error in the first cut. If the affected outputs are still available and a reversal is permitted, an approved correction can reverse the original movements and post the replacement. The replacement outputs get new identities. A clerk looking up an old label can still find the original entry and its correction.
In this shipment, the partner has already cut Coil B into sheets. Restoring Coil A while leaving those bundles on the books would count the same steel twice. The application blocks that reversal, and the clerk can follow the link to the partner job to see why.
The clerk can now give the customer a specific answer. “Your Bundle D contains 40 sheets from Coil B. The slitting record traces all 2.900 t back to your original Coil A.” If the customer wants another cut from that receipt, the planner knows to check Coil C at the primary site first.
Previous — A Modular Monolith for the Factory and Back Office · Series index · Next — Choosing the Right Process for a Coil
Discussion
Comments 0
New comments are moderated before they appear publicly.
Be the first to leave a thoughtful comment.