Solution for GL Records creation

AntonyL

Member
Hi All,

We have a requirement where we need to process close to 1 million transactions and burst those into multiple lines based on some rules and transaction types. The expected burst volume is 3-5 million transactions. We are trying to see if it will be feasible to perform the bursting logic i.e., converting 1 to many configuring required rules in JDE through a custom solution. Need your inputs on the following points:

1. Can we handle such volume of records in JDE through some batch process?
2. Considering the volume of transactions, can we choose to have separate database outside JDE for input and output (burst details)? This means we need to access foreign tables for bursting process and write output to another foreign DB? Can this be done?

Any inputs much appreciated.

Regards,

Antony Lenin
E9.1(9.1.4), SQL 2008 DB on Win Server 2008
 

jdelisths

Reputable Poster
1. You can use batch process, but error handling can be a nightmare, considering the transaction volume.
2. JDE can access foreign tables. You can write a table conversion to access foreign tables (I think you can do this in a UBE as well: someone, please confirm).


To alleviate error handling (#1) and additional work (#2) consider using an integration product. We have a time tested, robust G/L upload process using our product LynX Business Integrator. Link: https://aellius.com/lynx-business-integrator. 10,00 line GL upload YouTube: https://www.youtube.com/watch?v=BK2xhpxMnJo
 

AntonyL

Member
Thanks for your response Hari!
I have experience in building UBE/TC to access foreign tables, however considering the volume involved in current scenario, I am concerned on the performance.

Thanks,
Antony Lenin
E9.1(9.1.4), SQL 2008 DB on Win Server 2008
 

jdelisths

Reputable Poster
The performance of accessing the foreign tables will be minimal compared to the performance of creating the Journal entries.
 
Discover how to build no-code data integrations and business process automations.
Top