BATCH DOES NOT APPEAR IN SY00500 TABLE

(0) Share

Report

Posted on by Community Member

Hi all -

We got a batch in GL that's stuck in a receiving status. I was going to clear it from that status to make it available, but it does NOT show in the SY00500 table! It shows in the transaction entry look up screen but when you try to select it, it says "this batch is receiving transactions". How can I get rid of it if I can't access it or see it in SY00500? The transaction originated from a bank rec adjustment entry.

Any input would be greatly appreciated!

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

What is the batch number you are looking for?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi -

batch id is CMADJ00004132. So you can see from the TRXSOURC "CMADJ" that it originated from a reconcile bank statement.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

This link contains a stored procedure spSearchOnAllDB. That will help you find every table that contains that batch id.

blogs.msdn.microsoft.com/.../spsearchonalldb-sql-stored-procedure-to-search-an-entire-database

It might take it a little while to run if you have a big DB so be patient. I'm not sure which table it might be on, but this will tell you everywhere it is and what column it's in.

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

Like (1)

Report
Copy link

Link copied!

Have you run the checklinks routine on the transaction tables? Check links will look at each of the transactions and create a record in the SY00500 table if a batch ID exists in any of the transactions but not in the SY00500

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

Justin Sutton Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Diop,

Leslie is correct with her recommendation to run Check Links against the financial series.

This should allow you to run through the stuck batch KB to resolve the rest of the issue.

Please let me know if you have any additional questions on this.

Justin Sutton

------------------------------------------------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------------------------------------------------

**This posting is provided 'AS IS' with no warranties and confers no rights.**

Was this reply helpful? Yes No
Mick Egan 3,561 on at

Like (0)

Report
Copy link

Link copied!

Diop,

For a Reconcile Batch, these are generated when adjustments are made in the Reconcile process.

A Receiving Transaction Status would indicate the Batch had a BCHSTTUS = 3 in the SY00500 Table, but as doesn't exist is strange.

As a Check Links was already recommended by Leslie, then Reconcile Batches is the next step.

I would try Reconciling Batches in the Financial >> Utilities >> Reconcile >> Batches.

This generally will recreate the batch in the SY00500 Table.

As always a Test is best in these circumstances before a Live run.

Regards,

Mick

Was this reply helpful? Yes No