Posting No. Series for Imported Journal Lines

mikelacey · 2007-06-01

Hello,

I have a dataport set up to import journal lines into a general journal batch from a MS Excel csv file. The dataport contains the following lines of code at the On Before Import Record stage:
docNo:='IM001';
VALIDATE("Document No.", docNo);

"docNo" is set up as a variable. I have this beacuse Navision requires something to be entered in the Document No. field for a journal to post. The journal batch that the lines are imported into is set up with a posting no. series. However once the journal lines have been posted (after the dataport has been run)....the posted lines still have the 'IM001' as the document number and have not been replaced with the posting number series set up in the journal batch as expected.

Can anyone help me please? If I manually type a journal line into this batch it uses the number series set up as the posting no. series for the batch when I post.

I am running Navision GB v4.0 on C/Side.
Thanks,
Mike

Arhontis · 2007-06-01

Hello Mike,

You can always use the NoSeriesManagement codeunit and use the GetNextNo routine when ever you want to get the next number from a number series to put in your journal lines...

When you manually enter a journal line, then Nav uses alot of code to initialize the record and build up information, like the Document No.

You don't need to use the default code that builds the doc no when entering the journal line manually if your only problem is the document no...

Sample of GetNextNo usage:
http://www.mibuso.com/forum/viewtopic.p ... =getnextno
http://www.mibuso.com/forum/viewtopic.p ... =getnextno
http://www.mibuso.com/forum/viewtopic.p ... =getnextno

You get the first document no at the start of the dataport and then increase it manually when you want to change the article...

Posting No. Series for Imported Journal Lines

Comments

Categories