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

Notifications

Announcements

No record found.

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

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    65,271 on at

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

  • Community Member Profile Picture
    on at

    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

    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

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans