Batch with no batch header

(0) Share

Report

Posted on by COWS

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

All responses (2)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Batch with no batch header

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.GL10001
WHERE 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
Suggested answer

Ian Richardson 4,150 on at

Like (0)

Report

RE: Batch with no batch header

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.