Customer Specific EDI Instructions

ATMEL ALPS

  • ATMEL ALPS will most often come in on Tuesday, and the order will need to be written on Friday.
  • File all 830 Atmel into the Lear Atmel folder, and wait until Friday.
  • On Friday, find the Atmel 830, and pull in using “A, #14”

CHRYSLER TECVOX

  • Chrysler Documents will send every day; file all EDI into the Chrysler folder.
  • On Mondays you will sometimes have a Mopar shipment, and Tuesdays you will sometimes have a standard order. These will ALWAYS have an e-mail from Grant Hyche.
  • For every order you will need to find EDI that has the correct ship to.
  • Look through the raw to match the ship to.
  • Verify qty and part number for each order.
  • Pull in on EDI Menu “#31”
  • Verify order wrote correctly.
  • Occasionally you will receive an expedited order. Review these ASN’s with great attention to detail, using a good copy of a previous ASN.
  • When JIT 2 calls to let you know the orders have been cut, it is crucial that the ASN be sent within 30 minutes.

CONTINENTAL DENSO

  • Denso Documents will send every day; file EDI into the Denso folder.
  • On average you will have one weekly order for Denso sent by Don Ramhold. You will need to write it on Wednesday, and it will be shipped on Thursday.
  • The CUM’s MUST be checked and matched to Don Ramhold’s E-mail.
  • After CUM’s have been checked, pull in orders with “A, #33”
  • When JIT 2 calls to let you know the orders have been cut, it is crucial that the ASN be sent within 30 minutes.

CONTRL EDI

  • See ”RECADV, CONTRL, or ORDCHG Document” for instructions on these types of files.
DELPHI KANSAS (SIEMENS FRANCE)
  • DELJITs
  • When DELJITs come in, look through the ship to, and locate Siemens France DELJITs. They will always have 5 digit “ship to” (IE: 18008, 23005, 19052, etc…), as noted in the “Doc Num 2”. Highlight and send to “Siemens France” folder.
  • Go to “Siemens France” folder, and sort by date created. Highlight all new DELJITs, and (leaving highlighted) sort by “Doc Num 1” (which is the part number).
  • Deselect the newest EDI documents, and Select the older version, leaving ONE part number/ship to. Send old DELJITs to “Old Deljits” folder.
  • Now resort the entire folder by date created, and start printing PDF’s for e-mailing.
  • Highlight each EDI and print individually, saving each file by the word “DELJIT” then last four of their part number, and where duplications still exist, by the last 3 of their ship to.
  • IE: Deljit 5851, Deljit 1217-008, Deljit 1217-005, Deljit 0090, etc.
  • For more detailed instructions on printing PDF view Daily EDI Procedures.
  • For all other Deljits, send to the France Service Parts folder.
  • When E-mail order is submitted from Katrina, you should highlight only the part numbers with ship to’s specified in the e-mail.
  • Pull into Viaduct using Menu “A, 15” and verify that orders are correct.
  • If orders are incorrect, they will need to be deleted, and re-entered. They are NOT adjustable, and must therefore be edited in the raw data. These are CUM based orders, and may need adjusting.
DELPHI PACKARD VEGA (OSRAM OPTO)(RFM)(SIEMENS FRANCE DELFORS)
After doing and EDIFACT send/receive in your trusted link, locate any new Delphi Packard Vega DELFOR’s.
oMove DELFORS to Delfors folder.
  • DELFORS
  • Send all Delfors to the Delfors folder.
  • On Mondays, go to Delfor folder and look for DELPHI-PACKARD-VEGA Delfors. Right click and view the raw on each of them, looking for “Continental France” in the ship to.
  • Print each Delfor to PDF and save using the last four of the part number, and the last three of the “ship to”. (Note: This will be identical to the Deljits, but will have ONLY the part number and ship to.)
  • E-mail those PDF documents to Arnika. For more info on printing PDF’s, look at Daily EDI Procedures.

There are currently no orders that will use DELFOR’s

Locate remaining DELJITs and view Raw Data.
oSort the “OSRAM OPTO SEMICONDUCTORS” into the “Del. Pak. Veg. – Osram Opto” folder.
oSort the “RF MONOLITHICS” into the “Del. Pak. Veg. – RFM” folder
  • From the “Del Pak Veg. – Osram Opto” sort by date created, and highlight the documents you just placed in there.
  • Keeping those documents highlighted, sort now by “Doc Num 1”.
  • Those are the part numbers. Verify that there is only ONE part number per each ship to. (IE: you can have the same part twice so long as both parts aren’t for the same ship to: DA26, DA46, DA31…etc.) There will normally be 71 documents in this folder, unless they add a new part number.
  • Unselect the newest part number, and select the older ones.
  • After selecting all of the desired documents, right click and send file to “Old Deljits” folder. (Keep those files for about a week or so in case the new Deljits are bad.
  • The remnants of the folder should now be ALL newest EDI for every (part number/ship to) combination. Highlight the entire folder and Map EDI to Flat File.
  • Pull in using EDI menu #3, where first four digits are today’s first four digit date code (no slashes or dashes).
  • From the “Del Pak Veg – RFM” folder sort by date created, and highlight the documents you just placed there.
  • Keeping those documents highlighted, sort now by “Doc Num 1”.
  • Those are the part numbers. Verify that there is only ONE part number per each ship to. (IE: you can have the same part twice so long as both parts aren’t for the same ship to: DA26, DA46, DA31…etc.) There will normally be 19-21 documents in this folder, unless they add a new part number.
  • Unselect the newest part number, and select the older ones.
  • After selecting all of the desired documents, right click and send file to “Old Deljits” folder. (Keep those files for about a week or so in case the new Deljits are bad.
  • The remnants of the folder should now be ALL newest EDI for every (part number/ship to) combination. Highlight the entire folder and Map EDI to Flat File.
  • Pull in using EDI menu #3, where first four digits are today’s first four digit date code (no slashes or dashes).

FORD TECVOX

  • Ford Documents will send every day; file EDI into the Ford folder.
  • On Tuesdays, highlight the newest 862’s (for today’s date only. This is for both AP09, and AP20) and Map EDI to Flat File.
  • Pull in on EDI Menu “#24”
  • When JIT 2 calls to let you know the orders have been cut, it is crucial that the ASN be sent within 30 minutes.
HONDA 21072106 (CANADA)
  • Honda Canada EDI comes in and goes out through Honda Mailbox.
  • File all Honda 21072106 in the Honda 21072106 Canada folder.
  • Any EDI (NOT 224’s or 997’s) need to be E-mailed to Jerry Clark by PDF
  • 862 highlight any new order,(if there is more than one 862, contact Sheresa) and Map EDI to Flat File.
  • Pull in orders using EDI Menu “A,#9”. The 862’s EDI will pull in two business days ahead of time. If there are any issues contact Sheresa as well.
  • NO MANUAL ORDERS.Also: NEVER DELETE ORDERS. Orders that get deleted will lose the ability to pull in, as associated with the P.O. number.
  • Use “A” menu 10 for 850 orders. 850 orders should pull in on the date found in EDI.
  • Check 824 documents for valid ASN. (Invalid SCAC code errors will return an IE: Accepted with Errors. This is OK, as the order will switch trucks at the Canadian Border.)

HONDA HMA

Move all new HONDA HMA EDI to the HONDA HMA folder
  • Standard 862 orders
  • Match and verify all orders to Oscar’s email.
  • Verify that the quantities and dates match the P.O. numbers requested.
  • Orders pull in one day ahead, and pull in on “A, 25”
  • NO MANUAL ORDERS. NEVER DELETE ORDERS. The P.O. will need to match the specific number, and could sometimes be the reason for the orders not writing.
Check 824 documents for valid ASN, and notify IT of any discrepancies
HONDA MAP
  • Honda Map comes in for two “ship to’s” (Oscar and Gaby). Put all incoming Honda Map in the Honda Map file.
  • Standard 862 Orders
  • Honda Map for Oscar (differentiated by the ship to of 0813…)
  • Oscar will send an order via e-mail. Look through HONDA MAP EDI, and locate the part numbers he is requesting.
  • Highlight and Map EDI to FlatFile. In the MAPDATA folder pull up the DX-FX-VF document, and verify the order quantity with the P.O.
  • In the same document, verify that the date of the order is 1 business day ahead. (If Mon., then look for Tues.’s date, if Fri., look for Mon.)
  • Pull in orders using “A, #25”
  • Honda Map for Gaby (Differentiated with a ship to of ANEX…, and AMEI…)
  • Gaby will send an order request based on the EDI, but this will normally come after the order is needed.
  • Highlight the most recent 862’s with the ship to for Gaby, and Map EDI to Flat File.
  • Since you will not always have an order, you will need to look for quantities to match P.O. numbers.
  • Honda will use the shipment arrival date for the EDI, but only ship Mon, Tues and Wed. Usually look for:
  • Monday order => Tuesdays date
  • Tuesday order => Wednesdays date
  • Wednesday order => Following Mondays date
  • Verify EDI date is set to one business day ahead.
  • Pull in orders using “A, #25”
  • 850 orders
  • When new 850s come in, transfer into the HONDA MAP 850s folder.
  • Save 850 documents for 6 months. They will be recalled for order much later than standard orders.
  • When the email orders request a specific 850 order, locate the order by part number and qty in the Raw Data.
  • 850 orders will pull in on the date in the raw data. If you want it to write on tomorrows date, input tomorrows date.
  • Pull in orders using “A, #22”
  • 824’s
  • Check for “ASN is Valid”, and notify IT of any discrepancies.
  • NO MANUAL ORDERS. NEVER DELETE ORDERS. The P.O. will need to match the specific number, and could sometimes be the reason for the orders not writing.
INTEVA DAEYONG
  • Find all new Deljits and sent to the D Yong folder.
  • Watch for E-mail order from Katrina.
  • Using the Email, Highlight the desired DELJIT and Map EDI to Flat File.
  • Go to the Viaduct EDI Menu and do #37. Orders write one at a time.
  • Verify in Shipment Authorization screen.
LEAR AUTOLIV
  • This is unused EDI, and can be deleted.
LEAR ZANESVILLE ATMEL
  • Find, highlight, and move any new 830 Lear Zanesville in the IN folder to the Lear Atmel folder.
  • (If a new one is not received on Thursday e-mail Chris Brennan)
  • Highlight the new ones and Map EDI to Flat File.
  • Go to the Viaduct EDI Menu and do an “A, #11”.
  • Scroll up to check if order wrote, and email Chris Brennan if nor order writes.

MISCELLANEOUS PRINT PDF FILE INSTRUCTIONS

  • ALL PDF’s will need to be printed one at a time.
  • EVERY DAY
  • France Deljits Must be printed every day, and emailed to Katrina.
  • They will come in daily on the EDIFACT mailbox.
  • You will find instructions on which DELJITS to print and what to name them on “Delphi Kansas”
  • Honda Canada PDF will be printed when they come in.
  • Email to Jerry Clark when you receive EDI files.
  • More information can be found on Honda 21072106 instructions.
  • Weekly
  • (MONDAY) France DELFOR’s need to be emailed to Arnika.
  • They save exactly like Siemens France Deljits, but without any words.
  • Their Trading Partner name is Delphi Packard Vega, and they will be in the Delfor folder. ALL DELFORS should be in the Delfor folder.
  • France Service DELJITS (Ship to HU01, JM01, and 0001047000)
  • Save under “SERVICE PARTS” and “SERVICE PARTS HU01 #...”
  • There have never been more than four documents, but could possibly.
  • Email these documents to Arnika as well.
  • AVNET 830 need to be emailed to Julia Gebhart
  • There will be somewhere around 9 documents.
  • Print and save as “AVNET ####”
  • Melexis 830
  • There should only be one document.
  • Save as Melexis, and send email to the “Melexis Group” in your contacts list on outlook.
  • Atmel Delfors
  • Look in Delfor Folder, and locate any Delfors for Atmel, (by viewing the raw data.
  • Print and save as ATMEL DA26 or ATMEL DA31 documents, depending on which “ship to” in the raw data. Email to kjones.
  • F&H 862
  • These are Sanmina SCI documents, with the three different part numbers.
  • Email Gil Haden with the three documents.
  • If only one or two are received, email the documents anyways, and let Gil know that there was only the one or two.

MERCEDES-REC

  • Find, highlight, and move any new 830 MERCEDES - REC in the IN folder to the MERCEDES folder. (The new ones usually come in on Monday night or Tuesday morning.)
  • If there are not any new ones use the old ones already in the Mercedes folder.
  • There must NEVER be more than one set of EDI for Mercedes aside from the REC-3.
  • MERCEDES – REC 3 must always be on the top of the list before Flat Filing EDI.
  • Highlight and Map EDI to Flat File.
  • Go to the Viaduct EDI Menu and do #39.
  • Viaduct will always send an E-mail to Katrina, and Katrina will VERIFY W/ EMAIL FROM WENDY.
  • If corrections are needed, correct and resend using # 39
  • SAVE file to Merc.txt in your MAP DATA Folder on the C drive. Use this file to generate your next Mercedes Order, after Wendy confirms.
  • If Wendy requires further corrections, use the same document, and resend through EDI menu #39, repeating the saved file until Wendy approves.
  • If no corrections, pull in orders EDI Menu and do #38.

NISSAN (CKNA, CONTI, and CALSONIC)

  • 830 documents will come in EVERY morning. Highlight and move ALL Nissan documents to the Nissan file.
  • You will receive Email files from several different Nissan reps, all of which need a little bit of each from time to time.
  • For all Nissan orders you will need to do the following:
  • Look for and identify the EDI containing the RAN number requested from the e-mail order requests.
  • Highlight and Map EDI to flat file.
  • In Map Data, verify the following:
  • The date for pulling in orders will be in the following format:
  • Monday order => Pull Wednesdays date
  • Tuesday order => Pull Thursdays date
  • Wednesday order => Pull Fridays date
  • Thursday order => Pull Mondays date
  • Friday order => Pull Mondays date
  • Verify correct qty for your desired RAN
  • Verify no other RANs have active order writing date. (If more than one date for the same part number is active, the computer will write one large order, and combine the RANs.)
  • If the order doesn’t write after trying these things, verify that the beginning segment for the desired RAN number begins with a “07”, and not a “06”
  • CKNA and CONTI
  • These will both have RAN (authorization numbers) containing two letters and 5 digits. (e.g. CL12345, SC12345, CM12345)
  • These orders will pull into Viaduct using “A, #26”
  • CALSONIC
  • These orders will have a RAN number including 4 digits and a decimal. (e.g. 01.20, 2.40, 3.45)
  • Pull in these orders in Viaduct with “A, #28”
  • Verify by scrolling up that order qty, ran, and wrote order are accurate.

ORDCHG EDI

  • See ”RECADV, CONTRL, or ORDCHG Document” for instructions on these types of files.

OSRAM 217541

  • Highlight all new 862 Osram 217541 and send to the Osram 217541 folder.
  • Highlight new ones and Map EDI to Flat File.
  • Go to the Viaduct EDI Menu and do#5.
  • You will not always have new EDI for this vendor, and the EDI will not always write an order.

OSRAM-REC-856

  • 862’s
  • Highlight and move all OSRAM-REC-856 files to the Osram Gentex folder, they will normally come in early in the morning.
  • Highlight all new ones and Map EDI to Flat File. (Only when a new one is received, there will not ALWAYS be orders.)
  • If there are no new ones then ignore and do not process anything.
  • Go to the Viaduct EDI Menu and do an “A, #6”.
  • 856’s
  • This is unused EDI, and may be deleted.

PANASONIC (MONDAY 830)

Check the IN box for Panasonic 830’s. Highlight all Panasonic 830’s and move to the

Panasonic 830 folder.

Highlight the new 830’s in the Panasonic folder and Map EDI to FlatFile.

Go to the Viaduct EDI menu and do#28 (Pull over Panasonic 830).