Cannot insert multiple records in Vendor invoice lines. The record already exists

Question Status

Bob Brewster asked a question on 17 May 2018 10:45 AM


While invoice matching in Accounts payable, an error occured. Is it a locking in the tables?

André Arnaud de Calavon responded on 17 May 2018 12:51 PM

Not completely sure, but did you setup the Increment field on the System parameters?

Bob Brewster responded on 22 May 2018 10:52 AM

Hi André - yes, by 1 in the System Line number field. Havn´t found an solution. The Invoice- PO matching is for like + 100 POs to one invoice (summary invoice). Cannot find the anything interesting in the pending invoice form. Any clue where to proceed? Thanks for your effort.

André Arnaud de Calavon responded on 23 May 2018 4:35 PM

Hi Bob,

There is one unique index on this table which holds a LineNum field. In my environment it has 4 fields. Can you verifiy if the TableRefIdx index in your environment also has 4 fields? (TableRefId, OrigPurchId, LineNum, RecId). In my environment there is a KB number visible on this index (KB3199741) which might indicate that there was a fix in the past for a certain issue. Probably the issue you are facing now, but I'm not sure.