Open Forum

Expand all | Collapse all

PM Checks Batch Status Stuck in "Check Printing"

Jump to Best Answer
  • 1.  PM Checks Batch Status Stuck in "Check Printing"

    TOP CONTRIBUTOR
    Posted Aug 05, 2019 08:02 PM
    One of our A/P staff had started her check printing process then she received a message that the "Mekorma product wasn't registered".  So, it put her batch in limbo (by that I mean "stuck"). It's not in Batch Recovery. It shows as "Check Printing" when we open the Post Payables Checks window to reprint the checks. We are on GP2016R2.

    I did find out that there is a new build for MICR. Anyone using MICR you will want to check on that. I've installed it, which should stop this from happening again but now I have to get the batch unstuck. Technically, reset the batch so we can start the check printing process over again.

    This is a job for SQL. I thought I had a SQL script for it but I'm unable to find it. Knowing how important this is I don't want to take the chance of missing a table and making it worse. Would someone be so kind as to provide the exact SQL script I would run to fix it?

    Thanks!!


    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: PM Checks Batch Status Stuck in "Check Printing"
    Best Answer

    TOP CONTRIBUTOR
    Posted Aug 05, 2019 08:13 PM
    Hi Joni.

    Review the link below on how to fix a stuck batch.  You'll need to perform step 4 in your case against the company database that has the issue.

    https://support.microsoft.com/en-us/help/850289/a-batch-is-held-in-the-posting-receiving-busy-marked-locked-or-edited​​

    ------------------------------
    Kristen Hosman
    Independent Dynamics ERP Consultant
    Mount Evans Consulting
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: PM Checks Batch Status Stuck in "Check Printing"

    TOP CONTRIBUTOR
    Posted Aug 06, 2019 09:54 AM
    Thanks for your response @Kristen Hosman.

    Does this take care of the check that is stuck in WORK status? Also, I forgot to mention...the invoice is still in OPEN status.

    Thanks!!

    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: PM Checks Batch Status Stuck in "Check Printing"

    TOP CONTRIBUTOR
    Posted Aug 06, 2019 09:59 AM
    Hi Joni.

    It can work if the situation is right for it.  I have time to review with you if you'd like.  I'll send you a message with my contact info.

    ------------------------------
    Kristen Hosman
    Independent Dynamics ERP Consultant
    Mount Evans Consulting LLC
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: PM Checks Batch Status Stuck in "Check Printing"

    TOP CONTRIBUTOR
    Posted Aug 06, 2019 11:24 AM
    Thanks again for your help @Kristen Hosman!​

    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: PM Checks Batch Status Stuck in "Check Printing"

    Posted Aug 06, 2019 12:45 PM
    Hi Joni,

    If you find that you require assistance due to any issues on the Mekorma side of things, we would be happy to open a case for you. Please contact support@mekorma.com as needed.

    Thank you,

    ------------------------------
    Beth Mongold
    Video Content Creator
    Mekorma
    West Hollywood CA
    ------------------------------

    Conference-GPUG_200x200


  • 7.  RE: PM Checks Batch Status Stuck in "Check Printing"

    TOP CONTRIBUTOR
    Posted Aug 06, 2019 02:27 PM
    Edited by Joni Finnell Aug 06, 2019 02:27 PM
    Thanks @Beth Mongold. Krista took very good care of me. I just had to find additional assistance for SQL.​​

    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------

    Conference-GPUG_200x200


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