Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Curtis Cruz]

Hi,

I have several SmartConnect Maps that contain old GP companies that we no longer use.

I would like to remove these companies from the list that is setup in all SmartConnect Maps listed in the Companies window when selecting the Companies button (image attached).

Upon selecting the Delete button and removing the unwanted Companies (selected in red) and saving the Map, the list of companies re-appear.

How can I get rid of the unwanted companies once and for all?

——————————
Curtis Cruz
Database Administrator
Apex Healthcare Partners LLC
Montebello NY
——————————

[Steve Burney]

Hello Curtis,

Check out the SmartConnect Security settings for your account and make sure that everything under the Permissions tab is what it needs to be for you to have the power that you need.

Steve

——————————
Steve Burney
Senior Financial Systems Administrator
Correct Care Solutions
Nashville, TN United States
sburney@correctcaresolutions.com
615-312-7272
Twitter @SteveBurney
————————————————————————-

[Nicole Albertson]

Curtis,

When SmartConnect pulls the company list, it uses the following script.

select rtrim(CMPNYNAM) as CMPNYNAM, rtrim(INTERID) as INTERID ,@@SERVERNAME as INSTANCE from [DYNAMICS].[dbo].[SY01500]

If the SY01500 table in your Dynamics database has these companies in it, it will pull them back into the SmartConnect company list. If they are still in this table and you don’t use them in GP any longer, you will want to remove the companies from Microsoft Dynamics GP. 

There really isn’t a way to exclude a company from SmartConnect if it is in Microsoft Dynamics GP.

Hope this helps, but let us know if you have further questions.

——————————
Nicole Albertson
Product Specialist
eOne Solutions
Fargo ND
————————————————————————-

[Curtis Cruz]

Thank you so much! this helped!!

Removing the company databases from SQL and running the ClearCompanies.sql script found on Customer Source, you can remove the company databases from SQL and run the ClearCompanies script to remove all references to deleted companies from all GP tables included in the SY01500.

I then went into SmartConnect and Deleted the companies and saved the map and this worked!!

Because I have 50 SmartConnect Maps and 10 GP companies of which I needed to open each Map and manually delete 5 companies and save the map, I found the tables in SmartConnect that had the datasources and Companies in the maps referencing the old companies.

By deleting the records in the SmartConnect.dbo.TenantBase table referencing the old companies and as well the [SmartConnect].[dbo].[MsGpTenant] records pointing to old companies, I was left with only the companies which exist in the SY01500 table located in the DYNAMICS database. To be successful, you need to remove the records in the MsGpTenant table first since these records are foreign keys to the records in the TenantBase table.

Thank you all for your help and a special thanks to Nicole Albertson for pointing me in the right direction.

Curtis

——————————
Curtis Cruz
Database Administrator
Apex Healthcare Partners LLC
Montebello NY
————————————————————————-