Industry Use Cases

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 / lineShippedReceivedUnreceivedStatus at review
TX-904 / 1967224Past promised receipt
TX-905 / 340040Due 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

Leave a comment