Batches exist in SY00500 but not in Master Posting

(0) Share

Report

Posted on by Jim Lines

Hi, My client is running GP2010 (10.00.1841). I'm doing some reconciling and found several batches in the SY00500 table that do not exist in Master Posting. The 10 batches in question are all AP Check Batches (BCHSOURC = XPM_Cchecks, Series= 4). All modules/transactions are set to POST TO GL only. Anyone have an idea how these batches could be in SY00500, but not in Master Posting? I have not go in depth with any utilities like checklinks yet because I want to make sure I am running them on the correct tables.

Any suggestions on where I should start? Also, any idea what this may impact? These batches were likely used to clean up open payables and then deleted so they did not post to the GL.

History: Company is trying to ween off of Quick Books and get GP once reconciled. This is by no means a standard implementation as they've been running parallel systems for months.

Thanks in advance. Jim

*This post is locked for comments

All responses (5)

Answers (1)

Jim Lines 2 on at

Like (0)

Report

RE: Batches exist in SY00500 but not in Master Posting

Victoria,

Thanks. That is helpful information. I'm able to print/post my check batches and then delete them from master posting as I hoped. I don't need to worry about any checks getting out the door as they are paying through another system at the moment. We're just recording the transactions in GP... you know, the fancy checkbook. LOL.

Thanks again, always appreciate your help!

Jim
Verified answer

Victoria Yudin 22,766 on at

Like (0)

Report

RE: Batches exist in SY00500 but not in Master Posting

Jim,

If the batch is visible in the Edit Payables Checks window, the checks have not been printed yet. If the batch is visible in the Post Payables Checks window, the checks have been printed, but not posted yet. If GP says the status is "Check Printing", then likely something went wrong during the printing and it's now stuck.

With check batches you want to be really careful, one of the worst case scenarios would be that checks actually went out to vendors, but did not get posted and then get deleted (while you cannot do this in the GP user interface, anything is possible in SQL).

If you want to try running check links, you can run check links on the entire Purchasing Series. In my experience, if there are truly stuck check batches, they will not be fixed by check links. I have had to fix check batches directly in SQL a number of times and there is definitely a fine art to it. There is also no one answer to how to do it - it will really depend on the specifics of the situation. If you're not very familiar with all the tables involved, I would recommend a call to GP Support to get some help with this.
Jim Lines 2 on at

Like (0)

Report

RE: Batches exist in SY00500 but not in Master Posting

Quick update to my response: I found the payables batches in the Edit Payables Checks batch.
Jim Lines 2 on at

Like (0)

Report

RE: Batches exist in SY00500 but not in Master Posting

Thanks Victoria!

When I look in the Post Payables Checks screen, only two of those batches exist. And they have a status of "Check Printing" - which they are not.

I did some sampling and found that the payments did not hit the GL, but I'm curious now if the checks were posted in the sub-ledger or not. Could the check batches have been deleted after the checks were applied and printed? All of those checks were indeed applied to invoices.

Is there a checklinks that would correct this if it's truly an issue? I want to avoid running CL on every module/table if possible.

Thanks!

Jim
Suggested answer

Victoria Yudin 22,766 on at

Like (0)

Report

RE: Batches exist in SY00500 but not in Master Posting

Hi Jim,

Computer check batches are considered 'special' and are not listed on the Master Posting window because you cannot interact with them from that window like other batches. They need to be printed and/or posted from their own windows.

You might find the lists of statuses on my blog helpful in determining what is going on with those batches:

victoriayudin.com/.../companysystem-tables