Removing Companies from SmartConnect Map

  • Removing Companies from SmartConnect Map

    Posted by DSC Communities on December 12, 2016 at 12:21 pm
    • Curtis Cruz

      Member

      December 12, 2016 at 12:21 PM

      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

      Member

      December 12, 2016 at 5:37 PM

      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

      Member

      December 13, 2016 at 10:09 AM

      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

      Member

      December 13, 2016 at 3:47 PM

      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
      ————————————————————————-

    DSC Communities replied 7 years, 4 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Removing Companies from SmartConnect Map’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!