JD Edwards EnterpriseOne and Salesforce integration - Simple Steps

JD Edwards EnterpriseONE and Salesforce integration

Recently I create an application on web using asp.net C# to integrate JD Edwards EnterpriseOne (8.10/8.12/9.0) and salesforce, in this application I am uploading sales leads generated by our affiliate. Our affiliate entering sales leads in salesforce and my company wants to generate invoice from JD Edwards , So I created an online application so that anyone can use this application to upload data in JD Edwards from anywhere using internet by a single click.

We can also schedule this application to run in a particular time or run every night or weekly.

Technical Details:-

I did following steps in order to achieve this:-

1. Create a web-application using Salesforce api,C# to download Data in a sql-server table.

2. Check if all address# exist in JD Edwards, If not create a report, so that user can enter manually. I can automate this step by using address book z-file upload method but my company wants to create addresses manually.

3. Created a JD Edwards UBE report program to upload data in F47011/F47012 files and to run R47011 UBE.

4. Using RUNUBE command from webpage, to run R5542334 and R47011 to load data in F47011/F47012 and sales tables F4211/F4201.

5. Our sales team verifying these sales and creating invoices and also doing sales update.

If you want this process for your company or you have any questions please send email at dostind@hotmail.com .