How to Find Inventory Transfers Shipped but Not Fully Received
Warehouse A says it shipped 96 units. Warehouse B has booked 72. Some transfers in the report are still within their normal window. One is already older than its expected transit time and is holding up a scheduled replenishment.
Compare transfers by transfer line and shipment where available. Calculate the unreceived quantity, then use promised receipt, partial receipts, and destination status to prioritize follow-ups.
Two transfers with open quantities
The destination runs this report Thursday morning. Neither transfer has a cancellation or authorized write-off.
| Transfer / line | Shipped | Received | Unreceived | Status at review |
|---|---|---|---|---|
| TX-904 / 1 | 96 | 72 | 24 | Past promised receipt |
| TX-905 / 3 | 40 | 0 | 40 | Due Friday |
TX-904 needs a receiving review now. TX-905 remains on the in-transit list. The larger open quantity does not automatically get the first call.
Match shipping and receiving at the right grain
Export transfer order, shipment and receipt lines. Keep originating and destination warehouses, item, quantities, UOM, and shipment identifiers. If a transfer line had multiple dispatches and the receipts lack the dispatch ID, compare at transfer-line level and flag the ambiguity.
Look for partial receipts and reversals
Sum valid receipts as of the chosen cutoff and apply corrections consistently. Flag receipts higher than shipped, missing destination records, or unexpected unit conversions. Check physical receipt or proof of delivery where a closed transfer still shows a gap.
Send receiving a list with the evidence attached
Keep shipment and receipt reference cells next to each remaining quantity so the same report can be rerun tomorrow.
Which shipped transfer lines have units still unreceived past our expected receipt date? Show destination, outstanding units, age, partial receipt references and source rows.
Start with TX-904’s pallet or carton references. Keep TX-905 open as in transit until its promised window passes or receiving posts it.
NetSuite receiving fulfilled transfer orders
The figures and identifiers in this example are synthetic. The displayed arithmetic was checked independently. A live Jolene.pro result could not be verified.
Try this with your own spreadsheet at Jolene.pro. Follow Jolene.pro on LinkedIn for more spreadsheet guides.
For more checked examples, see Jolene.pro Workbook Studies.
1 comment