Posts Tagged ‘ERP Design’

Why companies need skilled support to interface with a Strategic Integrator on ERP Implementations

Wednesday, February 9th, 2011

Typical ERP projects consume a significant amount of resource both from the client and the Strategic Integrator (SI).  This activity typically falls on the shoulders of some of the busiest people in the company who can ill afford to drop what they are doing and face off against a team of highly polished consultants.

“Our people act as an extension of your management team. We represent you at meetings and assist in decision making because the need to run and maintain your company does not pause when the SI needs to gather requirements or perform testing.  We keep a watchful eye on the SI to ensure that are working to plan.”

In order to successfully oversee and manage a project we advise clients to bring in experienced resources that are familiar with the functionality of the software to ensure that the overall design is sustainable.

“Our people understand the software development life cycle and ensure that decisions are made that support the future upgrade and patch application of your implementation.  Sustainability means resisting in almost all cases invasive customizations. It means focusing on sound configuration techniques that allow your system to grow and expand as you do”.

Systems implementations create unique opportunities to review, analyze and improve business processes.  To simply use a new system to follow the old process is “paving the old cow path”.

“Our people are also aware of best practices for process enhancement around your new system. The SI is under no obligation to overhaul your procedures however we ensure that opportunities are not missed.”

In order to ensure that the project progresses swiftly and efficiently bring resolution to risks and issues is imperative.

“Our people are knowledgeable of project management techniques surrounding project management office activities.  We act in a timely fashion so that the expensive SI resources are not idle on your budget.”

In order to ensure that your new system is used consistently by new users and that the transition is effective, we recommend that specific change management steps are taken. These include the creation of job aids, webinars, FAQ’s.

“Our people understand that organizations are made up of people that generally fear and avoid change.  Successful implementations have a change management component to ensure that users are trained on the new system and have an escalation path if they have questions.”

“If you are planning and ERP Project and you want more information, call us.”


Common Pitfalls in Chart of Accounts Design

Monday, March 8th, 2010

It is very interesting to speak with companies about their Chart of Accounts.  There are a lot of pre-conceived notions about what has to be in there. I’ve seen companies with over ten segments, total character length over 45 digits, mixed alpha-numeric- you name it.  However, very often companies feel themselves being crushed by the weight of the very chart they built so much intelligence into.  Very often, conversations about numbering conventions in the chart feel like people are developing the DaVinci Code.  I am a Chart of Accounts purist. I believe that less is more.

In my opinion, the COA is there to serve a very specific purpose.  It is there to satisfy the needs of your statutory reporting.  The COA is not the engine that drives all of your management reporting.  You can build hierarchies to your heart’s content in Hyperion or another reporting tool.

Some common pitfalls in COA design that I have seen include:

Building a hierarchy into your chart of accounts.  In today’s world, you don’t need to have a numerical hierarchy built into your account scheme.  Some companies build such complex ones that they are violated and garbled in year two of a systems life or blown up when an acquisition is made. Your COA hierarchy belongs in your reporting tool. Don’t get me wrong, if you want the 1000’s to be assets and 2000’s to be liabilities… that is fine.  However, mandating that account 1250 be related in some way to account 1200 is not necessary.

Building dependencies between segments.  This is another fairly common mistake.  Each field in the chart of accounts should be completely independent of one another.  In this fashion you have complete flexibility in the growth of your company.  For example, having a segment dedicated to region, which is a grouping of legal entities is a mistake.  You are forced to build a number of validation rules into your system that become cumbersome to maintain in the future.  Your regional split should be based on a hierarchy that exists in your reporting tools.

Alpha-numeric mixed fields. This one is a big pet peeve of mine.  I don’t ever like to see letters and numbers mixed in a COA segment.  Firstly, any speedy data entry person will be forever angry at you that they need to use both the keyboard and the number pad.  Think of the thousands of lost hours of productivity in your shared service centers.  Secondly, when exporting to Excel or any other tool, the fields become unwieldy, and rarely sort the way you want them to.

Ignoring localization requirements.  Sometimes large multinational corporations produce a chart of accounts that works perfectly in the country where the project team is based.  However when the chart is used cross border there is a problem capturing information that local authorities mandate should be in the chart of accounts.  Be cognizant of international rules. Bring your finance colleagues from around the globe into the COA design discussions.  While you may not be able to accommodate every requirement, you may be able to cover many of them by providing adequate space in the chart to capture some country specific pieces of data.

We should all remember the first word in General Ledger is General.  Keep it small, compact and free of extraneous information other than what you need to compile a good set of statutory accounts.  Always know that for detailed reporting, the main source should be your sub-ledgers.