Integrate Companies House SIC Codes with Dynamics 365

5 minutes reading time

Integrate Companies House SIC Codes with Dynamics 365

SIC codes might seem like another box to complete, but this data improves segmentation, analysis and planning.

Tracking these company codes in Microsoft Dynamics 365 and Power Apps could help you to identify new opportunities, evaluate risks, and enable granular reporting.

However, managing UK Standard Industrial Classification (SIC) codes poses several challenges for businesses and end-users.

Firstly, assigning SIC codes typically involves manually searching Companies House or checking code lists to find the appropriate classification. Also, the UK government last updated the SIC code system in 2007, leaving it outdated for many modern industries and business activities. As a result, the SIC lookup process can often prove time-consuming.

ServerSys has developed a solution that makes SIC code management quick and hassle-free. Our integration will save you time, reduce errors and ensure data accuracy.

Enhanced SIC Code Data Entry

Here’s how we can make SIC code management more efficient for you:

Instant Accuracy: Our solution pulls registered SICs and descriptions directly from Companies House, eliminating manual searches.

Seamless Integration: We’ve got you covered whether you’re using Dynamics 365 or Power Apps. Our integration populates SIC code fields across your Accounts and other relevant tables. The result? Consistently accurate company data without the extra effort.

Flexible and Customisable: This solution handles scenarios where companies have registered multiple SICs. Plus, you can control the SIC description detail displayed to tailor the information to your specific needs.

How it Works

Enter a company name, and our solution checks Companies House to list potential matches.

Companies House integration for Dynamics 365 to match companies and popular SIC codes

By default, the top 50 most relevant companies are listed, but these results can be customised to show as many as 100 or as few as 10.

We’ve built this feature to connect with Companies House using a Power Apps Component Framework (PCF) control. Our system uses the Companies House API, which supports up to 600 searches every 5 minutes.

Select the appropriate company from the list to automatically populate the registered company number field.

Once this is confirmed, additional SIC code and SIC description fields are displayed. A filtered entry for the selected company is displayed within the SIC code field.

Quickly select registered SIC code for each matched company

Multiple SIC Codes per Company

Many companies have a single SIC code, but some may have up to four. For these scenarios, the end user can select the most appropriate entry. Alternatively, this PCF control can be configured to allow multiple selections.

Select SIC code from registered SICs for each company

SIC Descriptions and Segmentation

When the SIC is confirmed, the associated description field is automatically populated with these details. If multiple codes match, this can be adapted.

With over 600 available SIC codes, company segmentation may be more effective at a higher level. The 5-digit SIC is the most detailed level in the SIC 2007 hierarchy, but its 21 sections are the broadest.

In the example below, the SIC description is populated using the related broad SIC section instead of the code description. This allows section data to be used for meaningful segmentation and insightful reporting.

Popular SIC Section Description Detail in Dynamics 365

Unmatched SICs

Sometimes, an SIC code can’t be matched. This can occur for Limited Liability Partnerships (LLPs), non-trading companies, and UK-based overseas companies that aren’t required to provide SIC codes. In these instances, the solution will match the company number and return an unknown SIC code status.

Unmatched SIC code in Dynamics 365

Benefits for Your Business

Here’s how our integrated SIC code solution for Dynamics 365 and Power Apps can deliver advantages for your business:

  • Save Time – Cut through the complexity of SIC codes.
  • Enhanced Decision-Making – Access accurate industry classifications from Companies House.
  • Improved Customer Targeting – Better understand your customers’ industries using precise SIC information.
  • Consistent Data – Maintain uniform SIC information across your systems.
  • Simplified Compliance – Stay on top of regulatory requirements easily with accurate SIC data.

Transform Your SIC Data Management

Ready to improve your SIC tracking? We’re here to help you.

Here’s how to get started:

  • Contact us to book a demo
  • Discuss your requirements
  • Explore a customised implementation

Please get in touch. Our team is ready to answer your questions and guide you through the process.

Related

First Published: September 23, 2024

Receive Updates from ServerSys

Join our mailing list to receive Dynamics 365 and Power Platform insights in your mailbox, typically once or twice each month. You can unsubscribe at any time, and we will never share your data.

Warren Butler - ServerSys Insights and Resources Author for Dynamics 365 and Power Platform. He brings over 20 years of experience covering business transformation, CRM and Microsoft Dynamics to help organisations grow by embracing technology.

Warren Butler

Warren is the director of marketing at ServerSys. He brings over 20 years of experience covering business transformation, CRM and Microsoft Dynamics to help organisations grow by embracing technology.

If you have any questions, please get in touch with us at hello@serversys.com

Warren Butler - Linkedin profile