Reap the benefits of CMMS with your ERP system

CMMS is essential when running enterprise resource planning (ERP) for a company's operations because it controls quality and operating costs


Most corporate departments think of maintenance when they need the thermostat adjusted in the conference room. But maintenance management and CMMS are an integral part of enterprise resource planning (ERP), which runs 80% of Fortune 1000 companies. CMMS is an essential tool for managing operations and maintaining assets across the enterprise. CMMS drives quality production, ensures regulatory compliance and controls operating costs.

So how do you run a smooth maintenance operation, keep assets humming and integrate with the company’s ERP system? Before you start coding a new ERP interface, weigh the issues. Is the CMMS integration a desire for the maintenance department or a directive from the COO? How can CMMS and ERP integration reduce operating costs and contribute to business performance?

Once you answer the big picture questions and decide to move forward, consider these guidelines from someone who’s been there and done that:

1. First, make sure you think through your points of integration. Synchronize part quantities vs. share a completed purchase order (PO) – this is an important debate. Some ERP systems make it difficult to share a whole purchase order, so perhaps synchronizing spare parts in your CMMS with the ERP POs is a better approach. 

2. Do you have internal expertise, or at least affordable consulting on the ERP side?
These costs can add up. It is likely your ERP system will need configuration support to make this interface work. 

3. Don’t rush into the integration. Get to know your CMMS first, for a few weeks or even several months before finalizing your integration plans. Product experience will influence interface approach/design, and is a safer, less expensive endeavor than building the interface in advance. 

4. Assess your CMMS needs. Understand that although a CMMS vendor may have interface capabilities off-the-shelf, the interface will always need to be configured for the organization’s environment – either on the CMMS or ERP side, or both. Configuration depends on the IT environment, ERP system and version, desired integration points, in-house ERP expertise, etc. Automated interfaces should be considered semi-configured (in some cases total custom) projects.

In theory, a quality CMMS vendor should have the technological capabilities to allow any information to be passed to and from an ERP system. Most common interfaces I have developed are related to spare parts. Others include sharing “finished” purchase orders/requisitions, asset information (status, location, costs, etc.), and employee data, typically labor rates or department information.

Most importantly, have the discussion with your maintenance team. Define the business goals. Identify the integration points. Your CMMS vendor won’t be able to discuss development costs unless you have thought through the project. Do your homework upfront so CMMS and ERP can make the connection a lasting one.

Paul Lachance is president and chief technology officer for Smartware Group, producer of Bigfoot CMMS. Contact Paul at

No comments
The Top Plant program honors outstanding manufacturing facilities in North America. View the 2013 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
A cool solution: Collaboration, chemistry leads to foundry coat product development; See the 2015 Product of the Year Finalists
Raising the standard: What's new with NFPA 70E; A global view of manufacturing; Maintenance data; Fit bearings properly
Sister act: Building on their father's legacy, a new generation moves Bales Metal Surface Solutions forward; Meet the 2015 Engineering Leaders Under 40
Cyber security cost-efficient for industrial control systems; Extracting full value from operational data; Managing cyber security risks
Drilling for Big Data: Managing the flow of information; Big data drilldown series: Challenge and opportunity; OT to IT: Creating a circle of improvement; Industry loses best workers, again
Pipeline vulnerabilities? Securing hydrocarbon transit; Predictive analytics hit the mainstream; Dirty pipelines decrease flow, production—pig your line; Ensuring pipeline physical and cyber security
Upgrading secondary control systems; Keeping enclosures conditioned; Diagnostics increase equipment uptime; Mechatronics simplifies machine design
Designing positive-energy buildings; Ensuring power quality; Complying with NFPA 110; Minimizing arc flash hazards
Building high availability into industrial computers; Of key metrics and myth busting; The truth about five common VFD myths

Annual Salary Survey

After almost a decade of uncertainty, the confidence of plant floor managers is soaring. Even with a number of challenges and while implementing new technologies, there is a renewed sense of optimism among plant managers about their business and their future.

The respondents to the 2014 Plant Engineering Salary Survey come from throughout the U.S. and serve a variety of industries, but they are uniform in their optimism about manufacturing. This year’s survey found 79% consider manufacturing a secure career. That’s up from 75% in 2013 and significantly higher than the 63% figure when Plant Engineering first started asking that question a decade ago.

Read more: 2014 Salary Survey: Confidence rises amid the challenges

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.