The 3PL's notification of any inventory change that doesn't result from a standard shipment or receipt - cycle count variances, damage write-offs, expired goods, location transfers, and quality holds that affect the depositor's on-hand position.
The EDI 947 Warehouse Inventory Adjustment Advice is the catch-all document for communicating any change to inventory that isn't covered by a standard 943 receipt or 945 shipment confirmation. Warehouses make inventory adjustments constantly - cycle count results reveal variances, damage inspections result in write-offs, goods exceed expiration dates and must be destroyed, items are moved between locations or quality hold statuses change. Without a 947, the depositor's inventory records silently diverge from what the 3PL actually has.
A 947 specifies the SKU, the adjustment quantity (positive or negative), the reason code for the adjustment, and optionally the lot number, location, and status (pickable, quarantine, damaged, hold). The reason code is critical - it determines whether the depositor should file a claim with the 3PL (damage or loss), investigate a supplier quality issue (lot failure), update their own book inventory (cycle count correction), or simply acknowledge a legitimate business event (expired goods destruction).
Inventory accuracy between the 3PL's WMS and the depositor's ERP directly impacts order fulfillment rates, reorder triggers, and financial reporting. Many depositors perform periodic inventory reconciliation by comparing their expected on-hand (running sum of 943s, 945s, and 947s) against the 3PL's reported on-hand. The 947 is the document that ensures those reconciliations are clean - and that neither party is surprised when a physical inventory count is conducted.
3PLs generate 947s from their WMS adjustment workflow. Most WMS platforms have configurable adjustment reason codes that map to 947 reason code fields. Professional 3PLs transmit 947s same-day for damage events and within 24–48 hours for cycle count adjustments. Contractual SLAs increasingly specify 947 transmission timing - late adjustment communication is a leading cause of depositor inventory disputes and churn.
DTC brands rely on accurate 3PL inventory to avoid overselling. A 947 reporting a negative adjustment immediately reduces available inventory in the OMS, preventing orders from being accepted for items that no longer exist at the warehouse. Brands that don't receive timely 947s frequently discover inventory discrepancies only when customers complain about unfulfilled orders - a much worse outcome.
Retailers with 3PL-operated fulfillment use 947s to maintain accurate distributed inventory positions across their network. Damaged goods adjustments feed into loss reporting and shrinkage KPIs. Cycle count variances trigger investigation workflows - is it a WMS process error, a receiving discrepancy, or actual shrinkage? The 947 data feeds directly into inventory accuracy dashboards that are reviewed in weekly operations reviews.
CPG companies with lot-controlled, date-sensitive products depend on 947s for expiration management. When lots reach their sell-by or use-by thresholds, the 3PL writes them off and sends a 947 with an expiration reason code. This triggers the depositor to investigate: Was the lot shipped before expiry? Does the supplier need to be notified? Are there food safety or recall implications? The 947 is the legal record that the inventory was removed from distribution.
Opens the 947 body. W1401 = adjustment reporting code (D = original, C = cancel), W1402 = date of adjustment (CCYYMMDD), W1403 = depositor order number or reference number assigned by the depositor, W1404 = warehouse reference number (the 3PL's internal adjustment ID for audit trail purposes). The warehouse reference number in W1404 is the key for any follow-up inquiry - when a depositor disputes an adjustment, the 3PL looks up the W1404 reference in their WMS audit log.
Identifies the depositor (DE) and the 3PL warehouse (WH) where the adjustment occurred. For multi-facility 3PLs, the N1/WH identification specifies which facility the adjustment is for - important when a depositor has inventory spread across multiple 3PL locations and needs to track adjustments per site. The depositor's account number at the 3PL often appears in N104.
The core adjustment detail segment: W1901 = quantity adjusted (positive = inventory added, negative = inventory removed), W1902 = unit of measure, W1903 = weight (if weight-based adjustment), W1906 = UPC/GTIN or item identifier, W1907 = product/service ID qualifier, W1908 = item description. The sign of W1901 determines direction - most damage and expiry adjustments are negative. Multiple W19 loops, one per SKU being adjusted.
Provides the reason code for the adjustment: W1201 = warehouse adjustment reason code. Common codes: CC = cycle count, DA = damaged, EX = expired/outdated, LS = lost/shrinkage, QH = quality hold placed, QR = quality hold released, TR = location transfer (internal move, no net change). The reason code drives the depositor's downstream response - claims, write-offs, quality investigations, or simple acknowledgment.
Documents when the adjustment event occurred vs. when it was discovered and processed in the WMS. For cycle counts, G62 captures both the physical count date (194 = inventory date) and the adjustment posting date. This two-date approach is important for financial reporting - inventory write-offs are recognized on the date of discovery, not the date the WMS was updated. Also used to record expiration dates for expired-goods write-offs.
Cross-references to related documents: lot number (LT), serial number (SE), and any related receipt or shipment document. For lot-controlled adjustments, N9 with qualifier LT carries the specific lot number being adjusted - essential when a depositor needs to investigate whether the lot being written off was from a specific supplier batch or inbound shipment. The lot reference enables traceability from the 947 back to the original 943 receipt.
Many 947 adjustments are triggered by discrepancies discovered after a 944 receipt is posted. If a count recheck finds the 944 quantity was incorrect, or if damage is discovered after goods are moved from the receiving dock to storage, a follow-up 947 corrects the inventory position that was initially set by the 944.
Inventory adjustments may occur in relation to outbound shipments - items damaged during packing, pick errors discovered after shipping confirmation, or quantity adjustments after a carrier recount. A 947 may follow a 945 to correct the inventory record when the physical goods don't align with what was reported as shipped.
Inventory availability for fulfilling 940 Shipping Orders depends on accurate on-hand data. When a 947 reports a negative adjustment for a SKU, the depositor's OMS must recalculate available-to-promise inventory and may need to place newly submitted 940 orders for that SKU on hold pending restock.
Better EDI automates 947 inventory adjustment processing - syncing 3PL WMS adjustments to your ERP or OMS in real time, with alerting for damage, shrinkage, and lot expiry events.
Talk to an EDI Expert