Is Your ERP System Killing Your Business?

PDFPrintE-mail

Today’s enterprises are plagued with problems related to making decisions whether to utilize resources to maintain existing IT environments or to initiate change programs that can transform existing systems into new optimized enterprise resource planning (ERP) systems that more adequately support the businesses. Innovation often takes a back seat to maintaining the status quo, a detrimental trade-off that hinders the performance and growth of many companies. Disconnects between different functional areas and different management levels of a company are the culprit, but the following problems can be analyzed more granularly and tackled collaboratively in order to reach solutions that address, quantify, and resolve many of the flagship hurdles holding back business.

  • The business is based on aging systems that are disparate throughout different areas of the organization. These systems can include legacy systems, but can also include early implementations of ERP applications.

  • The cost to support and maintain current systems is difficult to quantify and rises faster than reductions can offset them.

  • The existing systems do not integrate well with other business systems and are not agile as the business changes. Financial consolidation is error-prone and requires hundreds, if not thousands, of spreadsheets.

  • Departments such as inventory and manufacturing have little control over IT, especially priorities and standards.

  • It is easier to maintain operations and have contractors build fixes on top of other fixes than it is to change the mindset required to go to new systems or change the existing ones.

  • The lack of common enterprise standards prohibits the ability to easily share data and information across different areas of the business.

  • Separate business localizations make independent changes that negatively impact the global functioning of the company.

  • Different departments tackle problems on their own, rather than working together to find a solution that fits everyone’s needs.

  • Early systems, even early ERP applications, were limited both by available technologies and the understanding of how a global business could operate. Many “new” systems looked and functioned just like predecessor legacy systems.

CIOs are tasked with the responsibility of making IT work for the entire business, but they are too frequently not provided with the necessary information and resources to build a system from the ground up that considers and addresses the needs of all factions of the organization. CIOs must have critical managerial input from all corners of the business in order to develop the IT blueprint on which the company will function. The following guidelines can help ensure the development and deployment of consistent information systems that are considerate to both individual areas of the business as well as to the organization as a whole. 

  • Develop a standards committee that consists of the CIO and VPs from all departments of the business. For multinational corporations, a parent committee is also necessary. The CIO is responsible for developing relationships with the VPs that enable the flow of information and knowledge transfer from many departments. A significant portion of the CIO’s and participating VP’s bonuses should be tied to the successful implementation and ongoing utilization of the standards committee. Actions to be taken include: 

  1. Creating naming standards and formatting standards for all systems across the enterprise. For example, all descriptions should be the same field length, telephone numbers should all be in the same format (for example, countrycode.areacode.number.extension), punctuation should be eliminated, and abbreviations should be standardized.

  2. Standard codings, terminology, and classifications for crucial shared entities (accounts, projects, etc.) need to be developed, adopted, and put into common use.

  3. Time-tagging data items can prove useful in informing users how up-to-date they are.

  4. Educating new users of an application (and educating current users of a changing application) on the meaning and timeliness of the information they will be obtaining through that application is an essential component of maintaining the integrity of enterprise data.

  • Establish a data model for the enterprise. In order to be agile, an enterprise ecosystem – the architecture, the metadata, the data, and the business processes – needs to be independently sustainable and scalable, resulting in a single source of truth with clear governance and stewardship of the data. The architecture should begin with standard artifacts covering the information infrastructure and technology standards. The metadata should start with a single enterprise data model with different subsystems reflecting inter-related subsets of the model and the relationships among those subsets so that the source of each data element is clearly delineated and each of the business processes defines the creation and use of different data components. To ensure consistency, elements of the enterprise data model must be shared among those subsystems and built from the top down. Likewise, the process model begins with an enterprise process decomposition with supporting data flows and work flows showing the interactions among the processes. Analyzing the process model should show that the processes cover all phases of each resource’s life cycle. Correctness of the models includes checking to see that the representation of the metadata, the data, or the process means the same thing everywhere it is used.

  • Replace billable hours of external contractors with a focus on internal resources, out-of-the-box, best-of-breed solutions, and third-party software tools. Problem-solving with external resources often necessitates an inefficient brute-force approach to the problem, and the result is commonly a fix or band-aid rather than an encompassing solution for the source of the problem. Using software tools that are specifically designed to accomplish a goal (such as a reorganization or consolidation) reduces project time, reduces the likelihood of producing an error, and increases efficiency by keeping the knowledge base within the company’s internal resources.

  • Innovate through revisiting procurement policies and processes. In Oracle E-Business Suite, companies often set up hundreds of operating units during their initial ERP installation due primarily to security and control issues. Each operating unit has its own freight carriers, matching tolerances, approval hierarchies, supplier terms, and contracts. With a multitude of operating units, it is difficult to determine how much business is conducted with a particular supplier, difficult to determine the enterprise cost of managing and maintaining different supplier relationships, and difficult to determine the burdened costs of different inventories. Within a multi-org environment, much of the data must be set up by operating unit. While there are some advantages to having a multi-org environment, especially in regard to security, there are limitations that prevent obtaining an enterprise view of the data, especially the ability to leverage supplier relationships. By consolidating operating units to provide an enterprise view of the data, an organization may be able to reduce the number of suppliers or negotiate with current suppliers to obtain larger discounts and change payment terms – each of which contributes major amounts of money to the bottom line.

In Sum

The first part of any information management effort should be to ascertain the owner and original source of each type of data in an information flow. Only this “single source of truth” should be accessed for that data by all the other organizations in the system. It is also important to pay attention to the management of metadata and master data to improve transparency into the lineage and quality of data. Organizations need to consolidate systems that provide data for similar business processes, identifying and resolving duplicate and incomplete data so that data is entered and updated consistently in only one place. Following this and the advice listed above, companies will find that their ERP systems will help – not hinder – their operational performance and growth potential.

Add comment


Security code
Refresh

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Enter your email address to sign up for our Newsletter

Sign up now

captcha
TEChanges - Agility by Design

May Puzzle

David is often referred to as Rainman due to his peculiar ability to effortlessly figure out a certain date's day of the week. He recently displayed this talent when I asked him if there was a conflict with the upcoming Fuzzy Dice Conference and our weekly court-ordered community service. He asked the date of the convention. It was April 20th, 2012.

"Oh, that’s a Friday," he said, effortlessly. "And your sentences have you committed for the next few dozen Wednesdays so you'll be able to go." And of course he was right.

One day a few weeks ago I asked out loud in the office about the date June 5th. And of all people, my brother Tommy piped up and said "Oh, that's a Tuesday."

"That's right," said David.

Well how about Otcober 3rd?

"That's a Wednesday," said Tommy. Then I asked about Christmas Day 2012.

"Oh, that's a Tuesday." David nodded in agreement.

Do we now have two rainmen? Or had Tommy figured something out?

Show solution...

Solution

Here's what was going on. Tommy was using something called anchor dates. And these dates apply to each and every year. April 4th, or 4/4 we’ll call it from now on, June 6th or 6/6, 8/8, 10/10, 12/12, are all the same day of the week, each and every year.

So too are 5/9 and 9/5, May 9th and September 5th. So too are 7/11 and 11/7, and all the above dates are the same day of the week, as is the last day in February, Leap Year or not. And they’re all the same day as January 4th, it would otherwise be January 3rd, but this was a leap year, and that’s changes the anchor day from January 3rd to January 4th.

Tommy also knew that New Year's Day was a Sunday. He was sobered up by then. And he knew it was a Sunday because Christmas was a Sunday in 2011, so New Year's Day is a Sunday, so the Anchor Day for 2012, January 4th, has to be a Wednesday!

So if that's a Wednesday, then 4/4, 6/6, 8/8, 10/10, 12/12, 5/9, 9/5, 7/11, 11/7, and February 29th are all the same day of the week, and they're all Wednesdays. So when I ask for example, about October 3rd, he knew October 10th was a Wednesday, 10/10. So 10/3 must also be a Wednesday. 12/12 is a Wednesday in 2012, so it’s 12/26, which is two weeks later. So 12/25, or Christmas Day, must be a Tuesday.

Success Tips for Oracle Project Management

  • Create a standard for documentation at the beginning of your project, and hold team members accountable for completing documentation requirements as well as keeping them at and above the standards required.
  • Before promulgating user documentation or training, it’s also a good idea to choose a representative from the among the business users base to review materials first.
  • If you are not sure about the resources and budget required, obtain several estimates from people that have experience with the same size and scope of your project.
  • Be explicit, before beginning the project, what internal resources are required for execution. This includes people, infrastructure, hardware, and software.
  • Help the project champion understand the impact your project will have on the organization and how its successful completion will make him or her an internal hero or heroine for supporting it.
  • Break up your project into smaller projects (try for projects that can be completed in 4-6 months, especially early on) to get success and demonstrate momentum.
  • Make sure that your testing includes reports, upstream and downstream interfaces, customizations, enhancements, and workflows.
  • Ensure that comprehensive transition reports and meetings between departing and incoming personnel are completed.
  • Instead of spending time and resources implementing third-party reporting, consider consolidating multiple instances, moving to a global chart of accounts (CoA), and/or standardizing on a consistent calendar.
  • Include governance, risk, and compliance management as part of the project plan.
  • Finally, celebrate the successes. Too many projects focus on defects, failures, or small cost over-runs without looking at the big picture and what was accomplished.

The Analyst Corner

John Van Decker, Research VP of Gartner, states:

"A single chart of accounts allows consistency in financial reporting across the enterprise by standardizing on common metrics and reporting structures, reduces dependencies on a separate financial consolidation system, and significantly reduces the costs incurred with ongoing, complex conversions and translations."