Hi ,
Am getting this error while posting Purchase Invoice . Kindly advise how to check this issue
Cannot create a record in Vendor invoices (VendInvoiceInfoTable). Purchase order: PO2003144,xxxxxxx.
The record already exists.
AX 2012 R2 - CU6 version .
Thanks in advance .
Is there already a record existing in that particular table? Can you check the table browser or SQL?
While creating purchase invoice it will be there up on posting invoice status will get change .
Hi Mr.Raj,
Seems your haven’t read comments from Jake.
Check table VendInvoiceInfoTable. if it has record with same Invoice number…
Check Indexes in table(If any customised) and see data accordingly.
There is no Duplicate Invoice Number on VendInvoiceInfoTable. I have checked that part.
Can you take a look at the number sequence controlling that functionality? If it’s continuous, there could be a number sequence stuck or something. You might have to clean up that number sequence.
Thanks for your response Mr.Jake Roder.
It’s not happening for all the Purchase invoice posting , Any way I will try to change the number sequence as you suggested and let you know.
Kindly refer the Debug screen , it’s Number sequence ,Prod route,Unit of measure not found .
Is it related to purchase invoice posting ?
i don’t think those things have anything to do with the error you’re seeing. Can you take a look at the number sequence that’s being called for this process?
Aren’t there any other unique indexes?
Is there a pending invoice of the same number related to the order?
There is no Pending Invoice .
i’ve run into that, too. there’s actually a filter sometimes on the pending invoice form by default - you don’t even see it unless you go and look at the advanced filter and sort.
