Notifications
Announcements
No record found.
Hello all...
What is the largest number of transactions that can be imported into GL through TI or any other method? Is it in the 10K+ region?
*This post is locked for comments
Hi,
In that scenario i suggest that don't use TI, instead use sql store procedure or a SSIS package.
On my experience I made a store procedure and the performance is great.
Thanks Juan. What is the largest number of transactions you have been able to import that way in a single batch? We are migrating from Dynamics NAV and have some batches that have 10,000+ entries.
On my experience, import to GL not more than 1,000 records, but I have a customer that imports to IN (Batch, Intran) and at least are 7,000 batches per night. Additionally have to import documentos to other modules like AP, AR, PO.
Whit a good sql store procedure I don't see any problem to do that.
Thanks once again, that should do, especially considering this is mostly historical data anyways.
Separately, why does SL use -32768 (or similar) as the starting Line Number with the large increments? Is it acceptable to start the line numbering at 1 and use a single increment of 1 so that a 1,000 line entry is numbered from 1 to 1000?
The reason is because the field LineNbr is a smallint type and the values that accepts is between -32768 and 32767. Aditional the SL Kernel gets a random number between this two numbers to preserve the order of the rows, in that user captures the data on the screen.
Yes you can start the linenbr in any number between -32768 and 32767, and increment one by one. By example you can start at -32768 and increment 1 to -32767, -32766, etc.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
