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*22300001BEG*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*[email protected] 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*22300001BEG*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*[email protected] 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*40530002BCH*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*[email protected] POC*1*RZ**900*CA*28**IN*67890 PID*F****LIMES CTT*1 SE*24*40530002 |
ST*860*40530002BCH*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*[email protected] 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*103780003B2**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*103780003B2**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*6420001BPR*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*6420001BPR*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**1234500N1*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 OTI*TR*TN*864731*******810 |
ST*824*5300001 BGN*00*INV0000000014545131*20160902*101241**0001234500N1*FR*COSTCO WHOLESALE PER*IC*If questions contact Costco EDI Department accept OTI*TR*TN*54621*******810 TED*024*Product ID Qualifier/UPC does not match PO |
Contact Us
Got questions? Need EDI support or development? Facing a challenge or decision and want honest advice from experts? Looking for tailored training? You are in the right place. We take the time to understand what you need and give clear, helpful guidance to get you on the right track. Complete the form and we will be in touch soon to see how we can help. Let’s make EDI work for you!