top of page

MEP Replacement Deliveries: Do Not Count Returned Items Twice

Oct 27
4 min read
AI-generated illustrative scene: separate crates of generic pipe fittings at a receiving bench. Not product or project evidence.

AI-generated illustrative scene, not a product screenshot or a completed-project photograph. The worked calculation below uses explicit example inputs.


A delivery register can show more units received than the purchase order requires while the site still lacks usable material. This is common when damaged goods are replaced and the original delivery row is not reconciled with its return. The answer is not to delete history or force the delivered total to equal the order. Preserve physical movements and report the usable, accepted quantity separately.


This is an original inventory-record example, not an interpretation of a contract or a payment recommendation. The actual purchase terms, inspection procedure and authorized acceptance decisions govern the project. All items below are the same approved specification, and the accounting cutoff is after the listed movements but before any installation or issue.


1. Give every status a precise meaning


For this example, received means physically arrived; accepted means recorded as suitable for the intended stock under the project's process; quarantined means held pending disposition; returned means physically dispatched back. These are explicit example definitions, not universal software field meanings. A delivery receipt alone is not the same record as an acceptance decision.


The USPS receiving-process guidance provides a useful public process example: check shipments against delivery records and requirements, note discrepancies and retain records of shipment condition. Its procedures apply to its own procurement setting. The transferable lesson here is record separation; it does not impose USPS contractual rules on a Qatar MEP project.


2. Follow one order through three arrivals


Assume an order calls for 100 identical items. The first delivery contains 80. Inspection accepts 68 and quarantines 12 damaged items. Those 12 are subsequently returned with a return reference linked to the original receipt. A replacement delivery brings 12 acceptable items. A final balance delivery brings 20, of which 18 are accepted and two remain quarantined at the cutoff.


Gross receipts = 80 + 12 + 20 = 112 items.


Physical returns = 12 items.


Physical on-site balance = 112 − 12 = 100 items.


Accepted on-site quantity = 68 + 12 + 18 = 98 items.


Quarantined on-site quantity = 2 items.


Physical check = 98 accepted + 2 quarantined = 100 on site.


The site physically holds 100 items, but only 98 are accepted in this example. The order's usable-quantity gap remains two. Gross receipts of 112 are not an overdelivery of 12 usable units: twelve earlier units left the site. Equally, counting the initial 80 as accepted and adding all replacements would overstate usable stock.


An order for 100 items receives 80 initially, 12 replacements and 20 balance items: 112 gross receipts. Twelve returns leave 100 on site, comprising 98 accepted and 2 quarantined.

Original illustrative planning diagram. Assumptions and limitations are stated in the worked example.


3. Keep movements and status changes distinct


Returning the first twelve units is a stock movement. Accepting an item already held in quarantine is a status change, not another physical receipt. If the final two quarantined units later receive authorized acceptance, move two from quarantine to accepted without adding two to the received column. The on-site balance stays 100 while its status split changes to 100 accepted and zero quarantined.


If instead the final two are returned and two replacements arrive, record both movements and their references. Gross receipts then reach 114 and returns 14, still leaving 100 on site. Once those replacements are accepted, the usable requirement is met. Do not combine these alternative endings in one actual-history ledger: only record what occurred.


4. Make the register reproducible


Use an event identifier, item specification, order line, receipt or return reference, movement date, quantity, location and status. Link each replacement to the discrepancy it resolves. Record who authorized a disposition in the controlled project system; a free-text remark that says replacement is not itself a complete audit trail. Split rows when part of a shipment has a different inspection result.


At each cutoff, reconcile beginning stock plus receipts minus returns and issues to ending physical stock. Then reconcile that stock to mutually exclusive status balances. If installed issues exist, add them to the movement ledger rather than comparing current warehouse stock directly with the entire order quantity. The simplified example excludes issues so the arithmetic remains transparent.


5. Close the right question


The practical summary is 112 gross receipts, 12 returned, 100 physically on site, 98 accepted and 2 quarantined. That is more informative than a single 112% delivered flag. It tells the responsible team exactly which unresolved quantity needs disposition without implying that a payment, claim or order closure has been approved.


Keep supplier credits, invoices and replacement entitlement in their own commercial reconciliation with the appropriate authorized reviewer. A quantity balance cannot prove what is payable. Likewise, a claim being agreed does not make quarantined items suitable for installation. Clear boundaries let warehouse, procurement and estimating staff use the same history without giving the same number several incompatible meanings.



Continue the calculation review



Sources and calculation basis


Primary references checked on 27 October 2026. The worked examples and diagrams are original illustrative calculations, not manufacturer selections or project approvals. Apply the stated limitations and the requirements governing the actual project.



Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
bottom of page