web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

bank reconciliation

(0) ShareShare
ReportReport
Posted on by 107

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

I have the same question (0)
  • Community Member Profile Picture
    on at
    Re: bank reconciliation

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

  • Patrick Wachira Profile Picture
    on at
    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans