Reconcile an order export with physical inventory
Begin with the inventory export or project order, then check every offered line against the reel, coil, or package in storage. Record the current part number, readable jacket marking, storage group, and any difference between the original order quantity and what is physically present. The order can support identification; it does not establish the present balance by itself.
Lewisville’s long-range plans include an I-35E corridor plan covering eight miles and a Business 121 plan covering 8.4 miles, with mobility, quality-of-place and economic-vitality goals. That planning context supports keeping project and release groups distinct in an inquiry; it does not show that a corridor project has cable available.
- Inventory line and matching reel or package ID.
- Current part number and specification from the material.
- Storage group and discrepancy note for each balance.
Separate stock that is available from stock that is not
A useful surplus record has a status column. Identify project overrun, distributor inventory, or another stated origin, then mark whether each line is available, reserved, pending return, or awaiting internal release approval. Do not present a reel as available simply because it remains on an old purchase order.
Where a group is only partly releasable, retain the separate reel IDs and quantities. This is a balance-reconciliation task, so the seller should preserve the distinction between a physical count, a reservation, and an authorization still being requested.
- Surplus origin.
- Current availability status.
- Reserved or pending-return quantity.
- Release-approval status.
Keep the quantity at reel level
List unopened reels, full reels, partial reels, and cut lengths separately. For each entry, record remaining continuous footage and identify whether it is measured, documented, or estimated. Do not replace those fields with a single project total, because a group of partial reels is not the same record as one intact reel.
Use a stable line ID in the inventory and image filenames. Photograph the tag, a legible stretch of jacket printing, and the present packaging or reel condition. That makes the current-balance claim traceable without claiming that the material has already been accepted.
- Reel or package ID.
- Current footage per reel and quantity basis.
- Condition: unopened, full, partial, or cut length.
- Photos tied to the same inventory line.
State the release boundary without guessing terms
Add the storage location, access limitations, and the role that can clear the specific surplus group for release. If a warehouse holds both returnable material and sellable overrun, keep them in different groups even if they share a part number. A status field prevents a seller from offering stock that an internal process has not released.
Describe only seller-controlled site facts. Transportation, price, inspection, and other transaction details are discussed for the actual lot rather than assumed from a project name or the size of an old order.
- Location or storage group.
- Access notes.
- Release-authority role.
- Items excluded because they remain reserved or pending return.
Use a current-balance example to catch the mistake
The common error is copying original invoice footage into the inquiry as though every reel is still full and releasable. Correct it with a physical count, a per-reel quantity basis, and an explicit availability status. Keep an estimated partial reel separate from a documented full reel even when their product markings match.
Illustrative fictional record: OV-LV-02 lists two project-overrun reels with the part number photographed. One has 300 feet documented and is available; the second has 180 feet estimated and remains pending release. The warehouse location is still to be confirmed. This shows an honest surplus balance, not a purchased lot.
- Example reel A: 300 ft documented, available.
- Example reel B: 180 ft estimated, release pending.
- Product identification photographed.
- Warehouse location to be confirmed.
