Newbie dataport problem

how to import data from excel or access in navision?
pliz help
thanx [-o<

Ilona,

I guess today is the day?

I just want to clarify where I meant for you to go to "delete" no series. The first thing to consider is that you have system set-up and you have journal set-up.

System set-up would be your no. series definitions themselves. It starts with XXXX and ends with ZZZZ and the last used was XXXY and manual numbers are allowed (Y/N), etc.

Journal Set-up is where you can specify which no. series you intend to use per Journal Batch. When you go to your job journal and select the journal batch name, you should be presented with a form showing available journal batches. here you should see columns for no. series and posting no. series (show/hide as needed). When you leave these fields blank, the user controls what the doc no will be on entry AND on posting.

I have double checked where i have seen this before, and confirmed this does work. I have imported to item journal to load initial inventory and wrote an import to enter Payroll entries to a General Journal (we don't have the payroll module but the entries must be reflected in the G/L). In both cases, defining the journal batch without a no. series (or a posting no. series) let me push in my imported values.


Here is what I used, data item = integer. Some stuff happens in other triggers mainly for clean-up, etc.

[i]..earlier i purged whatever was in this journal to avoid same file from being imported more than once in error[/i]
//Now we need to begin creating the journal lines. The first record in the import file will be line 10000. (i omit this logic below)
//Subsequent line nos will be incrementally increased by 10000.

   GenJrnlLine.INIT;
   GenJrnlLine.VALIDATE("Journal Template Name",'GENERAL');
   GenJrnlLine.VALIDATE("Journal Batch Name",'XX');
   GenJrnlLine.VALIDATE("Source Code",'GENJNL');
   GenJrnlLine."Line No." := TempLineNo;
   GenJrnlLine.VALIDATE("Posting Date",InPostDate);
   GenJrnlLine.VALIDATE("Document No.",InDocNo);
   GenJrnlLine.VALIDATE("Account Type",GenJrnlLine."Account Type"::"G/L Account");
   GenJrnlLine.VALIDATE("Account No.",InGLAcct);
   GenJrnlLine.VALIDATE(Description,InDescription);
   GenJrnlLine.VALIDATE("Shortcut Dimension 1 Code",InDept);
   GenJrnlLine.VALIDATE(Amount,InAmount);
   CLEAR(GenJrnlLine."Gen. Prod. Posting Group");
   IF GenJrnlLine.INSERT THEN BEGIN
      //line created without problem
      Counter += 1;
   END ELSE BEGIN
      MESSAGE('Error creating journal line for %1 %2 %3 %4',InGLAcct,InDept,InDescription,InAmount);
   END;
   TempLineNo += 10000;

maybe this helps you?

Can be corrected by inserting as soon as you have filled the primary key fields. Then the validates on fields that create dimensions will fill out the underlying table.

Oh and try manually typing in the line so you have something to compare agains.

Just move your insert(true) to right after Journal Template Name,Journal Batch Name,Line No. has been filled out. Then the line is in the database and validates then works as if you typed it in.
The primary key is in the table, and is what keeps every line unique.

AFTER you insert the line no :-)

Looks like you are validateing Quantity on an empty line. Use debugger to see what goes wrong. 1 thing is for sure: primary key fields are not filled out, or not inserted.