Start with the physical balance, not the original order
An old purchase order, receiving record, or ERP export can identify a product, but it does not establish the footage or reel count that remains today. Create one line for each physical reel, package, or continuous cutoff. Keep the original quantity in a historical-reference column and place the quantity actually observed or documented in a separate current-balance column.
Use a simple inventory reference that follows the material from the list to the tag photographs. If a line cannot be found, its tag is unreadable, or its footage cannot be supported, label that line unverified instead of borrowing the total from another reel. That separation makes a buyer review the inventory that is actually available rather than a past procurement record.
- Assign an inventory line ID and a physical reel or bundle ID.
- State whether the current quantity is measured, documented, estimated, or unknown.
- Keep full reels, partial reels, and cut lengths on separate lines.
Make release status part of every inventory line
A reel can be physically present and still be reserved, returned to stores, or awaiting internal approval. Add a release-status field such as available, reserved, release pending, or not offered. Do not put reserved footage into an available total simply because it appears in the same warehouse report.
For material offered for review, identify the person or role authorized to release it and describe the storage area, access restrictions, loading information, and any requested timetable. Those facts define the boundary of the inquiry; they do not assume transport, a purchase, or any particular terms.
- Record reel count and continuous length per reel, not only an aggregate total.
- Show unused, removed, or otherwise known material status separately from release status.
- Identify access limits such as dock availability, hours, or appointment requirements.
Keep identification attached to the reconciled line
For every line with a readable product identity, capture the manufacturer or part number, complete jacket designation, conductor metal, size or rating, and condition notes. Use filenames that repeat the inventory reference so a tag close-up, jacket legend, and overview photograph can be checked against the same reel.
If only part of a legend is readable, transcribe only that part and mark the remaining fields unknown. A condition photograph can describe visible packaging, flange, jacket, or end issues, but it should not replace the actual product identification or a quantity basis.
- Match each photo filename to the inventory line ID.
- Keep condition notes with the reel rather than treating one image as evidence for every reel.
- Mark metal, size, or rating unknown when the reel evidence does not support it.
Use Troy context without treating it as inventory evidence
The City of Troy describes its business base as including retail, office, mobility and technology firms. That varied commercial context can make a disciplined release record useful for a local seller, but it does not identify any company as a seller or establish that cable is available.
Illustrative inventory example—not a purchased lot: reference OV-TROY-01; project-overrun feeder cable with the part number on the tag; two reels with 300 ft documented and 180 ft documented; condition noted as uninstalled; release status pending. The example shows why a current-balance field and a release-status field must remain separate.
- Treat the example as a record format, not proof of an actual Troy lot.
- Keep an approval gap visible instead of converting it into availability.
- Use the city fact only as limited local context for the seller workflow.
Correct the common availability mistake before submitting
The usual error is presenting the original invoice or ERP quantity as footage still available while some reels are reserved for another project. Correct it by linking every physical reel to a current-balance entry, flagging reservations and pending approval, and leaving historical quantity in its own field.
When an item remains incomplete, submit the known record with the unknown clearly labeled. The practical next step is an additional tag photo, a physical count, or confirmation from the release authority—not a made-up balance. This protects the identity, length, and status distinctions a buyer needs to assess the particular lot.
- Do not combine historical and current quantities in one figure.
- Do not count pending or reserved material as released inventory.
- Preserve the physical evidence while questions about the balance are resolved.
