Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Rudy Salcedo]

?One of our Staff Accountants was in the AX 2012 R2 Pending vendor invoices screen (Accounts payable/Common/Vendor invoices/Pending vendor invoices) posting invoices when a power outage shut down his computer.  When the power was restored, he tried to resume posting invoices, but received this msg on all the POs that appeared on the Pending vendor invoices screen when the power went down.
   

 
I found a blog that said to clear the records in the VendInvoiceInfoTable & VendInvoiceInfoLine tables for the POs that received this msg.  After deleting the recs in those 2 tables for the problematic POs the msg didn’t come up anymore.

However the following error msg is coming up now on those same POs when trying to post an invoice:
    

We only transact in USD and never have a need to convert from one currency to another.  Our Controller has confirmed that the currency is correctly specified on all POs. 

Have any of you seen this before and successfully resolved it?

Thanks in advance.

——————————
Rudy Salcedo
Senior Programmer/Analyst
LaForce, Inc
Green Bay WI
——————————

[Jonathan Howe]

I fear you may have created a data inconsistency with the records deleted from the VendInvoice tables. If you have a partner to support you I think this needs escalating.

I had similar issues on AX2009 and the table we used to have to clear out was purchParmTable where .ParmJobStatus = Waiting and .Ordering = Invoice. this may be different in AX2012 but I think you have gone beyond this point however.

——————————
Jonathan Howe
IT Manager
Cross Manufacturing
Bath, UK
——————————
——————————————-

[Rudy Salcedo]

?  We’ve actually used the fix for the first msg (clearing the VendInvoice tables) successfully a few times in the past, and AP was able to post invoices for the POs without getting the currency error.  There are 17 ?POs involved, and 9 of them are getting the currency error, and the other 8 had invoices successfully posted after clearing their VendInvoice records.

We’ll keep digging for a solution, but as you suggested, we might have to get our AX support partner involved with this.

——————————
Rudy Salcedo
Senior Programmer/Analyst
LaForce, Inc
Green Bay WI
——————————
——————————————-

[Ian Gorman]

Rudy,

Have your AX admins review KB 3008597.

https://fix.lcs.dynamics.com/Issue/Details/1207916?kb=3008597&bugId=2744102&dbType=0&qc=244174af8e75cdc5a499322f79c58c2539fb28dde11b07e4a42cd522554ccf8d

PROBLEM

There are two sourcedocumentline records with a sourcerelationtype of 1425 associated with the sourcedocument header for an invoice. The Recid for the orphaned record is not contained within the SourceDocumentLine field of any VendInvoiceInfoTable record.

DESCRIPTION OF CHANGE

The changes in the hotfix include adding a lock and an extra check against the invoice in the active to saved deep copy method. This will check if the workflow processing deep copy and the close form deep copy are running at the same time, one of them will exit out before touching the lines. This will ensure the lines on the invoice are only copied once.

——————————
Ian Gorman, PMP, MCSE
Senior Consultant
——————————
——————————————-