<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

Many companies don’t see anything wrong with their data quality, management and governance processes. But upon examination, this often isn’t the case. It’s easy to forget how big of a role humans play; your people are an important cog in the stream of data. They contribute to these streams and if they’re inconsistent in their approach, it can lead to issues further down the line.

I talk about this topic in more depth on an episode of Migration Minded, a podcast series created by the D365 Migration Community. Hosted by Tom Wisniewski, Microsoft’s Global Product Marketing Manager for Dynamics 365, he asks me about cloud migrations, the importance of change management, data management and more.

Listen to the episode below (or watch it here).


Address fields: The perfect example of data inconsistency

A common one I’ve seen is address fields. For example, your business may have multiple systems - from ERP and payroll to commerce and CRM. All of these systems will contain different elements of data - like addresses. This is a piece of data all of these systems will hold.

But depending on the format of the system, these addresses will be held in different structures. In Dynamics 365 Finance & Supply Chain Management (D365 FSCM), street name might be in one field while in Customer Engagement, it might be in three.

Both are Microsoft products, part of the same D365 family, and yet, addresses are held in different structures. Imagine if it’s a third-party system! There may be different fields or field lengths, for example, so when you move your address data out to this external system, it can cause conflicts.

Data management process

I’ve seen some businesses hold credit control notes in street three. Obviously, it’s not street three, it’s a note. But not everyone will use (or need to use) the street three field. So, when you go to extract this data, you’ll find that someone lives at 1 Blogg Lane, London, not a good payer.

That’s why it’s important to have a fundamental approach to data holistically within your business. Data is integral to what you do - it’s used for reporting, business decisions, planning and forecasting.

It’s even more critical in this modern era where businesses can move to the cloud and access tools such as dashboards and PowerBI to view real-time data. Modern technology has made it possible for data to be consumed more immediately so it needs to be accurate and reliable.

How to overcome this

You need to conduct a fundamental review of the data. Look at everywhere the data is used within your businesses.

Let’s start with data governance and profiling. Is there a master data management structure in place? There are tools that can help you bring all of this data together so you have a centralised master data. All of your systems can then ‘pick’ from that central system which can lead to more consistency of data because it’s coming from one place, not 10.

Data management process

From where you’re using this data and how it flows through the systems, you must know what structure it needs to be in. In other words, your data architecture. Data management controls will allow you to align these different systems so you cleanse the data (which generally happens through an implementation), perhaps through external tools.

Within a week or two of live, if you don’t have a data governance policy in place, people will start putting data in the wrong place, wrong structure etc. And that can obviously unpick all of the progress you’ve made since go-live and impact the value your new ERP system can offer.

Stay as close to standard as possible, unless data governance is compromised

One customer I’m working with at the time of writing is a global organisation. Their European division uses 15 external systems. Think along the lines of e-commerce, warehousing, different shipping carriers, product information and finance. All of this data is moving around these systems, generally through Azure Integration Services.

data management process

Making all of the data talk to each other is one of the biggest challenges - addresses certainly being one of them! In legacy systems, they’re held in three different locations. We’re trying to bring them in while doing a rollout at the same time.

Keeping all of that data aligned with good governance is difficult. As a whole, we would always recommend businesses stay as close to standard as possible when it comes to their solutions. However, we customised some of the products to encourage the user to pick the right record - all in the name of data.

For example, in D365 Sales, many of the address fields are free type - so you type in those records. In D365 Finance & Supply Chain Management, it’s multiple choice so you pick them rather than type. We customised this so it can be picked in Sales. Now D365 Sales could communicate across to FSCM in a standard format.

Data management process

It was as important that the data was standardised so we could communicate between the systems as it was for reporting. But ultimately, those elements fell into reporting anyway. So consistency of data and a team that can ensure that data is kept up to a good quality is critical for businesses.

Data is just one component that contributes to the overall success of your cloud ERP project

As you know, undertaking a cloud ERP project is no easy feat. Yet, it’s something that should happen if your business is to stay competitive and at its most efficient. Your data considerations are only one element that can ensure your journey to smooth ERP implementation and adoption.

In our guide, we cover the complete cloud ERP lifecycle, stretching from strategy to adoption and beyond. Learn the recommended best practices to follow and common mistakes to avoid, including how to leverage data to your advantage.

Download your copy below.

Download the Guide


Discuss this post

Recommended posts

Columbus has entered a collaboration with InterForm, sharing the collective mission of future-proofing output management in M3 with the new user-friendly InterFormNG2 solution. Together, InterForm and Columbus have created an M3 package that includes standard document templates. However, InterFormNG2 can also be used across other systems, making it suitable for companies that use multiple systems
Like other industries, food & and beverage companies must initiate strategy planning and change management at the very start of bringing their business systems to the cloud. That’s the best way to avoid additional costs, effort, and business interruption. And the trick is to define value with a people mindset.
Right now, companies in the food and beverage industry have a lot on their plate. A key question how to meet all demands and at the same time reach all your business goals? Unifying your technology platform, business strategy and operations is necessary to stay ahead of your competitors. Companies have to keep up with increasing consumer demand for products that are healthy, ethical and environmentally friendly while at the same time meeting regulatory standards and minimising food waste. And, of course, they still have to do the usual work of keeping margins high, preparing for emergencies, ensuring product quality, staying innovative and minimising risk at every stage of production.
Artificial intelligence is changing the way businesses operate in a fundamental way, and Microsoft's Copilot is at the forefront of this transformation. With its integration into Dynamics 365 and the Power Platform, the future of customer relationship management and enterprise planning has never been more promising. Let's explore how your business can benefit from it. Artificial intelligence (AI) is everywhere. The latest McKinsey global research calls 2023 a breakthrough year for generative AI tools. Less than 12 months after generative AI hit the market, one-third of survey respondents say they can’t imagine their lives without these tools. By 2025, Gartner says 30 percent of outbound marketing messages from enterprise organizations will be generated from an AI. Today, 87 percent of organizations say AI will give them a competitive advantage. We believe they are right. Your business is on a path that will intersect with AI — if it hasn’t already.
With Microsoft Copilot users can create ideas and content faster just by describing what they need with the help of AI and natural language processing. Users will save time, boost productivity, reduce workloads and also break down data silos. So, the hope is that AI — and Microsoft Copilot — will help everyone do more with less. Since Microsoft introduced Dynamics 365 Copilot — the world's first Copilot for both CRM and ERP — along with Copilot in the Power Platform, there is great anticipation about how these advancements will impact the way we do business. For example, Microsoft introduced multiple built-in scenarios for their products: Microsoft Dynamics 365 Sales and Viva Sales augment a seller’s actions with AI-powered insights, such as generating content suggestions based on customer emails. Microsoft Dynamics 365 Customer Service can give agents 24/7 AI-powered support to find resources to resolve issues faster. Microsoft Supply Chain Center enables Dynamics 365 Supply Chain Management customers to better predict and act on disruptions. Microsoft Power Apps allows users to build an app just by describing what they need in natural language. Beyond that, Microsoft Azure AI tools and services allow you to build your own smart agents and services. This gives every company even more opportunities to stand out by using customer and employee knowledge and insights to increase loyalty, decrease turnover and build long-lasting relationships. With this launch, Microsoft democratizes AI, making AI capabilities formerly only available to IT and AI specialists accessible to a larger set of workers. Those among the first to capitalize on this opportunity and leverage the potential of AI will of course be ahead of the competition.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down