Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Batches exist in SY00500 but not in Master Posting

(0) ShareShare
ReportReport
Posted on by 2

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

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    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 Profile Picture
    Victoria Yudin 22,766 on at
    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 Profile Picture
    Jim Lines 2 on at
    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 Profile Picture
    Jim Lines 2 on at
    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 Profile Picture
    Victoria Yudin 22,766 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans