972-836-7750 Request a demo Talk to an expert
Talk to an expert Request a demo Call sales 972-836-7750

X12 transaction guide · Warehousing

EDI 947 Warehouse Inventory Adjustment Advice

The X12 document that reports a change in quantity or status to inventory held at a warehouse, such as damage, cycle count corrections or holds.

Sent by
Warehouse or 3PL (or the depositor)
Received by
Depositor (product owner) or the warehouse
Standard
ANSI ASC X12

What is an EDI 947?

The EDI 947 Warehouse Inventory Adjustment Advice is the ANSI X12 transaction set used to inform a warehouse, a depositor or another business party of a change in quantity or status to inventory records. It carries the detail of internal adjustments between a warehouse and the owner of the goods.

Typical adjustments include cycle count corrections, damage found in storage, product placed on or released from hold, and changes of lot or status. Without them, the owner's inventory records drift away from what the warehouse actually holds.

How the EDI 947 worksDiagram of the EDI 947 Warehouse Inventory Adjustment Advice. Warehouse or 3PL (or the depositor) sends it to depositor (product owner) or the warehouse. It usually starts the exchange. It is usually followed by 997. Inside the ISA, GS and ST envelopes, X12 release 008010 requires, in the heading: W15 (Warehouse Adjustment Identification) and the required 0100 loop with N1 (Party Identification) and detail: the required 0300 loop with W19 (Warehouse Adjustment Item Detail). 5 optional loops are listed by their first segment.How the EDI 947 worksWarehouse Inventory Adjustment Advice: who sends it, where it fits and what the standard marks required1 WHERE IT FITSUSUALLY FOLLOWSStarts the exchangeEDI 947SENDERWarehouse or 3PL (orthe depositor)RECEIVERDepositor (productowner) or thewarehouse997 or 999 acknowledgment back, if the partners agreeUSUALLY FOLLOWED BY997FunctionalAcknowledgment2 WHAT X12 RELEASE 008010 REQUIRESInterchange: sender and receiver IDsISA … IEAFunctional group, ID code AWGS … GETransaction set 947ST … SEHEADINGW15Warehouse Adjustment IdentificationRequired loop 0100 · repeats up to 100N1Party Identification+ 1 optional loop, starting with:LMDETAILRequired loop 0300 · repeats many timesW19Warehouse Adjustment Item Detail+ 4 optional loops, starting with:LMN1LXFA1Blue box: required loop. Optional loops are listed by the segment that starts them; when a loop is used, that first segment is required. Optional segmentsoutside loops are not drawn.Structure: required segments and loops in the X12 008010 listing for the 947. Your trading partner's implementation guide adds its own requirements.
How the EDI 947 worksDiagram of the EDI 947 Warehouse Inventory Adjustment Advice. Warehouse or 3PL (or the depositor) sends it to depositor (product owner) or the warehouse. It usually starts the exchange. It is usually followed by 997. Inside the ISA, GS and ST envelopes, X12 release 008010 requires, in the heading: W15 (Warehouse Adjustment Identification) and the required 0100 loop with N1 (Party Identification) and detail: the required 0300 loop with W19 (Warehouse Adjustment Item Detail). 5 optional loops are listed by their first segment.How the EDI 947 worksWarehouse Inventory Adjustment Advice: whosends it, where it fits and what the standardmarks required1 WHERE IT FITSUSUALLY FOLLOWSStarts the exchangeEDI 947SENDERWarehouse or3PL (or thedepositor)RECEIVERDepositor(product owner)or thewarehouse997 or 999 acknowledgment back, if the partnersagreeUSUALLY FOLLOWED BY997Functional Acknowledgment2 WHAT X12 RELEASE 008010 REQUIRESInterchange: sender and receiver IDs (ISA… IEA)Functional group, ID code AW (GS … GE)Transaction set 947 (ST … SE)HEADINGW15Warehouse AdjustmentIdentificationRequired loop 0100 · repeats upto 100N1Party Identification+ 1 optional loop, starting with:LMDETAILRequired loop 0300 · repeatsmany timesW19Warehouse AdjustmentItem Detail+ 4 optional loops, starting with:LMN1LXFA1Blue box: required loop. Optional loops are listedby the segment that starts them; when a loop isused, that first segment is required. Optionalsegments outside loops are not drawn.Structure: required segments and loops in the X12008010 listing for the 947. Your trading partner'simplementation guide adds its own requirements.

How to read this diagram: the top row shows who sends the 947, to whom, and which documents usually come before and after it. The lower part shows what X12 release 008010 itself requires: the envelopes around the 947 and the segments and loops the standard marks as required, area by area. Optional loops are listed by the segment that starts them rather than drawn in full. This is the standard's minimum, not a trading partner's requirement: each partner's implementation guide usually makes some optional loops mandatory, restricts the codes and may use a different release.

Expand diagram Download SVG

When it is used

  • Reporting cycle count gains and losses
  • Recording damage discovered in storage
  • Placing inventory on hold or releasing it

Where it fits in the document flow

This document 947 Warehouse Inventory Adjustment Advice
Usually followed by 997 Functional Acknowledgment

Structure

Mandatory segments in the 947 (X12 release 008010)

The segments X12 release 008010 marks as mandatory at their level, in order. Segments inside optional loops are needed only when the loop is used. This is the standard's requirement, not your trading partner's: each partner's implementation guide names the release it uses, adds the optional segments it requires and restricts the values. The requirement status comes from one published X12 reference listing and has not been checked against a second source.

  • ST
  • W15
  • N1
  • LM
  • LQ
  • W19
  • LX
  • FA1
  • FA2

Practical example

The 947 in practice

During a cycle count, a 3PL finds four fewer cases of one item than its records show, and two damaged cases of another. It sends the product owner a 947 with both adjustments and their reason codes. The owner's ERP updates inventory, and the finance team reviews the write-off.

Implementation

Implementation considerations for the 947

  • Agree reason codes for each type of adjustment so the owner can post them correctly.
  • Reconcile inventory regularly with an inventory status report, such as the 846, to catch missed adjustments.
  • Decide which adjustments need the owner's approval before they are made.

How ECOM helps

Automate the 947 with ECOM

Industry

3PL and Warehousing

Warehouse orders, shipping advice, receipts and inventory reporting between brands, 3PLs, carriers and retailers.

Industry

Manufacturing

Customer schedules, supplier connectivity and shipping integrated with the ERP for manufacturers.

Solution

EDI Integration

Exchange X12 and EDIFACT documents with partners and integrate them directly with your ERP.

More general questions about EDI are answered in the EDI FAQ.

Related transactions

Related warehousing documents

Need help with the EDI 947?

ECOM maps, tests and monitors X12 documents for your trading partners and integrates them with your ERP.

Request a Demo Contact us