maximum line in Item Journal

richtsang

Hi,

I have not faced this scale before. So, hope someone can give me some advice.

My client intends to import 10M text file data to navision. He had tried to import 1M before. End up there are 30+ line in one item journal batch.

So, the question is "Any line limitation in one item journal batch? And any line limitation for posting". My client will do it in mid-night. So, it should not affect other users.

thanks in advance.

Rich

garak

The max. Line No (integer field) can be 2147483647.
So if you go with Lineno += 10000; you can "only" store 2147480000 lines. but you can also use LineNo += 1 (so you can create 2147483647 lines)
If there is a limit on posting? I doesn't found one.
But for a faster posting i would make split postings.
So it's faster and if, for example in line 2147470000 is a error, the server mus not make a whole rollback for all lines.

richtsang

Dear Garak,

thanks for your reply

Rich

MBerger

There is no rule that states that, when using code, you NEED to use 10000, 20000, 30000.... as line numbers. NAV does this so there is room to be able to insert new lines between existing ones. You can use 1,2,3 just as well, it won't matter.