GL Upload 5k+ lines

C

carterjde

New member
I was referred to this forum in this post on jdelist: https://www.jdelist.com/vb4/showthread.php?t=54865&s=a6514fae9f79fa5b8d76f05ef2121cb0

As I mentioned in that post, we are trying to implement a solution to upload Excel and/or CSV files to JDE without intermediate steps or creating table conversions that ultimately rely on z-tables. Your solution looks promising. My team has the following questions:
  • How are errors handled?
  • The file may have more than 5k+ lines. Can your system handle this? Do you have any performance benchmarks?
  • The file will have multiple Journal Entries. Can your solution recognize the breaks in the file?
 
Cool Calico

Cool Calico

Administrator
Staff member
Hi @carterjde,

Error Handling:

If you upload the file through File Exchanger, the errors are displayed in the app itself. You can search through the error messages and even export them to CSV/Excel for further analysis. The error messages contain:

  • Description of the error
  • Line # of the file that corresponds to the error

If you upload the file through LynX Office, the errors are displayed in Excel - the cells with errors "red" out. You can see this in our demos on YouTube: https://youtube.com/aelliuslynx.

If you upload through our Web Service, the errors will be returned to you in the response. The program that submits the request can read them and take appropriate action. The response is structured as XML, so this is easy.

Large Uploads

Our system will have no problem uploading 5k lines. You can expect 5k lines to process within a minute (or less).

Multiple JEs

We have a pre-built business process to create Journal Entries (from Excel and CSV files). The process can be configured to break on certain key fields (date, explanation for example). We have done this for other clients, so this is not new for us.
 
You must log in or register to reply here.
Top