Upon launching, a freshly installed Dynamics GP 2010 client was throwing the error: “Microsoft.Dynamics.GP.Rtc.dll: QI for IEnumVARIANT failed on the unmanaged server. ” GP 2013 had previously been installed on this workstation.
The solution was to rename the Microsoft.Dynamics.GP.Rtc.dll file in the Add-ins folder by adding a “.bak” extension. This file is associated with Microsoft Lync and the Shoretel Communicator. If you’re not using those programs, you can safely bypass the file. After renaming, GP ignored the file and launched without error.
Our customer had recently switched over to the Unified Interface for Dynamics 365 Sales. The Quick Create form for Contacts has a nice new feature for scanning a business card, but when they clicked the Scan Business Card button, they got an error: “It looks like AI Builder wasn’t set up correctly. Ask your admin to investigate.”
So I investigated. A Google search turned up a few similar errors but nothing on point. I tested the button with a user who had the System Administrator role, and that worked fine.
Focusing on permissions, I remembered that one of the posts said they had solved the problem by assigning the the Read privilege for the AI Model entity. Another post said that assigning the Common Data Service (CDS) Security Role had resolved it.
I tried assigning the Read privilege for AI Model, but that was not enough. Assigning the CDS Security Role was not appropriate for this user, but I noticed that the CDS role assigns some additional privileges related to the AI Model.
Taking my cue from those assignments, I was able to resolve the error by assigning the following privileges to the user’s security role. You can find them on the security role’s Custom Entities tab.
It was time for year-end payroll updates for Dynamics GP. I had applied the update for v. 18.281036 (KB4528419), and things were going fine until the GP Utilities tried to list the companies to be upgraded. Then everything hung up on this screen. Instead of a list of the companies to be upgraded, I got a dialog box with a gray background containing a single empty checkbox and a Next button.
I didn’t want to be too hasty. Sometimes the utilities might be slow to re-draw a screen, but SQL routines will still be chugging away in the background. I checked Task Manager, and it showed 10% CPU utilization for the task. I checked SQL Profiler, and there was plenty of activity in SQL. The thing was, it looked like the same activity over and over, and after about 90 minutes, I decided it was stuck in an endless loop.
After consulting with colleagues, we found another post that made reference to the Clear Companies script. That jogged my memory. Had I seem a reference to “TWO” in the SQL Profiler trace?
I ran a “Select * from SY01500” SQL query to fetch the list of GP companies, and sure enough, there was a reference to Fabrikam, the GP sample company. But the corresponding database named “TWO” did not exist in our SQL instance.
I ran the Clear Companies script, restored the databases, and tried the update again. This time it ran as expected.
It should be automatic. When you assign a Dynamics 365 Customer Engagement license to one of your users in Active Directory, the system will add the corresponding System User record in Dynamics 365 CE.
Occasionally, this doesn’t happen correctly. We saw this recently when setting up a trial instance for a customer’s CRM. The environment had been created, and the license had been assigned, but the user could not launch Dynamics 365 CE, despite having the Global Administrator role in the Office 365 portal.
The error received was:
You are not a member of this organization
You (email@example.com) do not belong to the organization contoso. Verify the organization name and try to sign in again.
Error Code: notMemberOfOrg
Fortunately, Microsoft has provided a way to force AD to synchronize the user record. This feature was still in Preview at the time of this posting, but it solved our problem. Go to the PowerApps Admin Center in your tenant by clicking on the Admin icon in the Dynamics 365 App Launcher, and then click on All Admin Centers. Click on Power Apps icon to the launch the admin center.
Click on the Environment record to open it.
Click on the Security tab. Enter the email address of the user in the Step 1 box. Click Add User.
A confirmation banner will be displayed as show below. It may take a few minutes for the user to synchronize from AD, but when you click on the “list of users” link, you should see your user record in Dynamics 365 CE. Assign the appropriate security role(s) and carry on.
Our Sharepoint/D365 Sales integration worked great, until one day it didn’t.
When trying to access a document folder, and also when trying to run the “Enable Server-Based SharePoint integration wizard, “we got the following error: “The remote server returned a 401 unauthorized error.”
This was odd, because Sharepoint had previously been configured successfully, and the user had been able to store documents under the entity for many months prior. The solution turned out to be entering the user’s email address on the System User form.
By default, the SharePoint Email Address field is not exposed on the System User main form. You will have to customize the form to expose the field, and then you can populate it.
Once you have customized the form, go to Settings -> Security -> Users. Open the user record, and enter the email address with which the user is logging into Dynamics 365 in the SharePoint Email Address field . Usually, but not always, this is the same address as in the Primary Email field. Save the user record.
Then test access to the Documents folder again. The change should take effect immediately, and you will be back in business.
Recently, we encountered an error in Dynamics 365 Project Service Automation. Whenever the Bookable Resource form was loaded, an undefined error popped up saying there was an error with “this field’s customized event.” However, there was no information on which field the error referenced.
After some investigation, the error was finally traced by Microsoft support to the Legacy Form Rendering setting. Once Legacy Form Rendering was turned off, the error disappeared.
To change this setting, go to Settings -> Administration -> System Settings. On the General Tab, if “Use Legacy Form Rendering” is set to Yes, set it to No.
Migrating Dynamics 365 Sales to a new tenant must be done by Microsoft Support. The first step is to open a support ticket through the Office 365 portal to request the migration. (UPDATE: Microsoft does not yet support tenant-to-tenant migrations for version 9.0 organizations. This is expected to be available in Q2 2019.)
Once they have confirmed the specific information about the source and target tenants, MS Support will ask you to request a date and time for the migration. The date must be at least two days in advance. They will then schedule the specific date and time of the migration.
Microsoft support will need some information from you to validate and perform the migration. At a minimum, be prepared to supply the following. You can save a step by including it in the initial support request:
Are the Source tenant and Destination tenant in different Regions (NA, APAC, EMEA)? If so, then indicate the region of both the source and target tenants.
Is Voice of the Customer installed in either organization?
For each organization, what is the:
Unique organization name
The URL is the same one you use to log in, typically <YourOrg>.crm. dynamics.com. You can find the Organization Name and ID by going to Settings -> Customizations -> Developer Resources -> Instant Reference Information.
In Dynamics GP, the following message came up when I tried to calculate the VAT report: “The input tax for this range hasn’t been entered. Do you want to continue calculating?”
To fix the error, I ran the following SQL script against the company database to find earliest transaction date on the return:
selectmin(Docdate) from TX30000 where Included_On_Return = 0
I found that the effective date needed to be set back to 30 Nov 2017 so that it pre-dated the earliest date included on the return. It appears that the VAT return was not run for Dec. 2017, so I ran it for both Dec. 2017 and Jan. 2018, and it completed without errors.
Relevance search uses Azure to index your CRM data. This means that you are exposing the data to a service external to your CRM instance, so you need to take that into account before you enable Relevance Search. You may have entities and fields that you do NOT want to expose this way because they contain confidential information.
“We strongly recommend that you configure the entities and entity fields participating in Relevance Search before you enable the search, to prevent sensitive data from being indexed in a service external to Microsoft Dynamics 365 (online). “
On a global basis, Relevance Search is enabled in System Settings. The user selects it in Personal Options -> General -> Search Experience.