- Employee ID / Company
- Salesperson ID / Company
- Manager / Company
- Vendor ID / Company
- Customer ID / Company
Note In Great Plains, the MbfRoleUser table is located in the Dynamics database. In Dynamics SL, the MbfRoleUser table is located in the system database.
- Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
- Find the ID of the Business Portal user. To do this, paste the following statement in Query Analyzer, and then click the green arrow button.Note Replace XXX with the actual name of the user in Business Portal. The statement returns output that is similar to the following:
select ID, Name from MbfUser where Name = 'UserName'ID = 22723F13-9A89-4401-AF75-0988D09787BD
Name = Pilar Ackerman
- Find the advanced roles to which the Business Portal user is assigned. To do this, run the following statement in Query Analyzer.The statement returns the following:
select UserID, Constituent from MbfRoleUser where UserID = '22723F13-9A89-4401-AF75-0988D09787BD'UserID = 22723F13-9A89-4401-AF75-0988D09787BDNote The Constituent row lists the invalid user records.
Constituent <entityKey><Microsoft.Dynamics.Common.Company.Company ID="-1" /><Microsoft.Dynamics.Hrm.Entity.Employee ID="BARR0001" /></entityKey>
- Remove the invalid user record. To do this, make a backup of the database, and then run the following statement in Query Analyzer.Note Replace BARR0001 with the Constituent value returned in step 4.
delete MbfRoleUser where Constituent like '%BARR0001%'
Steps to reproduce the problem
- Start Business Portal.
- Click Site Settings, point to Users and Permissions, and then click Manage Business Portal Users.
- Click a user, and then click Modify in the Advanced Roles area.
- Assign the user to the Employee/Company advanced role and assign a specific employee. To do this, follow these steps:
- Click the Role/Company list.
- Click Employee/Your Company.
- Click an Employee Id in the Alias ID list.
- Click OK.
- Start Great Plains.
- Click Tools, point to Setup, point to System, and then click Company.
- Click the lookup glass, click the company that you specified in step 4, click OK, and then click Delete.
- In Business Portal, click Site Settings, point to Users and Permissions, and then click Manage Business Portal Users.
- Click the user whom you clicked in step 3.
Id. de artículo: 906719 - Última revisión: 2 jul. 2013 - Revisión: 1