Seeing same company manytimes in Company Log in 1

[klewis10367]

When I log into Great Plains and select my company I am seeing it many times. I am on Version 9 SP2. Any ideas why? This is a restore from a backup.

 

[RobertC22]

You have entries in the User Company Access table that refer to Company IDs that are no longer present in the Company table.

Here is a script to remove the orphan records from the table so you do not get the repeating entries in the company selection window.

/* -------- start t-sql -------- */

use DYNAMICS

/* show the records to be deleted */

select CMPANYID, USERID
from SY60100 UA left join SY01500 C on UA.CMPANYID = C.CMPANYID
where C.CMPANYID is null


/* remove them!! */

delete 
from SY60100 UA left join SY01500 C on UA.CMPANYID = C.CMPANYID
where C.CMPANYID is null


/* -------- end t-sql -------- */

------
Robert