External Sales process?

dale_draper

Well Known Member
We are investigating an e-commerce web site and need a way to feed orders
into JD Edwards from the web site. It should be "almost real time" The web
interface will be hosted on the AS400. I am looking for a method that will
provide a clean interface that will not be too involved to setup. If anyone
has had experience with this could you tell me how you did it and what
problems/benefits you have had.
Bottom line, is there an external process provided by JDE for something like
this? Z file batch update, edi?
 
There is an inbound sales order program for EDI - P47011. This also
provides a holding place for error transactions and screens to fix them-
G47212.



dale draper
<[email protected] To: [email protected]
ega.com> cc:
Sent by: Subject: External Sales
[email protected] process?
delist.com


02/13/01 01:35 PM
Please respond to
jdeworld






We are investigating an e-commerce web site and need a way to feed orders
into JD Edwards from the web site. It should be "almost real time" The web
interface will be hosted on the AS400. I am looking for a method that will
provide a clean interface that will not be too involved to setup. If anyone
has had experience with this could you tell me how you did it and what
problems/benefits you have had.
Bottom line, is there an external process provided by JDE for something
like
this? Z file batch update, edi?





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=5531

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 

rtuohy

Member
Hi Dale,

EDI or more correctly System 47 is probably your best bet. Feed the data
into the P47011 and P47012 (header and detail) and run (I think) P47010 to
create Sales Orders. I've seen this used to create SO's by Sales Reps
entering data into Lotus notes, flat files FTP'ed in, uploads via Client
Access file transfer or similar, etc, etc, you name it. It is robust, easily
set up, and works well. Problems are fairly easily identified from the error
reports and are usually down to incorrect Item numbers or Item/Branch plant
missing, address numbers incorrect, etc.

Regards
Ron Tuohy

>
>We are investigating an e-commerce web site and need a way to feed orders
>into JD Edwards from the web site. It should be "almost real time" The web
>interface will be hosted on the AS400. I am looking for a method that will
>provide a clean interface that will not be too involved to setup. If anyone
>has had experience with this could you tell me how you did it and what
>problems/benefits you have had.
>Bottom line, is there an external process provided by JDE for something
>like
>this? Z file batch update, edi?
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=5531
>*************************************************************
>This is the JDEList World Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
 

CMirth

Member
Dale,
Use the Batch Import process on JDE. Load the F4001Z (Order header), F4011Z
(Order detail), and the F4006Z file (Address). Then run the P40211Z
Dreamwriter to import the files and perform all of the background
processing, etc. This program can be found from menu G4212 option 24. We
have a job setup in our job scheduler to run this hourly.

This is how you batch orders into JD Edwards from another source. If your
web interface will be on your JDE machine then simply write an RPG program
to populate these files from your e-commerce program's data files.

Chris Mirth
 
Call Orchestrations From Excel – The Easy Way to Make the Orchestrator Work for You.

ssavino

Member
Dale

My company used Ironside Technologies. Their Ironworks product handles the
entire "front-end" Web side. We didn't have to add any Java programming
resources to our staff. The product was merely "configured" for what we
needed it to look like. Any "Java" programming that had to be done was
accomplished by Ironside. They say the changes are upwardly upgradable, so
we can take future releases without issues. It isn't hosted on the AS/400.
We use Microsoft.

The "gateway"/middleware software in Iron Works calls RPG programs that
run on the AS/400 when they are needed. The RPG program used to add Sales
Orders is a base J.D. Edwards program, P4001Z - The Batch Order Entry
Program. We also had a custom "Green Screen" program for Item Availability
lookup. Ironside was able to make that program accessible from the Web
using iron works and some modifications. Because of this integration,
orders are placed and Availability look up is done in relative "Real-time".




dale draper
<[email protected] To: [email protected]
ega.com> cc:
Sent by: Subject: External Sales process?
[email protected]
delist.com


02/13/01 02:35 PM
Please respond to
jdeworld






We are investigating an e-commerce web site and need a way to feed orders
into JD Edwards from the web site. It should be "almost real time" The web
interface will be hosted on the AS400. I am looking for a method that will
provide a clean interface that will not be too involved to setup. If anyone
has had experience with this could you tell me how you did it and what
problems/benefits you have had.
Bottom line, is there an external process provided by JDE for something
like
this? Z file batch update, edi?





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=5531

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Chris,

How does the F4006Z file work? I currently load sales orders for admission
tickets into our AR system through the F4001Z and F4011Z. I never really
knew about the F4006Z file? What does it do when you run it through the
P40211Z process?

Thanks...

Jim

--------------------------------------------
James G. Donahue
Manager, Applications & Development
Paramount Parks Inc.
(704) 561-8111
 

CMirth

Member
F4006Z is used for ship-to or bill-to overrides. By default, JDE will use
the address from the address book that matches the number you loaded into
F4001Z.

If you load an override address into F4006Z the P420211Z process will use
this address. There is a flag in the F4006Z file that designates whether or
not it is a bill-to or ship-to address.
 

sbrown

Member
We created our own version of shopping cart to our AS400. We load the f4001z and f4011z files and also the f0101z1 to create a new customer as well. We submit a remote command the enter the customer and another to submit the program J40211Z to create the order. Right after that we submit another remote command to print the pickslip. This is all done through cold fusion. You may look at our website under shopping to see how it works. www.dixonusa.com
 
Top