X12 transaction guide · Planning
EDI 867 Product Transfer and Resale Report
The X12 document used to report product transferred between locations, or sold from locations to end customers, often by distributors to manufacturers.
- Sent by
- Distributor, reseller or buyer (sometimes the seller)
- Received by
- Manufacturer or supplier
- Standard
- ANSI ASC X12
- EDIFACT equivalent
- SLSRPT
What is an EDI 867?
The EDI 867 Product Transfer and Resale Report is the ANSI X12 transaction set used to report product movement. It can report product transferred from one location to another, sales of product from one or more locations to end customers, or those sales together with demand beyond actual sales, such as lost orders. Either the buyer or the seller can issue it.
Manufacturers use 867 data to see sell-through at their distributors, calculate rebates and chargebacks on contract sales, and plan production. Distributors often must send it to qualify for contract pricing.
How to read this diagram: the top row shows who sends the 867, 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 867 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.
When it is used
- Distributors reporting sales to end customers
- Supporting contract pricing rebates and chargebacks
- Reporting transfers between warehouse locations
- Sharing lost-order demand for planning
Where it fits in the document flow
Structure
Mandatory segments in the 867 (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
- BPT
- N1
- PER
- LM
- LQ
- PTD
- SII
- QTY
- LX
- FA1
- FA2
- CTT
- SE
Practical example
The 867 in practice
An electrical distributor buys wire at standard cost but sells it to a contractor at a manufacturer-approved contract price. At month end, it sends the manufacturer an 867 listing each contract sale, the end customer and the quantities. The manufacturer uses the report to validate the distributor's claim for the price difference.
Implementation
Implementation considerations for the 867
- Identify end customers and contracts consistently, because rebates depend on exact matches.
- Agree the reporting period and whether the report covers sales, transfers or both.
- Reconcile reported quantities with purchases from the manufacturer to catch gaps early.
Trading partners
Integration guides that include the 867
- 21st Amendment Brewery
- A-S Medication Solutions, LLC

- Abbott Laboratories


- Abita Brewing Company
- Acadia Pharmaceuticals
- Alaskan Brewing Co.
- Alembic Pharmaceuticals

- Allagash Brewing Company
- Almirall

- Alvogen


- Anda, Inc.
- Anheuser-Busch InBev
- ANI Pharmaceuticals

- Archer Daniels Midland
- Ardelyx

- AriZona Beverages
- Arrow Electronics

- Associated Pharmacies, Inc.
- Associated Wholesale Grocers
- Astellas Pharma

- Athletic Brewing Company
- August Schell Brewing Company
- Aurobindo Pharma
- Austin Beerworks
- Avnet
- B. Braun
- Bacardi


- Bavarian Nordic

- Bayer Pharmaceuticals



- Bell's Brewery

- BioCare, Inc.




- Bloodworth Wholesale Drugs
- BluPax Pharmaceuticals, LLC

- Bora Pharmaceuticals
- Boston Beer Company


- BrewDog
- Brewery Ommegang


- Brooklyn Brewery
- Brown-Forman
- BSH Home Appliances USA

- Burial Beer Co.
- Califia Farms
- Campari Group

- Capital Wholesale Drug Co.

- Carlisle Companies

- Celsius Holdings

- Chiesi Farmaceutici


- Chugai Pharmaceutical

- Cigar City Brewing
- Cipla
- Clint Pharmaceuticals, Inc.


- Colgate-Palmolive
- Collegium Pharmaceutical
- Community Beer Company

- Constellation Brands


- Coronado Brewing Company

- Creature Comforts Brewing Co.
- CSL
- D.G. Yuengling & Son
- D&H Distributing
- Daiichi Sankyo

- Deep Ellum Brewing Company
- Delicato Family Wines
- Deschutes Brewery
- Deutsch Family Wine & Spirits

- Diageo

- DMS Pharmaceutical Group, Inc.


- Dr. Reddy's Laboratories
- Drogueria Betances, LLC
- Duvel Moortgat USA
- Dynavax Technologies
- E. & J. Gallo Winery


- Eisai


- Eli Lilly and Company
- Emergent BioSolutions
- Endo

- Enovis


- Farmer Brothers
- Fat Head's Brewery
- Ferrero USA

- Fiddlehead Brewing Company
- FIFCO USA
- Firestone Walker Brewing Company
- Fisher Scientific

- Founders Brewing Co.
- Fresenius Kabi

- Full Sail Brewing Company
- Funky Buddha Brewery



- Georgetown Brewing Company

- Glenmark Pharmaceuticals

- Great Lakes Brewing Company




- Halozyme Therapeutics
- Health Coalition, LLC

- Heineken USA
- Helen of Troy


- Hercules

- Highland Brewing Company


- HyGen Pharmaceuticals, Inc.
- ICU Medical
- Illycaffè

- Independent Pharmacy Distributor

- Ingredion


- Intas Pharmaceuticals
- Integer Holdings






- Jackson Family Wines


- JDE Peet's
- Jester King Brewery

- Karbach Brewing Company
- Karl Strauss Brewing Company



- KeySource
- Kimberly-Clark
- Kona Brewing Company

- Krystal Biotech
- Kyowa Kirin
- L'Oreal USA

- Lakewood Brewing Company

- Land O'Lakes
- Lassonde Industries
- Lavazza Group
- Left Hand Brewing Company



- Lindt & Sprungli USA
- Lion (Kirin Group)
- Live Oak Brewing Company
- Louisiana Wholesale Drug Co. Inc.

- Lundbeck US
- Lupin
- Mahou San Miguel
- Maine Beer Company
- Mallinckrodt
- MannKind
- Mars


- Matt Brewing Company
- Maui Brewing Company
- Mayne Pharma
- McCain Foods USA

- Meanwhile Brewing Company

- Medline Industries

- Menarini Group


- Miele USA
- Milo's Tea Company
- Minhas Craft Brewery
- Mitsubishi Tanabe Pharma

- Molson Coors
- Monday Night Brewing

- Monster Beverage
- Montauk Brewing Company
- Morris & Dickson Co., L.L.C.

- Narragansett Brewing Company
- National Beverage Corp.
- NDC DISTRIBUTORS
- Nestle USA

- New Belgium Brewing
- New Glarus Brewing Company
- New Trail Brewing Company


- Niagara Bottling

- Novavax
- Novo Nordisk US
- Numed Pharma
- Oatly
- Ocean Spray Cranberries

- Odell Brewing Company
- Ono Pharmaceutical

- Otsuka Holdings

- Owens Corning
- Pabst Brewing Company
- Pacira BioSciences
- PBA Health



- Perdue Farms

- Pernod Ricard


- pFriem Family Brewers
- Pharming Group
- Pharmsource, LLC


- Pierre Fabre
- Pittsburgh Brewing Company
- Post Holdings

- Prescription Supply, Inc.
- Primo Brands

- PRx Wholesale, LLC
- PTC Therapeutics

- R&S Northeast LLC
- Rahr & Sons Brewing Company
- Real Ale Brewing Company
- Real Value Rx

- Recordati
- Recordati Rare Diseases US
- Red Bull
- Refresco
- Regeneron Pharmaceuticals
- Republic Pharmaceuticals

- Revolution Brewing
- Revolver Brewing
- Reynolds Consumer Products
- Rhinegeist Brewery


- Richie Pharmacal Co., LLC
- Roche / Genentech


- Russian River Brewing Company
- Saint Arnold Brewing Company
- Saint-Gobain North America


- Sanofi US

- Sarepta Therapeutics

- Sazerac Company



- Servier
- Shionogi
- Siemens Healthineers US
- Sierra Nevada Brewing Co.
- Sobi

- South Pointe Wholesale, Inc.
- Southern States
- Spectrum Brands
- Stevens Point Brewery
- Stone Brewing

- Sumitomo Pharma
- Summit Brewing Company
- Sun Pharmaceutical Industries
- Suntory Global Spirits

- Surly Brewing Company
- SweetWater Brewing Company
- Takeda
- Talking Rain Beverage Company
- Tampa Bay Brewing Company

- Teleflex
- Teva Pharmaceutical Industries
- TG Therapeutics
- The Gambrinus Company
- The Wine Group
- The Wonderful Company
- Three Floyds Brewing
- Tilray Beer Brands
- Tivoli Brewing Company
- TopRx & Auburn Pharmaceutical, LLC
- Torrent Pharmaceuticals

- Travere Therapeutics
- Treasury Wine Estates
- Trinchero Family Estates
- Tröegs Independent Brewing
- Tropicana Brands Group


- UCB US

- United Therapeutics
- Upsher-Smith Laboratories
- Value Drug Company


- Vita Coco

- Welch's
- Westrock Coffee

- Wicked Weed Brewing




- Zydus Lifesciences
How ECOM helps
Automate the 867 with ECOM
Industry
Wholesale Distribution
Customer orders, supplier purchasing, catalogs and drop-ship for distributors.
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 planning documents
From the guide to go-live
Put this into practice with ECOM
Reading about EDI is the first step. When you are ready to meet a trading partner's requirements, an ECOM specialist can help.
-
EDI compliance help
Check documents against the partner's rules before they are sent, and find out why labels, ship notices or invoices are rejected or short-paid for EDI 867.
-
EDI implementation
Map, test and certify the documents for EDI 867, and connect them to your ERP, warehouse or order system.
-
Managed EDI
Have ECOM run the day-to-day EDI: monitoring, error handling and new trading partner setup.
Need help with the EDI 867?
ECOM maps, tests and monitors X12 documents for your trading partners and integrates them with your ERP.