Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

bank reconciliation

Posted on by 105

Brand new implementation of GP - First Payroll run was successful. The checkbook was updated, the inquiry window and check register show transactions (summary direct deposit earnings transactions). The checkbook balance is correctly displaying on the checkbook maintenance window.

When we open the Reconcile Bank Statements window, enter the month end (01/31/2011) for both cut-off dates, then click transactions, we would expect it to display these four transactions so we can clear them from the bank statement.

No transactions display. Nothing displays in this window.

We have entered test BANK TRANSACTIONS - a check, withdrawal, deposit, etc. None of them show up in this window.

There are transactions in the CM20200 table.

There is a bank rec record in the CM20500 table because I saved the bank reconciliation.

I've run checklinks on the entire financial series.

If anyone has any additional suggestions, please please send them my way. Microsoft is looking into this now, but we're stuck without being able to reconcile the transactions.

Additional info, not that it should matter because I've disabled ALL 3rd party products and still get no results:

The following are installed in this environment:

Binary Stream Multi-Facility

Wennsoft Job Cost

eReconcile is NOT INSTALLED.

 

 

*This post is locked for comments

  • Re: bank reconciliation

    Which version of GP are you running? Is this Bank Reconciliation or Cash Book Bank Management? If it is Cashbook Bank Management, ensure that the 'Use ANSI......' options in the ODBC configuration are unchecked.

    Patrick

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: bank reconciliation

    Check if the transactions are already reconciled in Checkbook Register Inquiry.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans