Error message while posting AP invoice from custom dataport

Denis_Petrov

We have created a custom on-line overlay of Navision so remote office could enter HR, Payroll, etc information to be processed on our Native Navision server here. Things have been working fine for the last 2 years. :whistle:

Now we are moving AP module on-line, the final piece - custom AP dataport brings data into Navision. But when trying to post AP invoice I get this error message:

The Journal Line Dimension already exist.

Identification fields and values:
Table ID='38',Journal Template Name='',Journal Batch Name=''Journal Line No.='0',Allocation Line No.='0',Dimension Code='City'

What is the best way to fix the problem?

Thank you all!

Karenh

You need to populate the Line No. field with an incrementing set of numbers.

Create a variable, and increment it by 1 for each journal line.

The safest way to get your starting value for the variable is to get the highest line number that currently exists for the table (FINDLAST after setting filters for the Journal Template Name and Journal Batch Name)

Denis_Petrov

Thank you for the reply. The problem is that all line No. are populated in Purchase Header table and dataport entries (appear to) look identical to those entered manually. Moreover, the message seems to be from table 356 - which is not even engaged and has no entrie with Table ID='36'...

Savatage

see if this brings some insight [-o<
http://www.mibuso.com/forum/viewtopic.php?t=26002

Denis_Petrov

Dear Savatage

it it nice to hear from you!
Unfortunately changing form #51 property DelayedInsert to Yes did not address the issue, same error message. The invoice does not even have 2 lines to have a conflict it seems!
](*,)