Microsoft Dynamics GP (Archived)

Batch with no Batch ID stuck in Transactions->Financial -> Batches in GP 2010

(0) Share

Report

Posted on by cmsnyder07

155

I have a "batch" hanging out there that I can't open because it has no ID. Can someone help me please?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

MichaelC 1,763 on at

Like (0)

Report

Run the batch reconcile function on your batches. You will find it under Financial > Utilities menu.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
cmsnyder07

You may want to manually update the empty batch-id record. For the financial series, here are the tables to check:

SY00500 table, BACHNUMB field

GL10000 table, BACHNUMB field

GL10001 table, BACHNUMB field

The following scripts will retrieve the records with the empty batch-id field;

SELECT * FROM dbo.GL10000 WHERE [BACHNUMB] = '' SELECT * FROM dbo.GL10001 WHERE [BACHNUMB] = '' SELECT * FROM dbo.SY00500 WHERE BACHNUMB = '']

Once the records are identified, you need to manually updated these records with a specific batch id. You can proceed with posting the batch from the application level.

If you don't have the proper knowledge to handle such update statement, consult your partner. Never forget that the "back up" is a must.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Which module did it originate in, and which module are you trying to open it in?

Assuming you are familiar with SQL, I would recommend taking a look at this article and running the SELECT statements to see if it yields any results.

support.microsoft.com/.../en-us

Between this KB and Mahmoud's scripts you should be good to go.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

If you want to do this within GP I would suggest running Check Links(MS Dynamics GP->Maintenance->Check Links). Run this on all series. Hopefully you will see a line about batch header being recreated. Always do a backup of your company database prior to running check links.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Richard is right - typically the Check Links maintenance routine will create a Check Links batch when run against the financial tables. Just click on series > financial on the left, choose insert all and then click process. Make sure you have a backup before running this process.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

I'm going to second the vote for financial reconcile, but ONLY if it is a GL entry you're trying to find. Otherwise, run checklinks on the 'WORK' transactions of the subsidiary batch.

Kind regards,

Leslie

Was this reply helpful? Yes No