Reconcile the original record to today’s physical stock
Start with the ERP export, purchase order, project list, or other source record, then give every physical reel or continuous length an inventory reference. Record the original quantity and current balance as separate fields. The current balance should say whether it comes from a count, a documented pull record, a measurement, or an estimate.
A project order can explain where a cable came from, but it does not establish what remains for release. If a reel cannot be found, is still allocated, or is only partly documented, leave it outside the current releasable balance until the seller can clarify it.
- Inventory reference
- Original quantity
- Current balance
- Reconciliation basis
- Physical reel or length status
Keep full reels, partials, and cut lengths distinct
List full reels, partial reels, unopened packages, and cut lengths separately. For each line, retain continuous footage, condition, package status, and a photo reference. Identical product numbers can be summarized later only after the physical records confirm that the reels are genuinely alike and each reel’s remaining footage is still visible.
Do not turn several short pieces into one long length or report an original spool quantity as the current balance. Quantity uncertainty is useful information: measured, documented, estimated, and unknown balances should remain labeled as such.
- Reel count
- Per-reel footage
- Continuous length versus cut length
- Condition
- Package status and photo reference
State why the cable is available and what is still held
For every line or defined group, identify whether the material is project overrun, warehouse excess, discontinued stock, or maintenance inventory. Then note reserved quantity, pending return, internal hold, or no known hold. A release status such as available, pending approval, or reserved keeps an inquiry from blending stock that is actually offered with stock that is still committed elsewhere.
Made in Frederick is an initiative of the Frederick County Office of Economic Development intended to strengthen and foster the county’s manufacturing industry. That background makes manufacturing-oriented overrun examples relevant, but it does not establish that any local manufacturer has an available cable lot or that this buyer has handled one.
- Surplus reason
- Reserved quantity
- Pending return or internal hold
- Release status
- Supporting record or note
Document release authority and site facts
Identify the owner or responsible organization, the person who can authorize release, the storage location, access limitations, and the seller’s requested timetable. If release authority is not settled, state that plainly and keep the associated balance marked pending. These facts make the seller’s decision point clear without creating a promise about collection, freight, payment, or timing.
For a multi-reel list, keep the same inventory reference in the spreadsheet, photo filenames, and any release record. That linkage lets the seller correct one line without changing the status or quantity of another line.
- Owner or responsible organization
- Release authority or pending status
- Storage location
- Access limits
- Requested timetable
Fix the invoice-footage error before inquiry
The likely mistake is using invoice or purchase-order footage as if it were the amount currently available. Resolve it by recording a current balance with its evidence basis, separating reserved and pending-return material, and matching the physical reel and photos before any grouping.
Illustrative fictional record—not a purchased lot: OV-FRED-03; project-overrun feeder cable; part number shown on tag; two reels with 300 ft and 180 ft documented; uninstalled condition; release pending internal approval. The fictional record models a current-status entry, not a buyer commitment.
- Current balance rather than invoice total
- Reserved material remains outside the releasable balance
- Pending authority stays visible
- Photos match the inventory reference
