Set the physical reel balance ahead of the old order
A purchase order, project schedule, or warehouse export can explain where cable came from, but it does not prove how much remains. Walk the offered inventory and assign a reference to each reel, unopened package, partial reel, or cut length that is physically present. Record its storage site alongside the manufacturer and part number so a later reviewer can see what was actually counted.
The common error is reporting original invoice footage as the available balance and treating every listed reel as full. Keep the historical document in a separate reference field. If an exported reel cannot be located, or a physical reel is absent from the export, add a discrepancy note instead of silently changing the record.
- Give each physically located reel or package a stable reference ID.
- Record manufacturer, part number, storage site, and physical-presence status.
- Keep original-order footage separate from the current-balance field.
Show continuous footage and its evidence basis
List full reels, partial reels, unopened packages, and cut lengths separately. For each entry, state the remaining continuous footage and whether it is measured, documented, or estimated. Two short pieces should not be represented as one continuous reel length merely because their combined total matches an old order.
For an estimate, explain the basis in a short note, such as a documented balance or a clearly identified inventory method. Where no reliable basis exists, say unknown. This distinction gives the buying review an honest current record without treating a warehouse export as a measurement.
- Record reel count and continuous footage per reel.
- Mark each record full, partial, unopened package, or cut length.
- Label every current quantity measured, documented, estimated, or unknown.
Make availability and internal release visible
Explain why the material is being offered: project overrun, distributor excess, maintenance stock, or closeout. Then identify any reserved quantity, pending return, or internal sale approval that affects the reference ID. A reel that still needs authorization can remain in the working list, but its pending status should not disappear inside a grand total.
The City says district energy has existed in Pittsburgh for more than 100 years and highlights district heating, solar PV, building upgrades and resilient infrastructure. That is local project context only; it does not show that a particular project created an overrun or that any cable will be purchased. A seller still needs the reel-level record and release evidence described here.
- State the availability reason for each affected reel or group.
- Link reserved quantities and pending returns to their reference IDs.
- Record the role or department that must confirm a pending release.
Cross-walk records, photographs, and discrepancies
Use the same reference in the inventory row, reel-tag photo filename, jacket-marking photo, and project-record field. A close-up of the tag and a context photo make it easier to determine which record belongs to which reel without assuming that one photograph covers the whole warehouse.
When the tag, jacket marking, export, and physical count differ, preserve each observation and write a concise discrepancy note. Do not select the most favorable value or alter the original document. The resolution is a current reel record that states what is documented, estimated, missing, or awaiting confirmation.
- Name photo files with the inventory reference.
- Keep a project-record reference and a separate discrepancy-note field.
- Photograph readable tags and jacket markings where available.
Worked fictional overrun record
This fictional record demonstrates the distinction between a project document and a current physical balance. It is not a purchased lot, a promise of acceptance, or a record of a Pittsburgh transaction. The pending release and estimated footage stay attached to the relevant reference rather than being hidden in a total.
Use the same layout for actual overrun inventory. If a count has not been checked or a return status is unclear, leave the field estimated, unknown, or pending and identify the record that may resolve it.
- Reference: OV-PGH-02
- Product: project-overrun feeder cable; part number on tag.
- Quantity: 2 reels, 300 ft documented and 180 ft estimated.
- Condition: uninstalled; one reel release pending.
- Record note: warehouse export differs from physical count.
