Compare the export to the physical inventory
Use the original project list, purchase record, or warehouse export as a starting point, then match each line to an actual reel or package. Record a stable inventory line, reel ID, part number, current balance, and a discrepancy note. An original invoice amount is not proof of the footage or package count that remains today.
The Michigan Economic Development Corporation reported a Dearborn Wagner Place plan involving 12 west-downtown parcels, a $60 million Ford Land Development investment and a long-term plan for as many as 600 Ford employees at the site. That historic redevelopment fact is limited context for release-focused inventory organization; it does not say that cable was available there or that the company is connected to the project.
- Inventory line and reel ID
- Part number or readable marking
- Current balance
- Discrepancy note with quantity basis
Preserve the current quantity distinctions
List full reels, partial reels, cut lengths, and unopened packages on separate lines. For every line, state the reel count, continuous length, and whether the figure is measured, documented, or estimated. A combined total may conceal a short partial reel or a cut length that has different purchasing relevance from an intact reel.
If a record cannot be reconciled immediately, preserve the line with its uncertainty described. For example, report a documented original amount and a current balance that is still estimated; do not present both as one final available quantity.
- Full, partial, cut, or unopened status
- Reel count
- Continuous length
- Measured, documented, or estimated basis
Explain why the stock is available and who can release it
State whether the material is project overrun, warehouse excess, discontinued stock, or a closeout line. Keep reserved material and approval-pending material visible rather than placing them in the available balance. For each line or defined group, record the storage location, known condition, owner role, release authority, requested timetable, and access limits.
Release authority is a seller fact, not a formality. If the warehouse contact can show the reel but cannot authorize sale, say so. That prevents the inquiry from confusing a physical count with material that is already cleared for a transaction.
- Surplus reason
- Reservation status
- Release approval status
- Owner role, location, and access limits
Correct the stale-invoice error
The common mistake is presenting original invoice footage as today’s available quantity and describing every reel as releasable. Correct it by marking the current balance with its evidence basis, preserving per-reel numbers, and labeling reserved or approval-pending stock. The result is a buyer-ready inventory record rather than an optimistic project closeout total.
When a reel is untagged or an approval is incomplete, name that limitation in the discrepancy or release note. Unknowns should direct the next seller action, such as matching a label or confirming the approving role, not be silently converted into an available balance.
- Do not substitute original footage for a current balance.
- Reserved stock stays out of released inventory.
- Unknown labels and approvals are recorded as open items.
Apply the workflow to a fictional overrun entry
Illustrative inventory example—not a purchased lot: OV-D-01 is project-overrun feeder cable with a part number on its tag. It has two reels, 300 feet and 180 feet continuous, documented; condition is uninstalled and release is approval pending. The example demonstrates a record with a useful quantity but an unresolved release decision.
A real entry should include its own discrepancy note, storage details, and the role that can confirm release. It should not state a price, acceptance decision, or transportation term before the specific material has been discussed.
- Reference: OV-D-01
- Quantity: 2 reels, 300 ft and 180 ft continuous, documented
- Condition: uninstalled
- Release: approval pending
