• Log In
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • HomePage
  • About
  • Structure
  • Schedule
    • First Half of the Semester
      • Week 1: Introduction
      • Week 2: Business Process; Assertions
      • Week 3: Fraud, P2P Controls
      • Week 4: OTC Process, Types of Controls
      • Week 5: Inventory & Shipping Controls
      • Week 6: Invoicing & Collection Controls
      • Week 7: IT vs. SAP Controls, Security 1
    • Second Half of the Semester
      • Week 8: Security: Roles, Finance Process & Controls
      • Week 9: Security: User Management, Segregation of Duties
      • Week 10: Data, SOD/SAT Review
      • Week 11: Change Management, Development
      • Week 12: Auditing, Table Security, Risk / Control Framework
      • Week 13: SAP Futures, Special System Access (updated Nov 30)
      • Week 14: Character vs. Controls
  • Assignments
    • Exercise 1: Procure to Pay
    • Exercise 2: Order to Cash
    • Exercise 3: Journal Entries
    • Exercise 4: Segregation of Duties (SOD)
    • Final Exercise: Risk-Controls Framework
    • Extra Credit Assignment
  • Roster / Schedule / Teams
  • Webex
  • Gradebook

Auditing Controls in ERP Systems

ERP Systems

Edward N Beaver

Final Exam: Take December 17-19

December 13, 2016 by Edward N Beaver

The final exam of the semester will be conducted by Blackboard (you should see the link when you logon to Blackboard).  The exam will be available to take starting Saturday December 17 and must be completed by end-of-day Monday December 19.

Some specifics:

  • Questions mainly focus on course content (on-line and from class) from Week 11  through the end of the semester (topics listed on any ‘Overview’ or ‘Review’ slides.
  • Some questions from prior material (see Review slides from Week 7 and Week 12 11) may also be included on the exam.
  • Maximum amount of time to complete the exam is 40 minutes
  • Exam is approximately 25 questions (variety of formats i.e. Fill in blank, multiple choice
  • Some of the questions relate to this real-world like small business case.  You are invited to pre-read, print, etc. prior to the exam.

Week 14: Character vs. Controls Wrap-up

December 13, 2016 by Edward N Beaver

Continuing great job on the discussions.  I appreciate your responses and I learn from you.  You raised most of the important points but let me summarize my view.

Q1: How much automation of controls is best?  When should they be introduced?  Automated controls are ideal but not always possible or cost effective (e.g. complex scenarios or decision making).  My experience is leverage automation where possible and easily implemented.

As many of you pointed out ‘baking in’ the controls from the start is the easiest and most cost effective.  However they will added to as an organization grows, changes, etc.  Also, as the process matures and the external world changes you need to respond.

Q2: Describe the character of the leaders involved in the Real World control failures we reviewed.   The words you used I agree with: Arrogant, greedy, above control (‘absolute power corrupts absolutely’), self-interested, self-preservation response to pressures, etc.

These leaders were not necessary ‘bad’ leaders – many were very effective in accomplishing the goals of their organization.  However,  good leaders can have ‘bad’ character.  Creating a climate of controls need to balance (e.g. Sox type regulations) when this character drives illegal, immoral, or unethical behaviors.

Q3: A person’s character is very crucial in the audit industry.  How would you build your reputation and maintain a good ethical character in this industry?  This is something you have to do yourself.

I appreciate how Paul phrased it: Paul: ‘IT Governance: which is to “do the right thing, the right way”. Character is doing the right thing because it is the right thing to do.’  Integrity goes beyond the skills you have or knowledge of right things, but always doing the right things.

This integrity requires personal courage to stand up and be independent in our ‘end justifies the means’ world.

Q4: SAP’s GRC module may be important and effective, but can the cost of GRC be justified?

You all outlined in some detail what’s in this functional tool.  However in making the decision where to use you must weigh GRC’s costs vs. the cost of implementing controls other ways (often higher) plus the cost of not having needed controls or strength of controls in place.

 

Thanks for all your work in the participation blog this semester.   I trust it helped your learning.  Also remember to: do the right thing because it is the right thing to do.

Team Member Evaluation (Optional)

December 12, 2016 by Edward N Beaver Leave a Comment

All members of a team receive the same points for the exercise submissions. If you feel that one or more members are not doing their fair share, please do the following 2 things:

  1. Send email to all members of your team (.cc me) indicating that you will be submitting a team member evaluation form.  This step gives all members of the team the option of completing a form.
  2. Complete and submit the following form to me by email.

All responses will be kept confidential. 

 

Click Here for the Team Member Evaluation Form

Dow Chemical CIO Comments on ERP Project

December 6, 2016 by Edward N Beaver Leave a Comment

  • WSJ CIO JOURNAL.

Dow Chemical CIO Says Another 8-Year ERP Project Is Unimaginable

By

STEVEN NORTON

Nov 30, 2015 5:26 pm ET

0 COMMENTS

Dow Chemicalspent eight years and $1 billion implementing a new enterprise resource planning system that didn’t deliver value as quickly as hoped, Chief Information Officer Paula Tolliver said.

While the implementation officially finished at the end of 2014, Ms. Tolliver spent the first half of this year cleaning up messy databases, simplifying code and updating early parts of the implementation with features added later in the process.

Dow Chemical CIO Paula Tolliver

DOW CHEMICAL

Would she attempt another eight-year implementation? “Not in today’s world,” Ms. Tolliver told CIO Journal. “I can’t imagine doing the project we did in the last eight years in a time of such volatility.” With the maturing of cloud computing capabilities and more “as-a-service” offerings, “the change we’ll see in the next three years is unprecedented.”

Along with scrubbing data and simplifying code, during the implementation Dow devoted about $15 million in “inefficiency resources” to keep things running while employees got used to working with the new ERP system. Part of that went toward employee-recommended changes, such as reducing the number of steps needed to complete some business processes, automatically populating data fields and improving reporting, Ms. Tolliver said. The company also invested in hands-on training for many of its employees.

Dow’s example highlights some of the nuts-and-bolts challenges CIOs face as they try to update software and merge disparate data sets to find cost savings and new insights about customers. Whole Foods Market, Wal-Mart Stores and General Electric are all in the process of creating or consolidating ERP systems or integrating data across their companies.

Dow’s new ERP system – ECC version 7 from SAP SE – processes 7 million transactions each day and counts more than 16,000 unique daily users. The upgrade consolidated four separate regional systems into a single global ERP. Dow also pulled in some inventory and records tasks that previously took place outside the system.

A spokesman for SAP said the company does not comment on specific customer engagements.

Putting Dow on a single system gave employees more visibility into how their work fit into the company’s broader operations. But it also showed where certain processes got stuck or needed improvement, problems which may not have been noticeable at a regional level. Across the world, “people were performing the same work differently,” Ms. Tolliver said.

With much of the data scrubbing and code consolidation done, Ms. Tolliver now is trying to use the global view of Dow to simplify its core processes such as order-to-cash, supply chain and sales and operations planning. It’s part of the company’s “Dow 10.0” initiative, which aims to make it easier for customers to do business with the nearly 118-year old firm.

Besides change management challenges, Ms. Tolliver said a major lesson is never to underestimate the importance of accurate metadata. The firm created a centralized enterprise data management team that maintains all of the metadata related to customers, vendors, materials and product coding, which has helped as Dow works to ramp up its use of analytics.

Since the implementation, Ms. Tolliver said process cycle times have begun to decrease. Dow is on track to deliver $500 million in annual productivity by the end of 2017, she added. At the same time, she’ll contend with changes that could come as a result of potential deal activity. Separately, Ms. Tolliver said she’s wrapping up a project related to Dow’s “cloud transformation strategy.”

Video

Last December Paula Tolliver, CIO and corporate VP of business services at Dow Chemical Co., talked with CIO Journal’s Steven Norton about her three biggest lessons from the company’s 8-year, $1 billion architecture and ERP implementation.

8 years, $1 Bn ERP System – Worth It?

December 6, 2016 by Edward N Beaver 9 Comments

In a related post I copied an WSJ article that discusses a very large ERP system implementation at Dow Chemical.  The system processes ~ 7 million transactions / day and counts > 16,000 unique daily users.

Note: I was a member of this implementation team (i.e. a very small portion of the $1Bn paid my salary).

You can answer one of these questions as an alternate ? for this week:

  1. Why would an implementation take this long and cost so much?
  2. Given the information shared – why would Dow Chemical company approve such a large investment?

 

Week 14: Questions

December 6, 2016 by Edward N Beaver 113 Comments

  1. How much of automated controls should be desired? Is it beneficial to consider controls at the initial design phase or controls are introduced as and when needs arise?
  2. In the Real World Control Failures we’ve reviewed, describe the character of the leaders involved.  Is it a root of the control failures?
  3. A person’s character is very crucial in the audit industry.  How would you build your reputation and maintain a good ethical character in this industry?
  4. SAP’s GRC module may be important and effective, but can the cost of GRC be justified?  Explain

Week 13: SAP Futures, Special System Access Wrap-up

December 6, 2016 by Edward N Beaver

Continuing great job on the discussions. Keep up the good work.   You raised most of the important points but let me summarize my view.

Q1: SAP is a world class ERP system provider.  If you are an SAP customer – what would you expect them to provide to support your company’s internal controls?

&

Q2: The ERP systems market is very competitive.  What should SAP and other ERP systems providers be focusing on to make their systems more competitive in the future?

Some good, thoughtful answers and comments.  Here is summary of your responses:

Category Q1 Q2 Grand Total
Mobility 7 7
User Friendly 1 13 14
Simplicity 1 2 3
Training 2 5 7
Impl Cost 2 6 8
Customer Focus 2 8 10
Security 3 5 8
Flexible / Custom 2 13 15
Decision Making 1 1 2
Functionality 10 6 16
Interfaces 2 2
Change Mgmt 7 7
Scalable 2 2

Q3: When is the cost of implementing a compliance control higher than the benefit obtained?  What should an organization do to ensure efficiency and profitability?

This can be a real issue.  Many good comments about using standardization to drive down costs – effective mechanism but sometimes hard to do.  In the end solid  analysis of the risk and costs to implement need to be done and a business related (not IT or controls) decision needs to be made.

Q4: What is best focus, most effort to ensure  controls are adequate?  What factors about an organization would drive this answer?

You rightly pointed out that the regulations and laws that a business is responsible for drives the high priority control focus.  This often is a critical requirement for being in business.  You also need to understand and focus on those risks that can negatively impact the value of your business.

In the end – high quality business oriented knowledge and decisions create the most value.  Hence why I’m proud to be associated with an MIS program that’s in the school of business (where it belongs).

 

Final Exercise (Risk / Control Matrix) Due December 15

December 5, 2016 by Edward N Beaver

Reminder:  Final Exercise – Risk / Control Matrix is due (via e-mail) on Thursday December 15  at 5:00 pm.

Week 13: Questions

November 29, 2016 by Edward N Beaver 124 Comments

  1. (Updated Nov 30) SAP is a world class ERP system provider.  If you are an SAP customer – what would you expect them to provide to support your company’s internal controls?
  2. (Updated Nov 30) The ERP systems market is very competitive.  What should SAP and other ERP systems providers be focusing on to make their systems more competitive in the future?
  3. When is the cost of implementing a compliance control higher than the benefit obtained?  What should an organization do to ensure efficiency and profitability?
  4. What aspect of compliance should an organization put the most effort into ensuring their controls are adequate?  What factors about an organization (it’s industry, profit / non-profit, international, …) would drive this answer?

Week 12: Table Security, Risk/Control Framework Wrap-up

November 29, 2016 by Edward N Beaver

Continuing great job on the discussions. Keep up the good work.   You raised most of the important points but let me summarize my view.

Q1: …

Q2: …

Q3: …

Q4: …

Always … ask …  and  …

This coming week we will look ..

Its all too easy to assume that …  Always ask the basic questions first and then follow where they lead.

  • Page 1
  • Page 2
  • Page 3
  • Interim pages omitted …
  • Page 6
  • Go to Next Page »

Primary Sidebar

Weekly Discussions

  • Assignments (11)
  • Exams (5)
  • General (6)
  • Real World Control Failure Presentations (27)
  • Week 01: Introduction (4)
  • Week 02: Business Process; Assertions (4)
  • Week 03: Fraud, P2P Controls (2)
  • Week 04: OTC Process, Types of Controls (3)
  • Week 05: Inventory & Shipping Controls (3)
  • Week 06: Invoicing & Collection Controls (1)
  • Week 07: General IT vs. SAP Controls, Security 1 (3)
  • Week 08: Security 2, Finance 2 (2)
  • Week 09: Security: User Mgmt, Segregation of Duties (2)
  • Week 10: Data; SOD/SAT Review (2)
  • Week 11: Change Management, Development (3)
  • Week 12: Table Security, Control Framework (2)
  • Week 13: SAP Futures, Special System Access (2)
  • Week 14: Character vs. Controls (4)

Copyright © 2025 · Magazine Pro Theme on Genesis Framework · WordPress · Log in