Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Bank Reconciliation

(1) ShareShare
ReportReport
Posted on by

We've come across an issue with reconciling the bank for the 01/06/2017. There are numerous deposits and increase adjustments that are not appearing in the "reconcile bank statement" window. However when I look in the "chequebook balance enquiry" window they are there. Could someone please let me know why this could happen and how to get these transactios appearing in the reconcile bank window.

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    65,271 on at
    RE: Bank Reconciliation

    Hi,

    You will need to connect to the database via SQL server in order to see the raw data in the files. However, you can go to the Bank Transactions SmartList and add the Reconciled column to your list to see if the item has been included in a previous reconciliation.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    on at
    RE: Bank Reconciliation

    I don't think they could have been reconciled as there are many other transactions for that day and wouldn't tie back to the statement balance. Then again anything could happen in GP.

    However how do I access the CM30000 files. Where are they located?

  • Suggested answer
    L Vail Profile Picture
    65,271 on at
    RE: Bank Reconciliation

    Could they perhaps already be reconciled? Check the CM30000 files to see if the missing transactions are in there.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans