info@dcsedi.com 952-941-5466

Costco Wholesale Implements New EDI Requirements Effective October 17, 2016

Effective October 17, 2016, Costco Wholesale will have new EDI requirements processes.  Costco has recently implemented an ERP software solution provided by SAP.  If you are an EDI partner with Costco this will impact you as their EDI requirements will change to accommodate the SAP model.  Please see the information below for more details regarding the new requirements that must be followed.

 Costco’s new requirements:

  • Costco’s vendor number field has increased from 7 to 10 digits.  Costco transmits the A/P vendor number on 850/860 Purchase Order/Change, 204 Motor Carrier Load Tender, 820 Remittance Advice (if applicable), and 824 Application Advice.

What Costco will require from you:

The information in bold below is what will be changing on the 850/860 Purchase Order/Change, 204 Motor Carrier Load Tender, 820 Remittance Advice (if applicable), and 824 Application Advice.  It is recommended that you follow EDI ANSI X12 Standards and increase the field to allow from 1 to 30 characters.

Your DCS EDI Specialist can assist you to make sure that you are compliant with Costco moving forward.   E-mail or call (952-941-5466) us today to ensure that you are in compliance.

EXAMPLE OLD 850 PURCHASE ORDER                                    EXAMPLE NEW 850 PURCHASE ORDER

ST*850*22300001

BEG*00*SA*009600915341**20160828

REF*VR*3456700                  

REF*DP*13*COSTCO DEPARTMENT

REF*19*SD*COSTCO REGION

REF*ZZ*33112*BUYER VENDOR NUMBER

REF*ZZ*01*BUYER VENDOR SUFFIX

REF*YD*SD652*CREATED BY

FOB*PP*ZZ*COSTCO

ITD*01*2*****15*****ROG 15

DTM*175*20161013

DTM*002*20161013

DTM*010*20161013

TD5*****VENDOR

N9*H5*LEGAL DISCLAIMER

MSG*This order incorporates the Costco Wholesale Standard Terms,

MSG*as they may be amended from time to time, and any applicable

MSG*signed agreements between us.

N1*ST*COSTCO MIRA LOMA DEPOT*9*1033918430960

N3*11600 RIVERSIDE DR

N4*MIRA LOMA*CA*91752

PER*RE**EM*D960APT@COSTCO.COM

PO1*1*180*CA*48.96**IN*12345

PID*F****COSTCO BROWNIE BITES

SAC*A*ZZZZ***26438*******02***DFI% – 3.00

SAC*A*ZZZZ***31500*******03***REBATE $ – 1.75

SAC*C*ZZZZ***18000*******06***ITEM MISC $ – 1.00

PO1*2*180*CA*48.96**IN*67890

PID*F****COSTCO SNICKERDOODLES

SAC*A*ZZZZ***26438*******02***DFI% – 3.00

SAC*A*ZZZZ***31500*******03***REBATE $ – 1.75

SAC*C*ZZZZ***18000*******06***ITEM MISC $ – 1.00

CTT*2*360

SE*34*22300001

ST*850*22300001

BEG*00*SA*009600915341**20160828

REF*VR*0003456700                  

REF*DP*13*COSTCO DEPARTMENT

REF*19*SD*COSTCO REGION

REF*ZZ*33112*BUYER VENDOR NUMBER

REF*ZZ*01*BUYER VENDOR SUFFIX

REF*YD*SD652*CREATED BY

FOB*PP*ZZ*COSTCO

ITD*01*2*****15*****ROG 15

DTM*175*20161013

DTM*002*20161013

DTM*010*20161013

TD5*****VENDOR

N9*H5*LEGAL DISCLAIMER

MSG*This order incorporates the Costco Wholesale Standard Terms,

MSG*as they may be amended from time to time, and any applicable

MSG*signed agreements between us.

N1*ST*COSTCO MIRA LOMA DEPOT*9*1033918430960

N3*11600 RIVERSIDE DR

N4*MIRA LOMA*CA*91752

PER*RE**EM*D960APT@COSTCO.COM

PO1*1*180*CA*48.96**IN*12345

PID*F****COSTCO BROWNIE BITES

SAC*A*ZZZZ***26438*******02***DFI% – 3.00

SAC*A*ZZZZ***31500*******03***REBATE $ – 1.75

SAC*C*ZZZZ***18000*******06***ITEM MISC $ – 1.00

PO1*2*180*CA*48.96**IN*67890

PID*F****COSTCO SNICKERDOODLES

SAC*A*ZZZZ***26438*******02***DFI% – 3.00

SAC*A*ZZZZ***31500*******03***REBATE $ – 1.75

SAC*C*ZZZZ***18000*******06***ITEM MISC $ – 1.00

CTT*2*360

SE*34*22300001

 

 

EXAMPLE OLD 860 PURCHASE ORDER CHANGE                   EXAMPLE NEW 860 PURCHASE ORDER CHANGE

ST*860*40530002

BCH*04*CP*001720829323***20160829

REF*VR*1234500                   

REF*YD*NW944*CREATED BY

FOB*PP*ZZ*COSTCO WHOLESALE

ITD*01*2*****30*****ROG 30

DTM*175*20160909

DTM*002*20160909

DTM*010*20160909

TD5*****TRAFFIC

N9*H7*SPECIAL INSTRUCTIONS

MSG*VENDOR ADD 900/495 TC 9/2

N9*H5*LEGAL DISCLAIMER

MSG*This order incorporates the Costco Wholesale Standard Terms,

MSG*as they may be amended from time to time, and any applicable

MSG*signed agreements between us.

N1*ST*COSTCO TRACY WET*9*1033918430172

N3*25862 S. SCHULTE CT

N4*TRACY*CA*95377

PER*RE**EM*D172APT@COSTCO.COM

POC*1*RZ**900*CA*28**IN*67890

PID*F****LIMES

CTT*1

SE*24*40530002

ST*860*40530002

BCH*04*CP*001720829323***20160829

REF*VR*0001234500                   

REF*YD*NW944*CREATED BY

FOB*PP*ZZ*COSTCO WHOLESALE

ITD*01*2*****30*****ROG 30

DTM*175*20160909

DTM*002*20160909

DTM*010*20160909

TD5*****TRAFFIC

N9*H7*SPECIAL INSTRUCTIONS

MSG*VENDOR ADD 900/495 TC 9/2

N9*H5*LEGAL DISCLAIMER

MSG*This order incorporates the Costco Wholesale Standard Terms,

MSG*as they may be amended from time to time, and any applicable

MSG*signed agreements between us.

N1*ST*COSTCO TRACY WET*9*1033918430172

N3*25862 S. SCHULTE CT

N4*TRACY*CA*95377

PER*RE**EM*D172APT@COSTCO.COM

POC*1*RZ**900*CA*28**IN*67890

PID*F****LIMES

CTT*1

SE*24*40530002

 

EXAMPLE OLD 204 LOAD TENDER                                            EXAMPLE NEW 204 LOAD TENDER

ST*204*103780003

B2**COCO**073761363013125*L*CC

B2A*00

L11*1234500*VR

G62*76*20160902

NTE*GEN*SHIP DATE REVISED TO 09/09 DD 09/02

N1*BT*COSTCO WHOLESALE*9*1033918430000

N3*ATTN FREIGHT DEPT*PO BOX 34715 N4*SEATTLE*WA*98125

N7**0*30600*G*******RT****5300

S5*1*CL*30600*L***5*E

G62*69*20160903

AT8*G*L*16000*350

N1*SH*EYRE FIELDS*ZZ*9876500

N3*CONFIRM WITH VENDOR

N4*HOLT*NJ*08028

G61*SH*RECEIVING CLERK*TE*411-902-1000

OID**001100503253**LR*720

L5**THORNFIELD GRAPES*10647*Z

AT8*G*L*30600*1700

L3*30600*G

SE*40*410220008

 

ST*204*103780003

B2**COCO**073761363013125*L*CC

B2A*00

L11*0001234500*VR

G62*76*20160902

NTE*GEN*SHIP DATE REVISED TO 09/09 DD 09/02

N1*BT*COSTCO WHOLESALE*9*1033918430000

N3*ATTN FREIGHT DEPT*PO BOX 34715

N4*SEATTLE*WA*98125

N7**0*30600*G*******RT****5300

S5*1*CL*30600*L***5*E

G62*69*20160903

AT8*G*L*16000*350

N1*SH*EYRE FIELDS*ZZ*0009876500

N3*CONFIRM WITH VENDOR

N4*HOLT*NJ*08028

G61*SH*RECEIVING CLERK*TE*411-902-1000

OID**001100503253**LR*720

L5**THORNFIELD GRAPES*10647*Z

AT8*G*L*30600*1700

L3*30600*G

SE*40*410220008

 

 

EXAMPLE OLD 820 REMITTANCE ADVICE                                EXAMPLE OLD 820 REMITTANCE ADVICE

ST*820*6420001

BPR*I*13039.96*C*CHK

CUR*2L*USD

REF*VR*9876500                               

REF*CK*12222234

DTM*097*20160902

N1*PR*COSTCO WHOLESALE*9*1033918430000

N1*PE*WAYNE ENTERPRISES

N3*#258 ARKHAM RD W

N4*GOTHAM*NY*89102

ENT*1*ZZ*1*1033918430000

RMR*IV*11274**60456.43*61693.38*1236.95

REF*PO*001110102345

DTM*003*20160831

RMR*IV*22385**2184.36*2205*20.64

DTM*003*20160831

RMR*IV*33496**2182.96*2205*22.04

DTM*003*20160831

RMR*RZ*89210**-64.8*-64.8

DTM*003*20160831

RMR*RZ*5813321654**-12*-12

DTM*003*20160901

RMR*IV*1066433**12*12

DTM*003*20160901

SE*25*6420001

ST*820*6420001

BPR*I*13039.96*C*CHK

CUR*2L*USD

REF*VR*0009876500                               

REF*CK*12222234

DTM*097*20160902

N1*PR*COSTCO WHOLESALE*9*1033918430000

N1*PE*WAYNE ENTERPRISES

N3*#258 ARKHAM RD W

N4*GOTHAM*NY*89102

ENT*1*ZZ*1*1033918430000

RMR*IV*11274**60456.43*61693.38*1236.95

REF*PO*001110102345

DTM*003*20160831

RMR*IV*22385**2184.36*2205*20.64

DTM*003*20160831

RMR*IV*33496**2182.96*2205*22.04

DTM*003*20160831

RMR*RZ*89210**-64.8*-64.8

DTM*003*20160831

RMR*RZ*5813321654**-12*-12

DTM*003*20160901

RMR*IV*1066433**12*12

DTM*003*20160901

SE*25*6420001

 

 

 EXAMPLE OLD 824 APPLICATION ADVICE                                EXAMPLE NEW 824 APPLICATION ADVICE

ST*824*5300001
BGN*00*INV0000000014545131*20160902*101241**1234500

N1*FR*COSTCO WHOLESALE
PER*IC*If questions contact Costco EDI Department
N1*TO***PRETEND PRODUCTS**
PER*IC*Please correct invoice. Send via EDI. Paper inv not accept

OTI*TR*TN*54621*******810
TED*024*Product ID Qualifier/UPC does not match PO

OTI*TR*TN*864731*******810
TED*024*Product ID Qualifier/UPC does not match PO SE*11*5300001ST*820*6420001

 

ST*824*5300001
BGN*00*INV0000000014545131*20160902*101241**0001234500

N1*FR*COSTCO WHOLESALE

PER*IC*If questions contact Costco EDI Department
N1*TO***PRETEND PRODUCTS**
PER*IC*Please correct invoice. Send via EDI. Paper inv not

accept

OTI*TR*TN*54621*******810
TED*024*Product ID Qualifier/UPC does not match PO
OTI*TR*TN*864731*******810

TED*024*Product ID Qualifier/UPC does not match PO
SE*11*5300001