EDI ASN Integration

[Sashi K1]

Hi techno experts,

we have a requirement to Integrate EDI ASN data across ServiceNow and a third party application ePlus. This is about procuring an Asset when order is placed. We wanted to track down order, processing, shipment of an Asset completely automated. Here typical steps.

Here is a typical EDI transaction using Integration:

1. A Retail trading partner places an order with customer. They issue an EDI 850 Purchase Order (PO), and that order is then sent electronically to the EDI provider.
2. The EDI provider translates the document using their maps and sends to the customer.
3. The purchase order is picked up electronically by the customer and brought into ServiceNow using one of the methods provided by EDI providers (ePlus) . That PO is brought into ServiceNow and processed. A Sales Order or Invoice is issued and the product is shipped to the retail trading partner.
4. An EDI 856 Advance Shipping Notice is then sent to the trading partner by way of the EDI provider to inform them of the shipping information.
5. An EDI 810 is sent to the trading partner (again by way of the EDI provider) for payment.

I have reviewed EDI data format, and it looks like below. That formats makes me to go with Email Integration to get it translated to ServiceNow or a SFTP; thats what I could think off for now. Not sure, if EDI has a WebServices Integration. Yet to figure it out. Anyone implemented in the past, if yes share best practices

EDI 856 Format:

ISA*01*0000000000*01*ABCCO         *12*4405197800         *01*999999999           *111206*1719*-*00406*000000049*0*P*>
GS*SH*4405197800*999999999*20111206*1045*49*X*004060
ST*856*0008
BSN*14*829716*20111206*142428*0002
HL*1**S
TD1*PCS*2****A3*60.310*LB
TD5**2*XXXX**XXXX
REF*BM*999999-001
REF*CN*5787970539
DTM*011*20111206
N1*SH*1 EDI SOURCE
N3*31875 SOLON RD
N4*SOLON*OH*44139
N1*OB*XYZ RETAIL
N3*P O BOX 9999999
N4*ATLANTA*GA*31139-0020**SN*9999
N1*SF*1 EDI SOURCE
N3*31875 SOLON ROAD
N4*SOLON*OH*44139
HL*2*1*O
PRF*99999817***20111205
HL*3*2*I
LIN*1*VP*87787D*UP*999999310145
SN1*1*24*EA
PO4*1*24*EA
PID*F****BLUE WIDGET
HL*4*2*I

[Gaurav Kumar15]

HI Ajay,

Did you implemented this till now.

Actually we also want to integrate Service Now via EDI, so just wanted to know. whether its feasible or not.

TIA,

Gaurav Kumar

[sivaranjaniduvv]

Hi Ajay

Were you able to get the EDI data to servicenow?

Thanks

[Sashi K1]

Hi

For a quick integration we use Email inbound mechanism to integrate with EDI. That worked.

There is a plenty of chances for both the systems to exchange data using web services. Which would be our phase next plan.

[harshg4371]

How did you achieve the same ? The E-mail Integration method, I just want to read the EDI file somehow and store it in my logs.