SBX - Search With Button

SBX - Forum Post Title

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

Microsoft Dynamics AX Forum

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

Question Status



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


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.


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.


SBX - Two Col Forum

SBX - Migrated JS