Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Can not find table message

Posted on by 85

When I am in Dynamics, I try to enter a Cash receipt and I get the message;

"A get/change operation on table SY_Current_Activity cannot find the table"

Why is this showing up and how can I fix it.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Can not find table message

    Hi guys,

    I am having the same issue but in test company.  Table was missing in the test company (TWO database).  I have added the table but am still getting the error.

    Thanks

    Mandeep

  • Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    Re: Can not find table message

    Hi Edward,

    This is happening to one workstation only?

    If the previous recommendations does not work, I recommend -re-creating the ODBC connections for that workstation.  Refer to the link below:

    mbs.microsoft.com/.../mdgp_howto_setup_odbc.htm

    Let me know how this goes.

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Can not find table message

    To add to Victoria and Jonathan, I would also delete local temp files as well.  

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • Re: Can not find table message

    I agree with Victoria. Try to reconnect to GP and if you get the error again make sure the Activity table in the Dynamics database exists.

    Thanks

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Can not find table message

    Sounds like you may have lost connection to the GP server.  I would recommend exiting GP and logging back in.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans