Open Forum

Expand all | Collapse all

Stuck payment batch with extra issues?

  • 1.  Stuck payment batch with extra issues?

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Twist on the common "stuck batch" issue, has anyone encountered the below issue? i couldn't find any additional instruction beyond freeing up the batch via the SQL script.

    I had a user come to me with a payment batch stuck in printing status, he had a process frozen in his process monitor (second time this has happened in a few days actually) and was not able to get it moving. So, per several posts instruction, he force closed the app to kill those processes. I went into SQL, and found the batch he was trying to process, which was stuck in printing status, and ran the script to flip the status and marked to post fields to a value of 0. Unfortunately, he printed the EFT file for this batch after it was freed up, but before it was posted, which i'm thinking has caused the issue.

    The payment batch is currently open, but all the transactions within it show an error that they've already been posted, and will not post. There is no GL activity related to this batch, no pending batch or anything, so i'm not even sure what would happen if we attempted to void those payments.

    I'm going to take a backup of production and dump it into our DEV environment to try out check links, and see if that fixes anything.

    ------------------------------
    Mike Bresnan
    Arabella Advisors
    Washington MD
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Stuck payment batch with extra issues?

    GPUG ALL STAR
    Posted 9 days ago
    Hi @Mike Bresnan

    I would wait to run the check links and go into SQL and look to see if they did indeed post.

    Sometimes when a batch 'sticks' it does, indeed, post through to the history/open tables but the last piece of the posting stored procedures deletes the transactions in work.  If they did post through and did not get removed from work then you can just delete them from work BUT ONLY AFTER you verified they posted all the way through to all the relevant tables.

    Otherwise, if this is not the case, if the batch is still in SY00500 then make sure the BCHSTTS is set to where in the process the transactions were before it got stuck, Victoria Yudin has a good full list of the check batch status'​

    ------------------------------
    Jo deRuiter
    🌟 GPUG ALL STAR
    💫Granite Award Winner
    Atlanta Chapter Leader
    Aisling Dynamics Business Solutions
    Business Applications Practice Manager
    jo.deruiter@aislingdynamics.com
    9518674366
    aislingdynamics.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Stuck payment batch with extra issues?

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Hi @Jo deRuiter!

    The payment transactions from this batch are currently in history/paid (PM30200)​, and not in the work tables. They did not post or even generate the GL entries though.

    the batch was in printing status before i flipped it to available. Are you saying i should flip it back before running check links?

    ------------------------------
    Mike Bresnan
    Arabella Advisors
    Washington MD
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Stuck payment batch with extra issues?

    GPUG ALL STAR
    Posted 9 days ago

    Then is it a matter of just deleting the batch header in the SY00500?  Is there any remnant of the batch in the work tables?

     

    Thanks, and with Kindest Regards,

    JO DERUITER

    Business Applications Practice Manager

    Department: Business Applications Leadership Team

    City: 

    Atlanta

    Sate: 

    GA

    Email: jo.deruiter@aislingdynamics.com

     

    This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. This message contains confidential information and is intended only for the individuals named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

     




    Academy - Online Interactive Learning from Experts


  • 5.  RE: Stuck payment batch with extra issues?

    SILVER CONTRIBUTOR
    Posted 9 days ago
    if everything were posted through i'd agree, but nothing hit the GL for these payments at this point. Deleting that batch would pretty much mean that the GL entries would never post, right?

    I'm going to run the Check Links in our DEV environment, once we update it to current, to see what happens, and i will update this thread.

    ------------------------------
    Mike Bresnan
    Arabella Advisors
    Washington MD
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Stuck payment batch with extra issues?

    SILVER CONTRIBUTOR
    Posted 8 days ago
    UPDATE: Check links did nothing.

    I'm wondering if we just need to delete the batch record from SY00500, and manually post a JE to record the cash/payable account activity? they wont be linked together, but that's not the end of the world.

    ------------------------------
    Mike Bresnan
    Arabella Advisors
    Washington MD
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Stuck payment batch with extra issues?

    SILVER CONTRIBUTOR
    Posted 8 days ago
    heard back from our VAR, looks like removing the batch from SY00500 and manually posting the activity in the GL is the way to go.

    definitely not ideal, but what can you do!

    ------------------------------
    Mike Bresnan
    Arabella Advisors
    Washington MD
    ------------------------------

    Academy - Online Interactive Learning from Experts


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