EDI 867 Product Transfer and Resale Report File Format

The EDI 867 transaction set represents a Product Transfer and Resale Report. It is used to provide information on a product that has been transferred to a new location within a company, or to report sales of a product from multiple locations to an end customer (i.e., point-of-sale, or POS, data). It may also be used to communicate returns from customers to distribution center or retail locations. Each 867 document includes the following information:
  • Organization identification information
  • Product transfer and resale detail, including quantity, purchase order, type codes and contract identifiers
  • Transaction totals in terms of line items, their weights and other units of measure
The 867 transaction set is used in a variety of industries. It is perhaps most commonly used by retailers to communicate to their vendors on the sales of their products at individual store locations. But it can be used by manufacturers and virtually every type of reseller, including wholesalers, distributors, retailers and the like. For example, wholesalers may use the 867 to communicate to a manufacturer about the movements of their product to other wholesale locations, or to other downstream channel partners, and to detail returns from these locations to the wholesaler. The 867 is also used by utilities to communicate meter information – that is, information on usage of electricity, natural gas, etc. In addition, the 867 may be used by these utilities to transmit allowance transfer information to the US Environmental Protection Agency. The 867 is similar to the 852 transaction set, which is used by resellers to provide information on product inventory and sales levels to the manufacturers of those products. If you are a manufacturer who needs to meet your resellers’ requirements for EDI, 1 EDI Source can help. We can get you in compliance quickly, with EDI WebSource™, our premium web-based EDI portal. You get full EDI capabilities, in a simple-to-use and affordable solution. Contact 1 EDI Source today for a one-on-one demo with a trained EDI WebSource™ consultant.

EDI 867 Format

ISA*01*0000000000*01*0000000000*ZZ*ABCDEFGHIJKLMNO*ZZ*123456789012345*101127*1719*U*00400*000003438*0*P*>
GS*PT*4405197800*999999999*20110127*1719*1421*X*005010VICS
ST*867*0001
BPT*22*ABC123*20120128*01
CUR*SE*USD
DTM*193*20120130
N1*SE*XYZ SUPPLIER*9*1234567890001
N1*DS*ABC DISTRIBUTION*9*9876543210001
PTD*IB***TF*TRANSFER 123
N1*TT*ABC DISTRIBUTION BRANCH 2*9*9876543210002
QTY*78*100*EA
LIN*0001*VC*P-8750*BP*12345
UIT*EA*5*PE
AMT*1*500
DTM*514*20120130
CTT*1*100
SE*16*0001
GE*1*1421
IEA*1*000006638

EDI 867 Specification

This X12 Transaction Set contains the format and establishes the data contents of the Product Transfer and Resale Report Transaction Set (867) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to: (1) report information about product that has been transferred from one location to another; (2) report sales of product from one or more locations to an end customer; or (3) report sales of a product from one or more locations to an end customer, and demand beyond actual sales (lost orders). Report may be issued by either buyer or seller.

Sources

Accredited Standards Committee X12. ASC X12 Standard [Table Data]. Data Interchange Standards Association, Inc., Falls Church, VA. http://www.x12.org

Keep a list of all X12 EDI transaction sets at hand.

Download a free EDI Transaction Set Guide today.