Open Forum

Expand all | Collapse all

Payable transaction

  • 1.  Payable transaction

    GOLD CONTRIBUTOR
    Posted 21 days ago
      |   view attached
    When looking up a Accounts payable inquiry I received an error message.  I have attached the error.  The transaction was an payable entry and a payment.  When I ran my EFT file it showed up and it shows up in the Financial module in our cash account.

    The transaction doesn't show up when I do an inquiry.  Seems like the tables didn't update.

    ------------------------------
    Debbie Dornhoefer
    ATPE
    Austin TX
    ------------------------------

    Attachment(s)

    docx
    error 03162020.docx   229K 1 version


  • 2.  RE: Payable transaction

    GPUG ALL STAR
    Posted 21 days ago
    Hi @Debbie Dornhoefer

    ​First, try turning off your computer and turning it back on, you may have temporarily lost connection to SQL.

    If that does not clear up the issue try running Reconcile on this Vendor/Doc Number in Purchasing>Utilities to see if that will clear it up.  The error points to the TEMP tables that get updated with a reconcile

    Without being able to see the tables it seems fine, unless posting was interrupted before the final phase of removing the transaction from open after putting it in history.  In other words you may have a duplicate transaction in both the History and Open tables.  If it is fully in the history tables it can be manually removed from Open and/or CheckLinks may fix it.

    *do not run checklinks without a really good backup*

    ------------------------------

    ------------------------------



  • 3.  RE: Payable transaction

    GOLD CONTRIBUTOR
    Posted 21 days ago
    Thanks will try this.

    ------------------------------
    Debbie Dornhoefer
    ATPE
    Austin TX
    ------------------------------



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