Reconcile the current balance
A purchase order or project export records what was ordered, not necessarily what remains. Compare each source-document line with the physical reel or package at the storage site. Record the source document ID, current reel ID, current footage, discrepancy note, and storage site so the record distinguishes an original quantity from today’s balance.
If a reel is missing, partly consumed, or has no readable label, say so in the discrepancy note. Footage can be measured, documented, or estimated, but the basis needs to travel with the row.
- Source document ID and current reel ID.
- Current footage with measured, documented, or estimated basis.
- Storage site and discrepancy note.
- Tag and jacket photographs linked to the inventory reference.
Keep each available form separate
Full reels, partial reels, unopened packages, and cut lengths make different seller records. Retain the part number, reel count, footage per reel, and full/partial/cut status instead of replacing that detail with one invoice total. Only group items when their specification and individual lengths are genuinely matched.
This workflow is about whether material is currently available and releasable, not whether two cables merely look similar. A 300-foot documented reel and a 180-foot estimate should remain distinct even if both came from the same project order.
- Part number and reel count.
- Footage per reel rather than only a total.
- Full, partial, package, or cut status.
- Photo references matched to the same row.
Show why stock is available and who controls release
State whether each row is project overrun, distributor stock, maintenance excess, or closeout material. Then record reserve or return status, ownership, and the person or department that must approve release. A held reel can appear in the record, but it must not be represented as an available balance.
If approval is pending, use release pending and identify the missing approval or mark the authority unknown. The inventory page should not imply that a list alone authorizes a sale or movement.
- Availability reason.
- Reserve or return status.
- Ownership and release approval.
- A separate line for pending quantities.
Fix invoice-footage errors with a fictional record
The specific mistake is presenting original invoice footage as the remaining quantity. Correct it by retaining the evidence basis for the current balance and separating reserved or pending quantities from the offerable line.
Illustrative inventory example—not a purchased lot: OV-BTH-02; project-overrun feeder cable with part number on tag; reel A 300 ft documented; reel B 180 ft estimated; uninstalled; release pending; tag and jacket photographs linked to OV-BTH-02. It is a format example, not a claim of available inventory.
- Do not use invoice totals as current footage.
- Use one line per reel or matching documented group.
- Leave release status pending when approval is not documented.
Apply local context with narrow relevance
The city identifies two downtowns with distinctive characters and links its economic-development work to tourism, entrepreneurship and development projects. That fact supplies a limited project-closeout context only; it does not establish that a downtown project has cable for sale or that any seller will be accepted.
Email a reconciled inventory and matching photos to saleselectricalbuyers@gmail.com, or call +1 (614) 715-3047 for a discussion of the specific lot. Keep pending and reserved material visibly separate as records are reviewed.
- A current balance, a release field, and matched photos are more useful than an original-order total.
