Reconcile the physical balance before listing it
A project purchase order is useful background, but it does not establish what remains. Walk the storage area and create one line for each physical reel, partial reel, or separate cut length. Give every line a stable ID before comparing it to an ERP export, field record, or original order.
The likely error is carrying a project total into the inquiry after some material has been installed, reserved, returned, or moved. Resolve it by keeping a current-status field beside every reel. Use available, reserved, pending release, or unknown rather than turning a project balance into an availability claim.
- Reel or line ID, storage area, and current status.
- Manufacturer, part number, and complete readable cable designation.
- Original record reference and a discrepancy note when it does not match the reel.
Keep remaining footage on a reel-by-reel basis
List the continuous length on every reel instead of supplying one aggregate project figure. Identify whether the amount is measured, documented by a current record, or estimated. A full reel, a partly used reel, and several cut pieces should remain separate even when their jacket printing appears identical.
If a tag shows the original shipped footage while the reel is only partly full, retain the tag image but label the quantity as an estimate until a better current basis is available. This preserves uncertainty without overstating the sellable balance.
- Continuous footage for each reel or cut length.
- Quantity basis: measured, documented, or estimated.
- Full, partial, or cut condition and reel count.
Match the evidence file to the inventory line
Use the line ID in filenames for the reel tag, jacket legend, overall reel view, and any inventory export. The photo set should show the identifying information that belongs to that specific entry, not a representative reel from a different group. Attach a short discrepancy note when a part number, length, or storage location conflicts with the project list.
Nashville’s transportation page lists capital projects, bikeways, sidewalks, road paving, bridges/culverts/guardrails and a street-light retrofit partnership with Nashville Electric Service. That public context does not prove a seller owns any cable or may release it; it is a reason to keep a project label separate from the reel-level evidence.
- Photo reference for the tag, printing, and overall reel.
- Inventory-record reference matched to the same line ID.
- Explicit note for missing, unreadable, or conflicting records.
Make release status a separate decision
For every line, record the person or organization that can authorize a sale and physical release. If a return obligation, owner approval, grant condition, or internal hold is still unresolved, mark it as pending rather than describing the reel as ready. Ownership evidence and product identification answer different questions and both should stay visible.
Include the storage location and any access limits as facts about the current lot. Do not assume that a project manager, a warehouse contact, or a record viewer has authority to release material merely because they can identify it.
- Owner or release authority and seller contact.
- Release status and any approval still needed.
- Location plus loading or access constraints, if known.
Worked record for a balance that is not fully known
Use a plainly illustrative record when part of the balance is uncertain: line OV-N-01; feeder part number copied from the tag; two partial reels; 300 feet documented and 180 feet estimated; status pending release; tag and jacket photos named with OV-N-01. The example is a format, not a claim about a Nashville transaction.
When a field cannot be confirmed, write unknown or describe the estimate method. The resolution is not to borrow a neighboring reel’s footage or treat the original order quantity as current stock. Send the completed line list and matching photos for a lot-specific buying review.
- Example: documented footage and estimated footage shown separately.
- Example: release pending rather than assumed available.
- Example: photo names repeat the inventory line ID.
