ZEN CONSULTING : EDI

Mostrando entradas con la etiqueta EDI. Mostrar todas las entradas

viernes, 29 de julio de 2016

STERLING INTEGRATOR B2B, EDI,

martes, 22 de marzo de 2016

FREE ECOOMERCE BOOK HERE/ EBOOK DE ECOMMERCE GRATIS

FREE EBOOK ON FUNDAMENTALS OF Electronic Commerce

EBOOK GRATIS, FUNDAMENTOS DEL COMERCIO ELECTRONICO

También baja el ebook gratuito de programación PHP y wordpress

The ebook includes the fundaments of electronic commerce, the tools used by Amazon, Staples, Walmart.

Do you want to improve your income?

Do you want to create your own Online store?

Los Fundamentos del comercio electrónico, las herramientas que usan Amazon, IBM, Staples y más"!!

Then this ebook is for you!!!

Quieres mejorar tus ingresos desde casa?

Quieres poner una tienda virtual usando Paypal, de manera rapida y gratis!!!

Entonces este ebook es para ti!!!

viernes, 26 de diciembre de 2014

Gentran SERVER EDI Implementation

EDI gentran server permiten generar una implementación B2B, QUE SIRVE PARA GENERAR TRANSACCIONES TIPO EDI PARA FACTURAS (INVOICES) ORDENES DE COMPRA (PURCHASE ORDERS) ETC.
LAS BONDADES ES EL PRECIO Y LA FACILIDAD DE INSTALACION A COMPARACION DEL INTEGRADOR B2B STERLING.

LA SIGUIENTE ES UNA LISTA INICIAL DE LA IMPLEMENTACION. ASI COMO LOS DIAGRAMAS DE ARQUITECTURA Y ALGUNAS IMAGENES DE LA IMPLEMENTACION QUE GENERAMOS PARA KIO Y KCM.

Checklist

Tienen que ser dos ip’s
IP 1
The IP address and system name (host name) of the host computer that will
contain the EDI environment.

Ip 2
The IP address and system name of the host computer that will contain the
Security Administration utility. (This will be the NAMEBROKER). (puede quedar en el mismo host)

The name of the CD-ROM drive you will use to load software onto the UNIX
host:

The complete path to the locations where you will install:
◗ The Sterling Gentran:Server UNIX Security Administration utility:
◗ The Sterling Gentran:Server UNIX host software:
◗ The Sterling Gentran:Server Windows client software

The following takes a CVS 850 inbound purchase order step by step into baan.

I have tried to show what determines action for each step. Hopefully, you will get a better understanding how everything comes together.

Actual PO(850) data from CVS.

ISA*00* *00* *ZZ*CVS *01*055826309 *121001*113

9*U*00400*000003429*0*P*^

GS*PO*CVS*055826309*20121001*1139*1378*X*004010

ST*850*2216

BEG*00*SA*0076423**20121001

REF*VR*12925

PER*BD*MICHELLE MARTINEAU

SAC*A*F050*ZZ*ZZ**1*1*****02***OTHER

ITD*01*15*2**30**31***100

DTM*002*20121022

AMT*BAP*2986

N9*L1*PO COMMENTS

MSG*THIS PO SUBJECT TO THE TERMS AND CONDITIONS FOUND ON CVS SUPPLIERS WEBSITE

N1*ST**54*Y101

N3*ONE CVS DRIVE

N4*WAVERLY*NY*14892

PO1**17*CA*175.62**UI*03288417688*UA*003288416790*PI*855752

PAM*01*2986*ZZ

PO4*6

CTT*1*17

SE*18*2216

ST*850*2217

BEG*00*SA*1265472**20121001

REF*VR*12925

PER*BD*MICHELLE MARTINEAU

SAC*A*F050*ZZ*ZZ**1*1*****02***OTHER

ITD*01*15*2**30**31***100

DTM*002*20121022

AMT*BAP*2459

N9*L1*PO COMMENTS

MSG*THIS PO SUBJECT TO THE TERMS AND CONDITIONS FOUND ON CVS SUPPLIERS WEBSITE

N1*ST**54*W101

N3*400 FOUNDERS DRIVE

N4*WOONSOCKET*RI*02895

PO1**14*CA*175.62**UI*03288417688*UA*003288416790*PI*855752

PAM*01*2459*ZZ

PO4*6

CTT*1*14

SE*18*2217

GE*2*1378

IEA*1*000003429

viernes, 18 de abril de 2014

traslate EDI gentran format to SAP ERP format

En la carpeta

/export/home/evikcc/mediaGentran/IBM_GEN_Multiplatform

Hay un zip llamado

CIOJDEN cliente.zip

Este es el cliente.

Una vez que lo bajes lo descompilas y me avisas para poderte ayudar con la configuración.

entrada EDI

Actual PO(850) data from CVS.

ISA*00* *00* *ZZ*CVS *01*055826309 *121001*113

9*U*00400*000003429*0*P*^

GS*PO*CVS*055826309*20121001*1139*1378*X*004010

ST*850*2216

BEG*00*SA*0076423**20121001

REF*VR*12925

PER*BD*MICHELLE MARTINEAU

SAC*A*F050*ZZ*ZZ**1*1*****02***OTHER

ITD*01*15*2**30**31***100

DTM*002*20121022

AMT*BAP*2986

N9*L1*PO COMMENTS

MSG*THIS PO SUBJECT TO THE TERMS AND CONDITIONS FOUND ON CVS SUPPLIERS WEBSITE

N1*ST**54*Y101

N3*ONE CVS DRIVE

N4*WAVERLY*NY*14892

PO1**17*CA*175.62**UI*03288417688*UA*003288416790*PI*855752

PAM*01*2986*ZZ

PO4*6

CTT*1*17

SE*18*2216

ST*850*2217

BEG*00*SA*1265472**20121001

REF*VR*12925

PER*BD*MICHELLE MARTINEAU

SAC*A*F050*ZZ*ZZ**1*1*****02***OTHER

ITD*01*15*2**30**31***100

DTM*002*20121022

AMT*BAP*2459

N9*L1*PO COMMENTS

MSG*THIS PO SUBJECT TO THE TERMS AND CONDITIONS FOUND ON CVS SUPPLIERS WEBSITE

N1*ST**54*W101

N3*400 FOUNDERS DRIVE

N4*WOONSOCKET*RI*02895

PO1**14*CA*175.62**UI*03288417688*UA*003288416790*PI*855752

PAM*01*2459*ZZ

PO4*6

CTT*1*14

SE*18*2217

GE*2*1378

IEA*1*000003429

salida

Application file created using selected map from PO’s received.

ENV|0076423-20121001145006|CVS|0076423||X12|850S|SA00||20121001|1139

HDR|0076423-20121001145006|CVS|0076423||20121001|20121001|20121015|20121022||007

6423|||PP|055826309|||0076423|||||||||||||1|||ZZZ|||||30|31|2|01|02|||||||||||15

HAD|0076423-20121001145006|CVS|0076423|DEL|Y101

HTX|0076423-20121001145006|CVS|0076423|ARRIVAL DATE 2012/10/22

REF|0076423-20121001145006|CVS|0076423|VR|12925

LIN|0076423-20121001145006|CVS|0076423|1|6||UI|03288417688||||102|20121001|20121

015|102|EA|175.62|CA||||||||||||UI|03288417688|UA|003288416790|PI|855752||||||||

20121015

ENV|1265472-20121001145006|CVS|1265472||X12|850S|SA00||20121001|1139

HDR|1265472-20121001145006|CVS|1265472||20121001|20121001|20121015|20121022||126

5472|||PP|055826309|||1265472|||||||||||||1|||ZZZ|||||30|31|2|01|02|||||||||||15

HAD|1265472-20121001145006|CVS|1265472|DEL|W101

HTX|1265472-20121001145006|CVS|1265472|ARRIVAL DATE 2012/10/22

REF|1265472-20121001145006|CVS|1265472|VR|12925

LIN|1265472-20121001145006|CVS|1265472|1|6||UI|03288417688||||84|20121001|201210

15|84|EA|175.62|CA||||||||||||UI|03288417688|UA|003288416790|PI|855752||||||||20

121015

Crontab for AS2 data to schedule transfer of data for each customer both in and out.

# Monitor AS2 for error files

00 * * * * /opt/admin/scripts/monitoras2.ksh

#Process AS2 inbound

00 3,15,22 * * 1-6 /opt/admin/scripts/processexpeditors.ksh > /dev/null

45 9,21 * * 1-6 /opt/admin/scripts/processnyklogistics.ksh > /dev/null

05 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processkinray.ksh > /dev/null

07 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processmol.ksh > /dev/null

10 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processstaterbros.ksh > /dev/null

15 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processmeijer.ksh > /dev/null

20 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processlowes.ksh > /dev/null

23 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processbabyage.ksh > /dev/null

24 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processfreshandeasy.ksh > /dev/null

#25 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processamazon.ksh > /dev/null

25 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processamazonas2.ksh > /dev/null

26 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processvcprod.ksh > /dev/null

27 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processowens.ksh > /dev/null

28 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processcsn.ksh > /dev/null

29 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processcardinalmps.ksh > /dev/null

30 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processacosta.ksh > /dev/null

31 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processetoys.ksh > /dev/null

32 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processcommercehub.ksh > /dev/null

33 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processwalmart.ksh > /dev/null

34 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processbcf.ksh > /dev/null

35 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processtoys.ksh > /dev/null

36 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processoverstock.ksh > /dev/null

37 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processbbb.ksh > /dev/null

#38 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processojc.ksh > /dev/null

39 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processraleysprod.ksh > /dev/null

40 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processsearsca.ksh > /dev/null

45 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processsterling.ksh > /dev/null

50 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processtarget.ksh > /dev/null

52 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processweber.ksh > /dev/null

#Process AS2 outbound

00,30,45 * * * 1-6 /opt/admin/scripts/outboundsterling.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundlowes.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundmeijer.ksh > /dev/null

#00,30,45 * * * 1-6 /opt/admin/scripts/outboundamazon.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundamazonas2.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundowens.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundcardinalmps.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundstaterbros.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundsearsca.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundtoys.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundetoys.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundwalmart.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundtarget.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundkinray.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundraleysprod.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundbabyage.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundvcprod.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundcsn.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundbcf.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundfreshandeasy.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundoverstock.ksh > /dev/null

#00,30,45 * * * 1-6 /opt/admin/scripts/outboundojc.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundbbb.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundacosta.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundcommercehub.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundweber.ksh > /dev/null

05,20,35,50 * * * 1-6 /opt/admin/scripts/outboundexpeditors.ksh > /dev/null

05,20,35,50 * * * 1-6 /opt/admin/scripts/outboundmol.ksh > /dev/null

05,30 * * * 1-6 /opt/admin/scripts/outboundnyklogistics.ksh > /dev/null

Crontab for scheduling translation and backup of AS2 data. Also schedules all other EDI jobs non-baan.

#####

#######

#### crontab for ediprod on ap01

###

######## Transfer US CANADA translated data to Baan

#10 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/xfer2b.cr > /edi/gentran/61/

usr_bin/xfer2b.err 2>&1

###

######## Transfer US translated data to Baan

10 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/xferus.cr > /edi/gentran/61/u

sr_bin/xfer2b.err 2>&1

###

######## Transfer CANADA translated data to Baan

12 3,11,15,19 * * 1-6 /edi/gentran/61/usr_bin/xferca.cr > /edi/gentran/61/usr_bi

n/xfer2b.err 2>&1

###

######## Transfer MX translated data to Baan

11 3,7,11,13,15,18,19,23 * * 1-6 /edi/gentran/61/usr_bin/xfermx.cr > /edi/gentra

n/61/usr_bin/xfer2b.err 2>&1

###

######## Transfer WEBER 945 translated data to Baan

13 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/xfer945W.cr > /edi/gentran/61

/usr_bin/xfer2b.err 2>&1

###

######## Transfer EXPEDITOR 945 translated data to Baan

25 03,15,22 * * 1-6 /edi/gentran/61/usr_bin/xfer945E.cr > /edi/gentran/61/usr_bi

n/xfer2b.err 2>&1

###

######## Transfer NYKL 945 translated data to Baan

55 9,21 * * 1-6 /edi/gentran/61/usr_bin/xfer945N.cr > /edi/gentran/61/usr_bin/xf

er2b.err 2>&1

###

######## EDI housekeeping

###

####### CHECK TRANSLATIONS FOR ZERO QTYS #####

05 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/qtychk0|mailx -s "Translation

QTY Check Report" uomrcps

###

#53 22 * * 0 /edi/gentran/61/usr_bin/qtychk0|mailx -s "Translation QTY Check Rep

ort" uomrcps

####### RUN PRODUCT ACTIVITY DATA (852) TO ORACLE #####

30 14 * * 1-5 /edi/gentran/61/usr_bin/pad2db0.pl -o mail -L 2> /edi/gentran/61/u

sr_bin/pad2db.err

####### RUN PRODUCT ACTIVITY REPORT (852) #####

##46 13 * * 1-5 /edi/gentran/61/usr_bin/padrpt9 > /edi/gentran/61/usr_bin/padrpt

9.err

####### RUN PLANNING SCHEDULE REPORT (830) #####

20 14 * * 1-5 /edi/gentran/61/usr_bin/psrrpt > /edi/gentran/61/usr_bin/psrrpt.er

####### RUN Organizational Relationships (816) #####

01 23 * * 1-5 /edi/gentran/61/usr_bin/816_email > /dev/null 2>&1

###

####### RUN Payment Order / Remittance Advise (820) #####

02 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/820_email > /dev/null 2>&1

###

####### RUN Application Advise (824) #####

03 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/824_email > /dev/null 2>&1

###

####### RUN Purchase Order Change Request (860) #####

04 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/860_email > /dev/null 2>&1

###

####### RUN Text Message (864) #####

05 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/864_email > /dev/null 2>&1

###

####### RUN Order Status Inquiry (869) #####

07 23 * * 1-5 /edi/gentran/61/usr_bin/869_email > /dev/null 2>&1

###

####### RUN CREDIT DEBIT ADJUSTMENT REPORT (812) #####

39 2,6,10,14,18,22 * * 1-6 /edi/gentran/61/usr_bin/cdarpt > /edi/gentran/61/usr_

bin/cdarpt.err

###

06 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/cdarpt > /edi/gentran/61/usr_

bin/cdarpt.err

####### RUN XLLD REJECT UPDATE ################

30 2,6,10,18,22 * * 1-6 /edi/gentran/61/usr_bin/reprocess_xlld.sh > /edi/gentran

/61/usr_bin/reprocess_xlld.err

###

##### Process Kinray #####

10 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_kinray.ksh

##### Process MOL #####

12 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_mol.ksh

##### Process Stater Bros #####

15 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_staterbros.ksh

##### Process Meijer #####

20 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_meijer.ksh

##### Process Lowes #####

25 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_lowes.ksh

##### Process BABYAGE #####

28 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_babyage.ksh

##### Process FREASHANDEASY #####

29 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_freshandeasy.ksh

##### Process Amazon #####

#30 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_amazon.ksh

30 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_amazonas2.ksh

##### Process BJS #####

31 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_vcprod.ksh

##### Process Owens #####

32 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_owens.ksh

##### Process CSN #####

33 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_csn.ksh

##### Process Cardinal #####

34 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_cardinal.ksh

##### Process Acosta #####

35 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/processacosta.ksh

##### Process etoys #####

36 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_etoys.ksh

##### Process CommerceHub #####

37 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/processcommercehub.ksh

##### Process AS2 Wal-Mart data #####

38 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/processas2.ksh

##### Process AS2 Burlington data #####

39 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_bcf.ksh

##### Process AS2 TOYS R US data #####

40 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_tru.ksh

##### Process AS2 OVERSTOCK data #####

41 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_overstock.ksh

##### Process AS2 BBB data #####

42 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_bbb.ksh

##### Process AS2 OJCOMMERCE data #####

#43 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_ojc.ksh

##### Process AS2 RALEYS data #####

44 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_raleys.ksh

##### Process Sears Canada #####

45 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_searsca.ksh

##### Process GARCES EDI DATA ######

46 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx3.ksh

##### Process GARCIA EDI DATA ######

47 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx2.ksh

##### Process NADRO EDI DATA ######

48 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx1.ksh

##### Process COMERSA EDI DATA ######

49 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx.ksh

##### Process Sterling AS2 Data #####

50 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_sterling.ksh

##### Process MARZAM EDI DATA ######

51 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx4.ksh

##### Process Gigante EDI Data #####

52 02,06,10,12,14,17,18,22 * * 1-6 /opt/admin/scripts/process_gigante.ksh

##### Process network6 EDI Data #####

53 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_network6.ksh

##### Process network3 EDI Data #####

54 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_network3.ksh

##### Process Target #####

55 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_target.ksh

##### Process Weber #####

57 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_weber.ksh

##### Process Walgreen vendor split #####

56 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_walgreensplit.ksh

##### Process network2 EDI Data #####

57 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_network2.ksh

##### Process Expeditors 945 #####

05 03,15,22 * * 1-6 /opt/admin/scripts/process_expeditors.ksh

##### Process NYKL 945 #####

50 09,21 * * 1-6 /opt/admin/scripts/process_nykl.ksh