Reconcile records to the material on hand
An original purchase order or warehouse export helps identify what was ordered, but it does not establish today’s remaining reel count, footage or condition. Create a current-balance line for every reel or continuous piece. Include the original inventory reference, reel ID, current footage and the basis for that number: measured, documented or estimated. Link a tag or photo filename that shows the physical match.
Do not turn several full reels, partial reels and cut lengths into one total. The balance should retain the length and condition of each item so a seller can show what remains without treating historical volume as present availability.
- Include the original inventory reference and a separate current-balance field.
- Use one line for each reel or continuous piece.
- Tie photo filenames and physical-count notes to the same reel ID.
Make availability and release status visible
For each line, record whether it is available now, reserved, pending return or pending approval. Add the owner or seller-side release contact, storage location and gate or access limits that are known. A line on an export is not automatically an offered line; the inventory record should make that distinction visible before a buyer is asked to interpret it.
When authority is not yet confirmed, leave the release status pending and name the available contact path rather than calling the reel releasable. This is a documentation task, not a request to assume ownership, timing or transport terms from an invoice.
- Separate available, reserved, pending-return and pending-approval entries.
- List the release contact or mark the authority pending.
- Keep access limits and location notes with the current-balance row.
Preserve part-number identity while reconciling quantity
Group only genuinely matching product designations, and keep each reel’s footage, condition and photo reference visible inside that group. If a seller has partial reels or cut lengths with the same part number, the line items should still show the individual continuous amounts. This protects the difference between a documented full reel and an estimate for a smaller remaining piece.
The city’s Innovation Core page describes a broader nearly 7,000-acre, 10.5-square-mile State Land Trust development area along Loop 303 and Lake Pleasant Parkway to State Route 74, planned for industrial, commercial, mixed-use and employment projects. That public planning context can help explain why a seller is organizing project records, but it does not prove that a project left a particular cable balance or that the material may be released.
- Keep manufacturer, part number, designation and per-reel footage beside the reel ID.
- Mark unknown quantity or release fields explicitly.
- Do not use a project name as proof that a reel is surplus or available.
Worked current-balance record
Illustrative inventory example—not a purchased lot: OV-P01; project-overrun feeder cable; part number copied from tag; reel A: 300 ft documented; reel B: 180 ft estimated from a partial-reel note; condition: uninstalled; release: pending approval. This fictional example keeps a documented amount, an estimate and release status in separate fields instead of presenting one historical total.
Before sending the list, compare the export against the physical reel count and flag every variance. A prioritized list can show which lines are fully documented and which still need access, a photo or approval. That is a practical way to begin an inquiry without pretending that a pending line is ready for transaction.
- Required fields: inventory line, reel ID, current footage, quantity basis and physical-match note.
- Add reel condition, continuous length, reservation or return status and release status.
- Add manufacturer, part number, photo filename, owner or release contact, location and access limits.
