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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Ghost Company issue wi...
Microsoft Dynamics GP (Archived)

Ghost Company issue with sa login

(0) ShareShare
ReportReport
Posted on by devinmcm1 582

This problem is not major, but it has been there for a long time and I would love to squash this bug. 

Scenario:

Company upgraded from GP 9.0 to GP 2013

There are multiple companies under a single Dynamics database

Following the upgrade there are two entries in the company listing for the first company when logging in only as sa

If you select the wrong one an error message is received  "The files for this company have not been updated"

Select the second listed company, and it works

Several investigations of the SYS tables and numerous scripts have been tested to clean out orphaned companies, etc. with no luck

There simply is no actual duplicated company, it only shows that way when logging in as SA.

I know I have heard other GP people talk about this, and because it is so minor I guess no one really goes after it, but I was curious if someone had ever actually documented this, or if there is a fix

*This post is locked for comments

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

    Are you using the Multi-Entity Management add-on from Binary Stream?

  • devinmcm1 Profile Picture
    devinmcm1 582 on at

    No, I am not.  This appeared after upgrading from 9.0 to 2013 R2

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    I have seen this happen before. I trust you've checked the SY01500 table in the DYNAMICS database? I had a spare in there and only sa had access to it. Also check the User Access table in the Dynamics database - SY60100. If you do have an extra entry in the SY01500, look across at the INTERID field and make sure you do not have an actual database created. If you find something in the SY01500 table, down load a free copy of APEX SQL Search and search all of your databases for that database name. Also, look in the DB_UPDATE, DU00010, DU00020 and DU00030 tables and see if there is any reference to that company.

    Kind regards,

    Leslie

  • devinmcm1 Profile Picture
    devinmcm1 582 on at

    I wanted to be sure to be clear - this is a valid company.  it is CompanyID 1, lets call it for example,  XYZ Company, lets say there are 10 companies in this database, so when you open the Company lookup box ( as sa user) it looks like this

    XYZ Company

    XYZ Company

    ABC Company

    My Company

    Your Company

    Our Company

    So Company ID 1 is listed Twice, even though it is in SY01500 only once, and when you select the SECOND instance of XYZ Company it says:

    "Files for this company have not been updated"

    This occurs even after a test upgrade from GP 2013R2 to GP 2016R2

    So somewhere there is some record of an unupgraded company, that was already upgraded.  All the tables you mention show this company correctly in one way or another as CompanyID =1  CompanyName = XYZ Company and DBName = XYZDB

    Again, this only happens with sa, but it bothers me that the largest and most important company is somehow corrupted.  I know that somewhere there is an entry in some table that needs to be removed I would imagine, but I don't know where.  For example, the query that returns the list of companies available on the login screen is picking it up twice somehow

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans