Data Quality

Your ERP Runs the Business.
It Was Never Designed to Understand It.

For almost 15 years we have been helping manufacturers grapple with disconnected, duplicated, dirty, and distrusted data. With the explosion of AI, the need for clean, context-aware data has never been more urgent. Here is what we have learned about why the old tools failed, and what actually works.

9 min read
Paul Ausserer, Marquis Data
May 2026

The customer named "Do Not Use"

Here is a real thing that happens in manufacturing ERP systems. You open the customer master and you find a record that looks something like this: ACME, INC (Do Not Use).

Here is the thing: that record is not broken. It is actually doing its job. It is hard to accidentally create a Sales Order when the customer name on screen says "Do Not Use." Someone, at some point, was solving a real operational problem by naming it that way. It works. Kind of.

But when you sit down to understand your business holistically, to analyze revenue by customer, to track account relationships, to power an AI model with your own data, records like that start crumbling the walls. You cannot roll up revenue to "ACME" when half the orders live under "Acme Corp," a quarter live under "ACME, INC (Do Not Use)," and the rest were entered as "ACME INCORPORATED" by three different people in three different plants.

This is not an edge case. This is every manufacturing company we have ever worked with.

One customer · Four ERP records · Zero trust
ERP System
Epicor (Plant A)
Customer Name as Entered
ACME CORP
Enriched Name
Acme Manufacturing Group
ERP System
Dynamics (Plant B)
Customer Name as Entered
Acme Manufacturing, Inc.
Enriched Name
Acme Manufacturing Group
ERP System
Sage 100 (Plant C)
Customer Name as Entered
ACME, INC (Do Not Use)
Enriched Name
Acme Manufacturing Group
ERP System
NetSuite (Plant D)
Customer Name as Entered
ACME INCORPORATED
Enriched Name
Acme Manufacturing Group

What happens when you have two or more ERP systems

A single ERP with dirty data is a problem. Two ERPs with dirty data is a structural problem. The duplication is not accidental. It is built in.

When you acquire a company, you inherit their ERP. Their customers have their own item numbers, their own naming conventions, their own ways of entering an address. Your customers may already exist in their system under completely different records. Neither ERP knows. Neither ERP cares. They are not designed to.

So now you have the same customer in two systems with two different names, two different account numbers, and two different histories. Every report you run sees two customers. Every analysis splits the account. And when your new PE sponsor asks for total revenue by customer across the portfolio, you are handing them a number assembled by hand.

The standard answer to this problem is ERP consolidation. Get everyone on the same system. One ERP, one customer master, one truth. It is a reasonable idea that costs millions of dollars, disrupts your key people for years, and still leaves you with years of historical data in the old systems that need to go somewhere.

We have a different answer.

Excel: the universal workaround, and its fatal flaw

Before we get to the right answer, let us talk about the answer every company already has: Excel.

Every business has that person. You know the one. They have a spreadsheet that maps the old customer names to the new ones, adds the segment codes the ERP never captured, flags the accounts that were acquired with the business in 2019, and notes which ones have changed parent companies. Their spreadsheet is, in a meaningful sense, the most accurate customer master in the company.

The problem: that person's work never leaves that person's desk. You have created a single point of failure, wrapped it in a spreadsheet, and given it no version control, no access controls, no audit trail, and no connection to any system that actually runs the business.

When that person leaves, or gets sick, or goes on vacation the week the board wants a customer roll-up, the knowledge walks out the door with them. What looked like a solution was actually a dependency.

We have seen this exact situation dozens of times. The spreadsheet grows over years, becomes impossible to maintain, and eventually gets replaced by a slightly different spreadsheet owned by a slightly different person. The cycle repeats.

Why MDM is the wrong tool for most manufacturers

The enterprise software industry noticed this problem a long time ago and invented Master Data Management, or MDM. The pitch is compelling: a centralized system for managing customer, supplier, and product master data with governance workflows, golden record management, and data stewardship tools.

The problem is that MDM is built for organizations with dedicated data governance teams, multi-year implementation budgets, and the organizational maturity to enforce data policies across every system and every user. That is not most manufacturers.

And even for the ones who can afford it, MDM has an Achilles heel: it addresses new data going forward. Every record created from implementation date follows the golden record process. Every record created before implementation date sits in the old system, untouched, getting queried by reports that never knew about the MDM project.

Historical data does not clean itself. You still have to deal with years of it regardless of what you decide going forward.

What Enrich actually does

Enrich is the data management layer at the heart of Marquis IQ. It is not an add-on. It is not a premium tier. It comes with every deployment because you cannot run meaningful analytics on data you do not trust.

Under the hood, Enrich draws on three layers: third-party data services for external verification and enrichment, our own proprietary technology built specifically for multi-ERP manufacturing environments, and large language models across every major provider that bring natural language understanding to entity resolution, classification, and attribute extraction.

Here is what it handles:

1
Resolve duplicate customers and suppliers
We leverage third-party data matching services combined with a 12-step proprietary matching algorithm that typically covers over 80% of the deduplication work automatically. Fuzzy name matching, address normalization, and ERP cross-reference detection surface probable duplicates before a human ever has to review them. What used to take weeks of analyst time takes hours.
Largely automated
2
Standardize all addresses
Addresses matter for territory management, tax compliance, logistics analytics, and sales segmentation. They are also almost universally entered poorly. We combine verified third-party postal data with LLM-assisted parsing to handle the non-standard formats and abbreviated entries that rule-based address parsers consistently miss, across every ERP system we connect to.
3
Group customers and suppliers into families
When two of your customers merge, or when a private equity firm acquires three of your accounts, you need to see them as a family while preserving the individual site records. Enrich lets you build and maintain customer and supplier hierarchies at any depth, independent of what your ERP knows or does not know.
4
Link CRM accounts to ERP accounts
Sales and Finance look at the same customer through completely different lenses and completely different systems. Enrich creates the link between your Salesforce (or other CRM) accounts and the corresponding ERP customer records across every plant. Quote-to-cash visibility without the iron-fist ERP migration approach.
Works across every ERP we connect to
5
Handle historical data
Enrichment applies retrospectively. Every historical transaction, order, and invoice is surfaced under the correct enriched record the moment the enrichment is defined. You do not need a data migration. You do not need to touch the source ERP. Five years of history becomes clean the same day you set up the golden record.
6
Create your own segmentation and attribution
You know things about your customers, suppliers, parts, and warehouses that NAICS codes and standard classifications will never capture. Your End Market taxonomy is not theirs. Your Strategic/Key/Standard customer tiers are yours. Enrich lets you manage custom attributes of any type, fully self-service, on any entity in your data model. Your business logic, maintained by your team, without a developer in the loop.
7
Create dynamic rules and automated attributes
Managing by exception only works if the exceptions surface automatically. Enrich supports rule-based attributes that update as your data changes. A customer crossing a revenue threshold moves from Key to Strategic. An item falling below minimum stock triggers a flag. You define the rules; the platform maintains them. And where defining rules feels complex, our LLM layer can translate plain-language business logic into structured attribute rules without any coding required.
No developer required

What a customer family looks like in practice

Here is the kind of structure Enrich makes possible. One real customer, acquired by a private equity firm, with two operating subsidiaries running across four different ERP systems. Before Enrich, these were eight separate records with no connection between them. After Enrich, they are one family.

Customer Family Hierarchy · Lakeside Industrial Group
Customer Family
Lakeside Industrial Group
Strategic Automotive Tier 1 $12.4M total revenue CRM linked
Subsidiary
Lakeside Precision Components
Strategic
Epicor · Plant Rockford IL
LAKESIDE PREC MFG
2,800 orders · $7.1M revenue
Dynamics 365 · Plant Columbus OH
Lakeside Precision Manufacturing, Inc.
1,450 orders · $3.6M revenue
Subsidiary
Lakeside Fluid Systems
Key
Sage 100 · Plant Memphis TN
LFS INC
920 orders · $1.2M revenue
NetSuite · Plant Phoenix AZ
LAKESIDE FLUID SYSTEMS
440 orders · $0.5M revenue
Customer Family (unified identity with extended attributes)
Subsidiary (operational grouping)
ERP Record (raw name as entered in source system)

The four raw ERP names ("LAKESIDE PREC MFG," "Lakeside Precision Manufacturing, Inc.," "LFS INC," "LAKESIDE FLUID SYSTEMS") are not changed in their source ERP systems. The source systems continue to work exactly as they always have. Enrich creates the unified view above them, at the analytics layer, where decision-makers need it.

Revenue rolls up to the family. Custom attributes like Customer Type (Strategic, Key, Standard) and End Market (Automotive Tier 1) are managed once, at the family level, and inherited by every record underneath. When the CRM account manager updates the account strategy for Lakeside, that update is visible to the finance team's view of the same customer.

Why the AI moment makes this more urgent, not less

Every AI tool your business is evaluating, every large language model you want to query against your data, every analytics assistant you want to deploy, starts from the same assumption: the data it reasons over is consistent, trustworthy, and contextually rich.

"ACME, INC (Do Not Use)" is not consistent. Four names for the same customer is not trustworthy. NAICS codes that do not match how your business actually segments its markets are not contextually rich.

The companies that will get the most out of AI in the next few years are not the ones with the most AI tools. They are the ones with the cleanest data foundation. The enrichment work is not prep work for something else. It is the thing.

Enrich is not an add-on. It ships with every Marquis IQ deployment because clean, enriched master data is the foundation everything else is built on. You cannot run meaningful IQ analytics on data you do not trust, so we do not sell the foundation separately.
Marquis IQ · Enrich

One golden record. Every ERP. No migration required.

Enrich is included with every Marquis IQ deployment. Connect your ERP systems, resolve duplicate customers and suppliers automatically, build your own family hierarchies, and add the segmentation and attribution your business actually uses.

Automated duplicate detection across every ERP
Address standardization across every record
Customer and supplier family hierarchies, self-service
CRM-to-ERP account linking across every plant
Custom segmentation and dynamic rule-based attributes
Historical data enriched retroactively from day one

FAQ

Questions about ERP data enrichment

What we hear most often from operations leaders and data teams when they start looking seriously at master data.

What is ERP data enrichment and why do manufacturers need it?

ERP data enrichment is the process of cleansing, standardizing, deduplicating, and extending the master data that lives in your ERP: customer records, supplier records, item master data, and location data. ERPs are built to process transactions, not to serve as decision-making platforms. When you try to analyze your business across inconsistent records, the dirty data undermines every answer. Enrichment creates a clean, consistent, extended data layer above your ERP that decision-makers can actually trust.

How is Marquis Enrich different from a traditional MDM system?

Traditional MDM systems are enterprise-grade platforms built for large organizations with dedicated data governance teams. They require long implementation timelines, significant IT involvement, and ongoing administration. Most manufacturers do not have those resources. Marquis Enrich is embedded directly in the analytics platform and designed for business users, not IT teams. It automates the work that MDM would require humans to configure manually, and it handles historical data natively rather than requiring a clean-slate migration.

What happens to years of historical ERP data when you start enriching master data?

This is one of the most underestimated problems in master data work. Even if you decide to roll forward with a clean data policy from today, you still have years of historical transactions tied to old, inconsistent, or duplicate records. Marquis Enrich handles historical data by applying enrichment at the analytics layer rather than modifying the source ERP. Every historical transaction is automatically surfaced under the correct enriched record, so your trend analysis is clean from day one without touching the underlying ERP data.

Can Enrich connect customer records across different ERP systems?

Yes, and this is one of the highest-value capabilities. When a manufacturer grows by acquisition, each plant brings its own ERP with its own customer master. The same end customer often appears under different names, different account numbers, and different formats in each system. Enrich creates a unified customer identity that spans every ERP in the portfolio. Revenue, orders, and margin from every plant roll up to that single identity without requiring ERP consolidation or any changes to the source systems.

Is Enrich an add-on or included with Marquis IQ?

Enrich is a core feature included with every Marquis IQ deployment. The reason is simple: analytics built on dirty, inconsistent, or duplicated master data are not analytics, they are a liability. Every Marquis customer gets customer deduplication, address standardization, family grouping, CRM-to-ERP linking, historical data enrichment, and self-service attribute management as part of the base platform. You cannot run meaningful IQ analytics without a clean data foundation, so we do not sell the foundation separately.

Stop managing master data in a spreadsheet

Enrich gives your team one golden record per customer, supplier, and item across every ERP, with the custom segmentation and family hierarchies your business actually uses.