Open Forum

Expand all | Collapse all

General Entry Batch - Stuck?

  • 1.  General Entry Batch - Stuck?

    SILVER CONTRIBUTOR
    Posted Nov 14, 2019 04:29 PM
    Hello,

    I'm hoping someone might know a way to get rid of a General Entry Batch. We have a batch that shows it has no transactions in it (it has no Batch ID). When you click on the batch, a message pops up that says "Please select a record first."

    We have tried batch recovery but it doesn't seem like there's a batch to recover.

    Is there a way to delete this batch? We are using GP 2016.

    Thank you in advance!
    GP Batch Hanging Up
    GP Batch Hung Up


    ------------------------------
    Cara Gregory
    Accountant
    Alvarado Management Company
    Albuquerque NM
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: General Entry Batch - Stuck?

    TOP CONTRIBUTOR
    Posted Nov 14, 2019 05:04 PM
    Hi Cara,

    That looks like a damaged record. It has a blank Batch ID...
    Since it does say 'No Transactions', an option would be to assign a value for Batch ID (should be in ALL CAPS; via SQL), then have it deleted in GP.


    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: General Entry Batch - Stuck?

    SILVER CONTRIBUTOR
    Posted Nov 15, 2019 10:13 AM
    Thank you Gerald. I'm not sure how to assign the Batch ID in SQL but I'll forward the info to our IT people to see if they can assist me. Thank you for heading me in the right direction.

    Cara

    ------------------------------
    Cara Gregory
    Accountant
    Alvarado Management Company
    Albuquerque NM
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: General Entry Batch - Stuck?

    GPUG ALL STAR
    Posted Nov 15, 2019 01:38 PM
    @Cara Gregory,

    For your IT guys, they can update the Batch record in your company SY00500 table (whatever the SQL database name is for "SANDIA PEAK UTILITY COMPANY"). The recommended practice is to ensure that all the GP users have logged out. Then in SQL Server Management Studio, log into the GP Server:

    USE <companyDatabaseName>
    GO
    --First locate any batches with blank Batch Numbers
    SELECT *
    FROM SY00500
    WHERE BACHNUMB = '';

    --Then, if there *IS* one record, MAKE SURE EVERYONE IS OUT OF GP... and run this UPDATE.
    --If there are more than one, we have a different problem!
    UPDATE SY00500​
    SET BACHNUMB = 'DELETE_ME'   -- Nothing magical about "DELETE_ME"... it's just an obvious marker.
    WHERE BACHNUMB = '';

    Then you ought to be able to select the batch from the Batch IDs list in GP and delete it in the Batch Entry window.

    Sincerely,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List as of 12-Nov-2019
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: General Entry Batch - Stuck?

    SILVER CONTRIBUTOR
    Posted Nov 15, 2019 01:48 PM
    Thank you so much! That's good info that I'm going to keep for the future.

    Our IT person was able to log into our SQL server and delete the batch in the SQL tables.

    I always learn something when I ask a question; everyone here is a great resource!

    Cara

    ------------------------------
    Cara Gregory
    Accountant
    Alvarado Management Company
    Albuquerque NM
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: General Entry Batch - Stuck?

    GPUG ALL STAR
    Posted Nov 18, 2019 11:22 AM
    Hi @Cara Gregory
    In case you want the official KB document from Microsoft, and keep it for your IT staff :-)
    https://support.microsoft.com/en-us/help/850289/a-batch-is-held-in-the-posting-receiving-busy-marked-locked-or-edited

    As @Steve Erbach pointed out, make sure all users are out of GP (to avoid deleting entries that are actually in use) and take a full backup of your DYNAMICS and Company DB, just to be safe.​​

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Academy - Online Interactive Learning from Experts


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