General Entry Batch – Stuck?

  • General Entry Batch – Stuck?

    Posted by gregory-cara on November 14, 2019 at 4:29 pm
    • Cara Gregory

      Member

      November 14, 2019 at 4: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
      ——————————

    • Gerald Buenafe

      Member

      November 14, 2019 at 5: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
      ——————————
      ——————————————-

    • Cara Gregory

      Member

      November 15, 2019 at 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
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      November 15, 2019 at 1:38 PM

      ,

      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
      ——————————
      ——————————————-

    • Cara Gregory

      Member

      November 15, 2019 at 1: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
      ——————————
      ——————————————-

    • Beat Bucher

      Member

      November 18, 2019 at 11:22 AM

      Hi
      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 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
      ——————————
      ——————————————-

    gregory-cara replied 5 years, 3 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘General Entry Batch – Stuck?’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!