Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

AP transactions not posting to Bank.

Posted on by 55

Since we upgraded to GP 13, we have had a bank reconciliation issue.  It appears that some of our AP transactions are posting to the bank account and some are not.  It has continued to create an issue each month.  Before we upgraded, we never had this issue.  Is there a new setting that we are missing on any of the modules (GL, Banking, AP) that would create this issue.  Soon after upgrading we created new GL accounts.  My concern is that we missed something in the set up of either the accounts or the system.  

*This post is locked for comments

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: AP transactions not posting to Bank.

    A few questions:

    - When you say not posting to the bank account, are you referring to the Bank Reconciliation screen or the GL Control Account?

    - The new accounts you created - were they related in any way to the bank?  

    - Do you have any third party modules that impact AP or GL?

    As long as the correct Checkbook ID is selected on AP transactions, they should appear in the bank reconciliation screen.  You can run into issues with reconciling to the GL if the Checkbook ID does not have a unique GL Account (i.e. more than one GL control account for the checkbook).  I have also run into issues in the past with reconciling the Checkbook to the GL where users had "overwritten" the bank control account at a transaction level.

    Only other suggestions would be to try a check links on all your setup tables (after ensuring you have a recoverable back up).

    Cheers

    Heather

  • soma Profile Picture
    soma 24,406 on at
    RE: AP transactions not posting to Bank.

    Have you checked your Posting Accounts setup? I think this is not related to GP upgrade.

    It's sounds like a manual distribution entry problem (with/without bank account number) on while entering AP transactions.

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