General Entry Batch – Stuck?
-
General Entry Batch – Stuck?
Posted by gregory-cara on 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!
——————————
Cara Gregory
Accountant
Alvarado Management Company
Albuquerque NM
—————————— -
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
——————————
——————————————- -
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
MemberNovember 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
——————————
——————————————- -
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
MemberNovember 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-editedAs 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)
——————————
——————————————-
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.