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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Bank Reconciliation St...
Microsoft Dynamics GP (Archived)

Bank Reconciliation Started - If process interrupted use Check Links on CM logical files

(0) ShareShare
ReportReport
Posted on by Mikon 160

Greetings!

One of our system users was performing a bank reconciliation. Apparently it was interrupted (unknown how or why) and we are now seeing the following message:

Reconciliation for this checkbook already has been started. If the process was interrupted use the Check Links window to check links on the CM logical files.

The Reconcile Bank Statements window will not close nor will the GP client. I ran check links on the CM logical files as suggested and it returns no errors and does not fix this condition.

I found a similar KB article (864117) that addresses deposits that have been started and then interrupted, but I do not know if the remedy to what we're seeing will also be similar to the resolution suggested in the KB article.

I also found a question submitted by DKH on this forum that was the same thing, but there wasn't an answer to it.

Does anyone know how to resolve this condition?

Thanks in advance!

Mike

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mikon Profile Picture
    Mikon 160 on at
    Re: Bank Reconciliation Started - If process interrupted use Check Links on CM logical files

    Hi Verone,

    I was able to get through this issue by basically performing the same steps you have listed, just not quite in that order. What I did was:

    1. Had all users exit GP.

    2. Backed up the DYNAMICS and the Company databases.

    3. Viewed the contents of the following tables to verify that all users are logged off:

    DYNAMICS..ACTIVITY, DYNAMICS..SY00800, DYNAMICS..SY00801, TEMPDB..DEX_LOCK, and TEMPDB..DEX_SESSION (these tables should not have any records in them; if any do, clear the stuck records).

    4. Ran Check Links on the Checkbook Master, CM Setup, and CM Transaction logical tables.

    5. Ran the following script against the company database to clear Batch table:

    UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

    Note: Replace 'XXX' with the name of the batch.

    Once cleared, I was able to go back into the system and run the Reconcile Bank Statement process again.

    Thank you very much for your reply!

    Mike

  • Verified answer
    Runbiz Profile Picture
    Runbiz 45 on at
    Re: Bank Reconciliation Started - If process interrupted use Check Links on CM logical files

    I encountered the exact same issue.  I resolved it with the following steps:

    1. Have all users exit GP

    2. Backup the DYNAMICS and the Company databases

    3. Run the following script to delete any hung records in the batch activity table:

            DELETE DYNAMICS..SY00800

    4. Run the following script on the Company database:

             UPDATE CM00100 SET Reconcile_In_Progress = 0 where CHEKBKID = 'XXX'

           Note:  Replace 'XXX' with your Checkbook ID

    5. Run Checklinks on the CM Transaction and Checkbook Master files.

    That solved it for me.  I was able to then successfully complete the bank reconciliation.  I hope that helps.

    Verone

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans