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) / Missing Table or Not M...
Microsoft Dynamics GP (Archived)

Missing Table or Not Missing

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

We are encountering an error that suggests that the 

CM_DepRcpt_RGLCash_LINE_TEMP

table is missing from the Company database.  This table is the CM00001 table and it has a defined content of 17 columns as outlined here www.gptablereference.com/.../CM00001 (link is no longer valid - BC20200821)  NOTE a replacement can be found here --> https://gptables.azurecurve.co.uk/products/microsoft-dynamics-gp-0/financial/cm-deprcpt-rglcash-line-temp-cm00001/  Thanks to Ian at Azurecurve for posting this information.

However, when I attempt to look into the content on my clients SQL databases, I can not find the table.  It claims to be a member of the FInance Series and should reside in the XXXX COmpany database.  It does not in my case.

What has brought me here is that we are getting a message that this table or the path to this table is missing when we attempt to POST a Bank Deposit.

We get the following errors:

Bank_5F00_Entry_5F00_Posting_5F00_Error_5F00_1.GIF

Bank_5F00_Entry_5F00_Posting_5F00_Error_5F00_2.GIF

Bank_5F00_Entry_5F00_Posting_5F00_BankID_5F00_Error_5F00_3.GIF

Checkbook ID does not go away and is still valid, regardless of this comment.

Bank_5F00_Entry_5F00_Posting_5F00_Return_5F00_Error_5F00_4.GIF

So following this thru, we do the checklinks and nothing changes.

Client exits the system and all other users stay logged into the system.  When the same user returns, they tell me that this user can then start to do a Bank Deposit and not encounter an error. 

So, a couple of questions

1 - if the CM00001 is really a TEMP table, then why does it have content we are told to look for.  If it is a temp, how / when is it created and what might be wrong in that process?

2. If the user gets these errors, attempts to run Checklinks on the tabels as directed and nothing changes.  Does loging off and back on again appear to be the correct and or expected response from the system.

NOTE : This started after the update to GP2013 that this client put off until Mid August - slow to adopt or adapt to change.

*This post is locked for comments

I have the same question (0)
  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Missing Table or Not Missing

    Update - yesterday - the client was apparently able to complete a Bank Deposit after completing the process defined above.  However this morning when the client started to build a Bank Deposit he encountered the same error messages as reported above.

    Just updating the thread.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Missing Table or Not Missing

    Hello Bill,

    Researching our case history for this 'CM_DepRcpt_RGLCash_LINE_TEMP' error message, I found a handful of cases that mention it. What we've found is the cause are:

    >>The deposit for the checkbook had already been started. Since the process was interrupted, they used Check Links to check links for the CM logical files.

    >>eConnect, Integration Manager or other integration applications such as Scribe bringing in invalid data, causing the error.

    >>Issues with Temp tables being dropped, where, after having all users logout of the system, stop and re-start the SQL Server service, freeing up resources in the TEMPDB database where temp objects for Dynamics GP are held, then have users log back into the GP application and try and re-create this error.

    >>Another case ran the following scripts before restarting SQL:

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

    I would try these and see if it resolves this error or not.

    Thanks,

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Missing Table or Not Missing

    Thanks Derek,  I will arrange time with the client tonight to test this and will report back as soon as I have compeleted the tasks.

    We have Management Reporter and Integration Manager running - however we have had this configuration for years and this is the first time we have encountered these issues.

    I did a Stop/Restart of the SQL Server over the weekend, but did not delete the content of the tables as identified above.  That is what I will do tonight.

    Again, thanks for your time.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Missing Table or Not Missing

    Derek AlbaughI know this is old, but can you PM me to discuss off line.

    Seems like there is a temp table that is not a temp table and it is not always available as suggested by the error message.

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Missing Table or Not Missing

    To add to this, the CM00001 table is the 'CM_DepRcpt_RGLCash_LINE_TEMP' table being referenced in the log files.

    This table is only populated when doing work in the windows and it gets dropped when finished, thus it's really a temp table in a sense, just not in the same sense as the temporary tables that begin with # or ## that Dynamics GP also uses.

    This is most likely why you probably can't see it in the company database all the time, when you look for it.

    Thanks

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Missing Table or Not Missing

    If I follow, then when I open the Bank Deposits transaction window, and I select the checkbook, and the deposit ID is entered, then I should be able to find that table in the Company Tables list?

    Update - when I save the Deposit - the message is displayed, but I can now see a record in the Deposit Number lookup - which I could not before

    However, I do not have access or see any CM00001 table - I will be working with the client on two machines in the morning and will update from there.

    Thanks.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Missing Table or Not Missing

    Derek it has been over a month since the last time the client encountered this problem - so this morning the same error occurred.  The client has done a number of bank deposits since we last posted.

    I know what the fix is - edit the CM00100 table and remove the value from the Deposit in Process - ensure that the user ID that first generated the error is logged out of GP - then clean the table - go into application and in the Checkbook Maintenance make sure that the next Deposit number is the same as the value removed from the CM00100 table - open Bank Deposit, select the checkbook, and it should open the and display the next deposit number.

    All well and good to know how to fix - however, what my client is asking for - after fixing this now for the third time - what is causing this?  what can we do to resolve this on a permanent basis?

    Thanks in advance for your time and attention to this matter.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Missing Table or Not Missing

    Hello all,

    Just another update to this matter.

    It has been many months since this error has happened and we still have little knowledge of what is causing it.

    The fix has not changed - edit (in SQL) the CM00100 and remove the value from the Deposit_In_Progress field.

    This allows the client to continue work on the system with no further errors.  

    What we need to know is how to figure out what is causing this error.  Anyone have any ideas?

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Missing Table or Not Missing

    Hi Bill,

    I'd install GP Power Tools and create a trigger that starts a DEXSQL Trace every time someone opens the Bank Deposit form to enter a transaction.. This way you might be able to figure out what's causing the vanishing of the CM00001 table.. David Musgrave might be able to assist with that. 

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Missing Table or Not Missing

    Beat from what I have worked on over the past number of months, I have learned that the CM00001 table is as Derek explains - it is a temp table by action - but not by name.

    My real problem has to do with the Deposit_In_Progress field in the CM00100 table.  After the client has created a bank deposit - does data entry and saved the work - it is when he comes back into the system to resume work we encounter the error.

    When we edit the CM00100 table - zero out the Deposit_In_Progress field - the bank deposit window is open and the user can complete.

    I like the idea of using GP Power Tools - but will need some assistance - I will see what we can do here and reach out as needed.

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

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…

Congratulations to the September 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