LynX Office is an add-on of LynX Business Integrator that makes it effortless to upload data from Excel to JDE EnterpriseOne. Generally, a user takes these steps to mass upload data into E1:
In LynX Office, these steps are reduced to:
Problems with the manual approach are:
For more information on LynX Office, please visit our product page:
- Prepare the data in Excel
- Enter header information manually (if this is a header/detail transaction)
- Cut/paste the data into the grid
- Save
- Repeat steps 2 through 4 for each transaction
In LynX Office, these steps are reduced to:
- Prepare the data in Excel
- Upload the data
Problems with the manual approach are:
- Some data has to be entered manually. There is no way around it.
- Transactions have to uploaded one at a time.
- The upload can take a long time if a large data set is uploaded.
- Not all applications have a grid to upload data. Z-Files is another option, but that requires additional steps and makes troubleshooting cumbersome.
- The web server that is processing the user's upload is taxed and causes performance issues to other users who have sessions on that server.
- Users can enter all the data in Excel.
- Users can lookup data (account#, for example) in Excel, so they don't have to flip back and forth between Excel and JDE.
- Uploads are significantly faster than JDE.
- Errors are displayed clearly in Excel itself. Error navigation makes it easy to identify and resolve errors.
- Proof mode uploads is an added bonus: Users can upload the data in proof mode before uploading the data in final mode.
For more information on LynX Office, please visit our product page:
LynX Office: Upload data from Excel to JDE in one step! - Aellius
JDE, EnterpriseOne, Excel, Upload, direct, mass, update, 1000 rows, 5000 rows, journal entry, address book, fixed assets, budget upload, ap, ar, fast, performance
www.aellius.com
Last edited: