Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payables Problem - pri...
Microsoft Dynamics GP (Archived)

Payables Problem - printed check, but did not post to GL

(0) ShareShare
ReportReport
Posted on by Pam C 572

We have an issue in our Payables area where a voucher was entered, a check printed, but the expense was never distributed to the GL.  All reports show it should be on the GL except for when you look at the GL detail, the transaction is not there.  Our system went down during this process and the batch had to be recovered.  We see a button called "Apply" on the "Payables Transaction Entry Zoom" for that invoice.  The "Distributions" button on that same page shows it was distributed to the correct expense in the GL, but it's not actually on the GL when that account's activity is viewed.  Will the "Apply" button fix that or is there some other way to get it in our GL?

Thanks for your help.

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Payables Problem - printed check, but did not post to GL

    Hi,

    The distributions on the payables transaction merely represent what the payables module is sending up to create the batch in gl. As you are experiencing, it could have been deleted or changed before it posts in gl. The accounts in the payables history never change. Can you follow the transaction through the check register and the payables module? It sounds like you have. Have you looked at the data in the gl20000 (or the10000 tables) using SQL? What I would be looking for is maybe a trx missing the journal entry number or batch ID.

    You could search the database for the audit trail code of the PM transaction. Under normal circumstances, this code would become the batch ID of the gl transaction (if you have selected 'Add new' in posting setup). There is a SQL script available that will search through the whole database for whatever string value you choose.

    Does the transaction show up in the cross reference reports?

    If it's not anywhere to be found, you might be best served by just making a JE to get the GL back in balance with AP, Cash & your expense accounts.

    Kind regards,

    Leslie

  • Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Payables Problem - printed check, but did not post to GL

    Hi Pam,

    Have you already checked the batches in Financial if there is an unposted batch?  If there is, you may just need to post that.

    If there are no batches to be posted, then I suggest voiding the checks (make sure you are not posting through to GL).  Once voided, delete the void batch created in Financial.  

    Afterwards, proceed with re-entering the checks.

    Let me know if you have further questions.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans