Share
ReportHello 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
You’re offline. This is a read only version of the page.
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
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.
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?
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 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.
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.
#1
André Arnaud de Cal...
293,041
Super User 2025 Season 1
#2
Martin Dráb
231,856
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (
