Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payables batch didn...
Microsoft Dynamics GP (Archived)

Payables batch didn't post through the GL

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Why would a payables batch not post all the way through the GL, aside from being set to post to rather than post through? The system is set to post through the GL and we can only post batches in the sub-ledgers, we can not post individual transactions. This has happened a few times and I am wondering what would cause it to happen. There are no errors in the batch (accounts are active, correct accounts used, transactions balance), so we are able to post it in financials. It just gets stuck there for some reason. I'd like to know if this is just a glitch or something we can avoid happening in the future.

Thanks,

Kelly

*This post is locked for comments

  • Rich W Profile Picture
    Rich W 25 on at
    RE: Payables batch didn't post through the GL

    I see this is a really old question now but today we had a problem where the Payables batch wouldn't post.  No errors displayed.  It seemed to finish okay but no report came up.  Nothing in the GL.

    Another user at around the same time was getting a message saying "Unable to Generate a voucher number"

    As it turns out, it was fortunate that this was reported at around the same time. When comparing the next voucher number in Payables Setup Options to the largest voucher number used in our database, it was way out of sync.

    Reseting the Next Voucher Number to one larger than the largest corrected all the issues we were having.

    I'm guessing then that the process of Posting the Payables Batch must create vouchers and it could not.

    So, use this query to find the biggest voucher number used in the system:

    select max (CNTRLNUM) from PM00400 where CNTRLTYP = 0

    and then go to:

    Tools->Setup->Purchasing->Payables

    Click options and update the Next Voucher number to be one bigger than what the query returns.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Payables batch didn't post through the GL

    Kelly have a look at the security of the user that this happens to - if there is a single user you can identify - if they don't have Finanical Posting then that might be the issue.

    Another issue that you may encounter could be related to process overload - if you have multiple batches hitting the GL at one time, I am wondering if it is possible that some of the post automatically while others don't make it?

    More of a couple of questions rather than answers, but, have to start thinking outside the box to get to the bottom of this.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payables batch didn't post through the GL

    Like I said, the set up appears to be correct and it does not happen all the time. We only enter and post payables transactions one way.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Payables batch didn't post through the GL

    Hi Kelly,

    Have you checked the posting window by selecting origin( select the type of transactions you are posting on payable) on posting setup window and see post through general ledger files is ticked.

    Administration >> Setup >> Posting >> Posting

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans