I have a General Entry batch with no batch header and no transactions either. I'd like to get rid of it but it won't let me select it. Any help would be appreciated.
*This post is locked for comments
You may get this corrected in one of two ways. Either to run check links for the financial series which will supposedly get rid of such batch, or get on the SQL level in order to delete this record manually as follows;
The script below will retrieve the GL batches with missing header;
SELECT *FROM dbo.GL10001WHERE BACHNUMB NOT IN ( SELECT DISTINCT BACHNUMB FROM dbo.GL10000 )
SELECT * FROM dbo.SY00500 WHERE BACHNUMB = '#BACH NUMBER' -- Enter the batch number within the double quotation
In case you have found any orphan, you may get them deleted manually. Consider the Dex_Row_ID field in order not to miss that specific record. Refer to the following post for further illustration on how to get them deleted;
Checklinks - Created Batch without BatchID
try one of the automated solutions
mbs.microsoft.com/.../automatedsolutionsR10
System
Manager
Cannot Post Batch
Clears the Batch Activity Table (SY00800). If a batch is stuck, this will release the batch for processing.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
