ediverse

Type to search across standards, messages, tools and glossary.

ediverse Explore the platform

Spotlight PEPPOL BIS Billing 3.0 The EU e-invoicing mandate is here — France Sept 2026, Belgium Jan 2026, Germany 2025.

— 01

Foundations

— 02

Standards

— 03

Flagship messages

— 04

Tools

X12 867 — Product Transfer and Resale Report

The 867 documents product movement and resale activity at a distributor, so the manufacturer can drive commissions, distribution incentives, and CDA / SPA chargebacks across a multi-tier distribution chain.

Purpose

In a multi-tier distribution chain — manufacturer → distributor → reseller — the manufacturer often needs visibility on downstream sales from its direct distributor to compute contractual obligations. The 867 is the standard vehicle for that reporting. The distributor periodically sends its manufacturer a list of SKUs sold, by end customer or by zone, with quantities and amounts.

Three typical use cases: (1) Customer/Distributor Agreement (CDA) and Special Pricing Agreement (SPA) in high-tech — the manufacturer rebates the distributor for the difference between catalogue price and a price negotiated with an end customer; the 867 documents which units are eligible. (2) Commission or volume bonus programs. (3) Sell-through reporting for planning and replenishment steering.

Envelope structure

The 867 travels in a PT functional group (Product Transfer Report). A didactic 867 for May 2026, 350 units of one SKU sold:

x12 example-867.x12 
ISA*00*          *00*          *ZZ*ACMEDIST      *ZZ*ACMEVENDOR    *260601*1000*U*00401*000001101*0*P*>~
GS*PT*ACMEDIST*ACMEVENDOR*20260601*1000*1*X*004010~
ST*867*0001~
BPT*RS*RPT-2026-M05*20260601~
DTM*150*20260501~
DTM*151*20260531~
N1*MA*ACME VENDOR INC*92*VEND001~
N1*DI*ACME DISTRIBUTOR LLC*92*DIST-A~
LIN*1*UP*012345678905~
QTY*PL*350*EA~
AMT*PL*4196.50~
LIN*2*UP*012345678912~
QTY*PL*120*EA~
AMT*PL*2340.00~
CTT*2~
SE*12*0001~
GE*1*1~
IEA*1*000001101~

The BPT (Beginning Segment for Product Transfer Report) opens the transaction: report type code (RS = Resale Report, IS = Inventory Sales, PT = Transfer…), reference, issue date. The DTM 150/151 pair brackets the covered period. Each LIN is followed by QTY and AMT for sell-through quantities and revenue.

Common segments

  • Header — ST, BPT (Beginning Segment for Product Transfer Report), DTM (period), REF.
  • Parties — N1 loop for Manufacturer (MA), Distributor (DI), End Customer (EN), Ship From, Ship To.
  • Lines — LIN loop with PID, QTY (quantities per qualifier), AMT (amounts per qualifier), DTM (sale date), SLN (Subline), REF (link to CDA/SPA contracts).
  • Summary — CTT, SE.

When you'll see it

  • High-tech distribution — TD SYNNEX, Ingram Micro, Arrow ingest and emit 867s to drive their CDA/SPA programs with manufacturers (Cisco, HPE, Dell…).
  • Pharma / medical devices — chargeback distribution chains — McKesson, AmerisourceBergen, Cardinal.
  • Foodservice — Sysco, US Foods send 867 to their manufacturers for trade programs.
  • Automotive aftermarket — sell-out reporting to OEM parts suppliers.

Documentation

The code 867 and the name Product Transfer and Resale Report are public and listed on x12.org/products/transaction-sets. The exhaustive list of report-type codes, QTY and AMT qualifiers, and loop structures lives in the proprietary Implementation Guides (TR3); ediverse.io does not redistribute them.