Open Forum

Expand all | Collapse all

Cannot Find the Check to Be Voided

Jump to Best Answer
  • 1.  Cannot Find the Check to Be Voided

    SILVER CONTRIBUTOR
    Posted 28 days ago
    Hello:

    A GP 2016 end user is having an issue where she needs to void a check dated 11/21/2018.

    The check's corresponding invoice shows as voided.  But, the check is nowhere to be found.

    When I say that, I mean that the client can see the check in a Bank Reconciliation SmartList as an unreconciled check.

    But, when double-clicking on that record of the SmartList, the check does not appear.  The Checkbook Register Inquiry window and a screenshot of the voided historical invoice appears, instead.

    When looking through Payables Inquiry windows and payables tables in SQL, this check is not found.

    I recreated the payables keys file, including running check links, but to no effect.
    Do you all have any thoughts on how to find this check so that it can be voided?

    Thank you!

    John

    ------------------------------
    John Ellis
    The Bulldog
    S2 Technology
    ------------------------------


  • 2.  RE: Cannot Find the Check to Be Voided

    SILVER CONTRIBUTOR
    Posted 28 days ago
    Can you find it in the SQL tables?

    ------------------------------
    Deanne Rasmussen
    ePlanPartners
    Houston TX
    ------------------------------



  • 3.  RE: Cannot Find the Check to Be Voided

    SILVER CONTRIBUTOR
    Posted 28 days ago
    No, I'm afraid not.

    ------------------------------
    John Ellis
    The Bulldog
    S2 Technology
    ------------------------------



  • 4.  RE: Cannot Find the Check to Be Voided

    SILVER CONTRIBUTOR
    Posted 24 days ago

    Hello:

    I have determined that the only place the check number exists in SQL payables tables for the Vendor ID is in the PM80200 table. 

    With the Originating Transaction Source field data in that table, I was able to create a SmartList for the voided check's journal entry.  Upon trying to drill-back to Source Document in the Inquiry Zoom window, however, GP gave me a message saying that "Transaction history does not exist for this transaction".  This is shown in the screenshot below that I have uploaded.

    The Cash Account in the G/L is correct.  But, Bank Reconciliation SmartList reporting still shows this unreconciled check number.

    The only thing that I can think of to eliminate that record from Bank Reconciliation is use GP's Remove Bank History window.

    Can anyone think of any other avenues to go on, before taking this step?

    Thank you!

    John

    Voided Check Journal Entry


    ------------------------------
    John Ellis
    The Bulldog
    S2 Technology
    ------------------------------



  • 5.  RE: Cannot Find the Check to Be Voided

    SILVER CONTRIBUTOR
    Posted 18 days ago
    Hi:

    Here's an update.  The Bank Reconciliation module does not recognize the check as voided.  So, I cannot remove it in the Remove Bank History window.

    Does anyone know which SQL tables I can remove this from and, preferably, without updating the Checkbook balance upon running Check Links on the Financial series of tables?

    Thanks!

    John

    ------------------------------
    John Ellis
    The Bulldog
    S2 Technology
    ------------------------------



  • 6.  RE: Cannot Find the Check to Be Voided

    TOP CONTRIBUTOR
    Posted 15 days ago
    Hi John,

    Just curious, are you able to locate the payables check in the following tables: PM10300, PM10400, PM20000, PM30200?
    Are you saying that it's just in the apply tables: PM10200 / PM30300?
    The distribution tables are PM10100 / PM30600...
    Of course there's also the PM Keys table... PM00400

    On a side note, there are other things to consider... like resetting the outstanding document amount of the invoice... and what table is the invoice in right now (PM10000, PM20000, PM30200)?

    Should you decide to proceed...make sure to try it out on a test company first...



    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------



  • 7.  RE: Cannot Find the Check to Be Voided
    Best Answer

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Hi:

    I had the client enter and post an Increase Adjustment in Bank Transaction Entry, debiting and crediting the same G/L cash account.

    They're good.

    Thanks!

    John

    ------------------------------
    John Ellis
    The Dynamics Bulldog
    S2 Technology
    ------------------------------



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