D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Power outage caused 2 issues with POs and their invoices

  • 1.  Power outage caused 2 issues with POs and their invoices

    TOP CONTRIBUTOR
    Posted 20 days ago
    ​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.
       
    Pending invoice message

    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:
        
    Currency error when trying to post 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
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Power outage caused 2 issues with POs and their invoices

    Posted 20 days ago
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Power outage caused 2 issues with POs and their invoices

    TOP CONTRIBUTOR
    Posted 19 days ago
    @Jonathan Howe  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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Power outage caused 2 issues with POs and their invoices

    TOP CONTRIBUTOR
    Posted 19 days ago
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role