Reconcile the export with physical stock
Begin with the spreadsheet, purchase order, or project export, then match every offered line to a reel, box, or continuous piece at the storage site. Add a physical reference, part number or full marking, current quantity, and a discrepancy note. An old total is a starting record, not proof that the same amount is still on hand.
The mistake specific to project overrun is presenting a project total as presently releaseable inventory even though some material is reserved, returned, consumed, or awaiting approval. Resolve it by retaining the physical count and release status on each line; do not include a non-releaseable balance in the offered group.
- Inventory line and physical reel or box reference
- Full product marking or part number
- Current quantity with measured, documented, or estimated basis
- Discrepancy note between export and physical stock
State why the material is being released
Classify the availability reason without inventing dates or explanations: project overrun, discontinued stock, warehouse excess, or another documented reason. Keep that reason separate from product identity. A line can be an overrun and still require its own cable designation, continuous footage, storage condition, and photographs.
Frisco Pump Station #4 is being built with two ground storage tanks totaling 20 million gallons, with a pipeline planned to connect the station to the existing water distribution system. This public project is only local context for why a seller may preserve changed-scope documentation; it does not identify wire or cable at the project, a seller, or an available lot.
- Availability reason stated from existing records
- Project reference treated as background, not cable identity
- Condition and storage note per physical line
- Date left unknown when no record establishes it
Keep release status visible
Use a status field such as available, reserved, pending return, or approval-pending. Keep partial and full reel lengths attached to that status rather than rolling them into one project total. For an approval-pending line, identify the role that controls release if known; if it is not known, mark the field unknown.
This release workflow differs from a building-wire balance. A perfectly identified reel may still be unavailable to offer, while an approved line can have a modest quantity. The decision here is whether a physical item is actually authorized for a sale discussion, not merely whether the wire is identifiable.
- Release status per line
- Approval owner or unknown
- Reserved quantity kept outside the available balance
- Full or partial reel length retained beside status
Package only the authorized groups
Match photo references to inventory lines, then state whether the inquiry contains one lot or several defined lots. Include the storage location, ownership record or internal release reference, access restrictions, and any known loading information. These details clarify the scope without assuming payment, transport, or acceptance terms.
If several locations or status categories are involved, do not mix them to make the total look cleaner. Defined groups allow the seller and buyer to discuss the same material and preserve the decision point that has not yet been resolved.
- Photo references tied to each inventory line
- Ownership or release record
- One-lot or defined-group designation
- Storage location and access context
Test the workflow with a fictional line
Illustrative inventory record — fictional example, not a purchased lot: OR-14; feeder cable with part number photographed; two reels, 300 ft and 180 ft continuous, documented; uninstalled; availability reason project overrun; release status approval-pending. The record does not add the 480 ft to an available total while approval is unresolved.
A final check compares the physical reference, current quantity, photo set, availability reason, and release status. That simple comparison prevents a returned or reserved reel from silently remaining in the offer list.
- Illustrative reference: OR-14
- Two documented reel lengths: 300 ft and 180 ft
- Reason: project overrun
- Release status: approval-pending
