Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AP Checks Stuck in GL ...
Microsoft Dynamics GP (Archived)

AP Checks Stuck in GL Posting Batches

(0) ShareShare
ReportReport
Posted on by Seneschal 370

Hi, I'm new to GP, currently using 10.0 (was using ACCPAC/SBT and Oracle 11i at last company).  

When we were closing our books for the month, we noticed that many of the AP checks are posted in the AP check register (all batches have been posted), but missing from our GL trial balance.  After some checking, they were in the GL as pending batches to be posted.  After we manually post them to GL they appear correctly.

My question is if this is normal?  Is it because we didn't have the period open in GL, but AP is open (we noticed that most of these batches were generated toward the beginning of the month, maybe we didn't open the month in time?).  If we open the month to GL posting, would we be able to avoid these unposted batches later? Also, are there error messages that would have indicated this problem?  We checked with the AP clerks who posted the AP batches and they said there were no errors when posting.

Thanks for your help!

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: AP Checks Stuck in GL Posting Batches

    If A/P is open and GL is closed, and you are posting by batch and not using Quick Checks, then the GL transaction generating by posting your AP batch will not post. It will not post to a closed period. I don't know what they mean by 'stuck' in the queue. The Batch Recovery Window is where my batches get 'stuck' when this kind of thing happens. However it's called, for sure your A/P checks will not post through GL if the GL period is closed when you post the AP checks.

    Kind regards,

    Leslie

  • Seneschal Profile Picture
    Seneschal 370 on at
    Re: AP Checks Stuck in GL Posting Batches
    I've also noticed this in other cases, not related to checks. Normally, if both AP and GL are open, postings in AP would get posted in GL as well. Our IT's theory is that if GL is closed, AP postings would still flow through but stay in the batch queue on GL. We would have to manually open the JE from the queue to manually post them. What's been happening is that in the past couple months we have opened AP without GL for the period and that's why the GL postings are "stuck" in the queue. Does this make sense? Thank you.
  • Seneschal Profile Picture
    Seneschal 370 on at
    Re: Re: Re: Re: AP Checks Stuck in GL Posting Batches

    Hmm...  Maybe someone did, but nobody owns up to it now.

    Yes, it is a batch of AP checks, not from Payables Trx entry.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: AP Checks Stuck in GL Posting Batches

    If the GL period was closed when the AP checks were printed, the batch would have normally ended up in batch recovery. Did someone take it out of batch recovery?

    This was a batch of AP checks, not a check printed from Payables Trx entry, yes?

    Kind regards,

    Leslie

  • Seneschal Profile Picture
    Seneschal 370 on at
    Re: Re: AP Checks Stuck in GL Posting Batches

     Hi Leslie:

    Thanks for your reply.  I checked and yes, both check boxes were checked for that screen (Purchasing/Computer Checks).  It should have posted straight through to GL. 

    So we were guessing maybe AP was open for posting for that period (May) but GL was not opened yet for posting, causing the batch to be posted in the AP system but stayed in the batch queue in GL.  Do you think that's possible?  Or did we do something else wrong?

    Thanks.

     

     


  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: AP Checks Stuck in GL Posting Batches

    Hi Seneschal,

    There is a checkbox in the posting setup that will instruct the system to automatically post your AP checks to the GL. I'm guessing that this is why they didn't post. Navigate to Microsoft Dynamics GP >> Tools >> Setup >> Posting >> Posting. This will open the Posting Setup window.

    Select the Series as Purchasing and the Origin as Computer Checks. In the upper left-hand corner you will see two check boxes. Post to General Ledger, which is checked and Post Through General Ledger Files, which I'm guessing is not checked. You need to check the second box if you want your AP checks to automatically post and update the GL.

    Kind regards,

    Leslie

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