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
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
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.
Quick update to my response: I found the payables batches in the Edit Payables Checks batch.
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
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:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156