CIOApplications
  • Home
  • Applications
      • 3D Scanning
      • Bioinformatics
      • Blockchain
      • BPM
      • Business Continuity
      • Business Intelligence
      • Collaboration
      • Configuration Management
      • CPQ
      • Container Management
      • CEM
      • Data Platform
      • Data Preparation
      • DMS
      • e-Discovery
      • Employee Engagement
      • EAM
      • Enterprise Communications
      • Enterprise Mobility
      • ERP
      • GIS
      • GRC
      • Human Resource
      • Innovation Management
      • Inventory Management
      • IT Infrastructure
      • IT Service Management
      • IT Services
      • Low Code
      • Managed IT Services
      • Marketing
      • Master Data Management
      • Mobile Application
      • Parking Management
      • Portal Software
      • Procurement
      • Project Management
      • Remote Monitoring
      • Remote Support
      • Sales
      • Software Asset Management
      • Software Testing
      • Supply Chain
      • Task Management
      • Unified Communications
      • Voice Recognition
      • Workflow
  • Verticals
      • Aerospace & Defense
      • Automotive
      • Banking
      • BioTechnology
      • Casino
      • Construction
      • Contact Center
      • E-commerce
      • Education
      • Field Service
      • Fintech
      • Food and Beverages
      • Government
      • Healthcare
      • Insurance
      • Legal
      • Life Sciences
      • Logistics
      • Manufacturing
      • Media and Entertainment
      • Oil & Gas
      • Retail
      • Space Tech
      • Telecom
      • Travel and Hospitality
      • Utilities
  • Technologies
      • API
      • Artificial Intelligence
      • Augmented Reality
      • Big Data
      • Chatbot
      • Cloud
      • Content Delivery Network
      • Cyber Security
      • Data Center
      • DevOps
      • Distributed Technology
      • Drone
      • Enterprise Architecture
      • Enterprise Search
      • Enterprise Startups
      • Graphics
      • HPC
      • IoT
      • Java
      • Load Balancing
      • Machine Learning
      • Machine to Machine
      • Machine Vision and Imaging
      • Nano Tech
      • Predictive Analytics
      • Robotic Process Automation
      • Robotics
      • Security
      • Telematics
      • Testing
      • Video Surveillance
      • Virtual Assistant
      • Wireless
  • Partner Network
      • Adobe
      • Amazon
      • Avaya
      • ESRI Partner
      • IBM
      • Infor Solutions
      • Microsoft
      • Mitel Partners
      • National Instruments
      • NetSuite
      • Nintex
      • Oracle
      • Progress
      • Riverbed
      • Salesforce
      • SAP
      • ServiceNow
      • SiteCore
  • News
  • conferences
  • Newsletter
  • About us
×
news

Subscribe to our Newsletter

Become a member of our mailing list for the latest articles, news, and exclusive insights.

news
news

Enter Your Email Address:

Thank you for subscribing with us. We sent you an email regarding this.

loading
SUBSCRIBE
  • Home
  • Fintech
Editor's Pick (1 - 4 of 8)
left
Making the Right Investment

Making the Right Investment
Brad Peterson, EVP & CIO, NASDAQ

Utility Game-Changers: Solar, Wind, Hydro and Fintech

Utility Game-Changers: Solar, Wind, Hydro and Fintech
Adriana Karaboutis, CIO & CDO, National Grid

Transformations in Financial Technologies

Transformations in Financial Technologies
Jacob Sorensen, CIO, Bank of The West

Global Access to Real-Time Data

Global Access to Real-Time Data
Ann Quandt, CFO, Partners In Health

Banks and Fintechs- A Better Value Proposition

Banks and Fintechs- A Better Value Proposition
Steve Ellis, Head-Innovation Group, Wells Fargo

Making the Most of Exponential Technologies in Financial Reporting

Making the Most of Exponential Technologies in Financial Reporting
Tadd Morganti, MD, Finance & Enterprise Performance, Deloitte Consulting LLP

Digital Transformation in Financial Services: An Inflection Point is Upon Us

Digital Transformation in Financial Services: An Inflection Point...
Mitch Siegel, Strategy Leader, Financial Services, KPMG LLP

Compete or Partner: Banks See Rise of FinTech Solutions

Compete or Partner: Banks See Rise of FinTech Solutions
Christopher Kennedy, VP-Quantitative Finance Manager, BankUnited [NYSE:BKU]

right

An insight in ECC data issues impacting Financial Results

By Eric Brink, CEO, ERPmenu

Tweet
content-image

Eric Brink, CEO, ERPmenu

Introduction

In the day and age of Big data and Business Intelligence (BI) one thing stays the same; data quality, which is a pre-requisite for good reports and management informations. When the data in your SAP ERP system is inaccurate, any further analyses of this data in BI solutions is inaccurate and can lead to wrong decisions or worse need of restatement of your company’s financial result.

SAP systems accumulate a lot of data in a short time frame. Data migrations issues, system setup problems, staff turnover, and the time pressure under which books need to be closed or unclear, user procedures can result in data problems. Especially, when companies go-live on SAP there is a learning curve for the users causing mistakes to happen that often sit in the system for a long time.

Fact is that, these data problems are inevitable even for companies that have been on SAP for years or decades. In the over fifteen years of working on SAP systems and assisting clients get the best outcome out of their systems, is one thing stands out for me. Data quality is a concern for each client I have worked with and deserves attention. Are you ready to take on this often less exciting, but vital topic?

What are Areas of Concern

Data issues can occur in all modules of the ECC system. When your company runs SAP ECC for manufacturing, service management, procurement, sales and/or project systems the integration with these modules and data flow to finance is causing dependencies on data quality on transactions executed upstream.

For financial controllers knowing what impacts the financial records outside of his own domain and ultimately impacts financial result is critical to understand. In general areas of concern in ECC are:

High volume transactions, as they are harder and more time consuming to analyze. Issues can hide easier, for example,tucked away in job logs and can sit unnoticed for years. With high volume transactions small fractions of errors add up to significant amounts impacting your results. Correcting those can be a daunting task.

Your ECC system is the source of your SAP Financial data and you need to keep records up to date in there and reconciled


Examples are the purchasing data like goods receipts/invoice receipts matching, accounts receivable analyses, order aging where sales orders, or production orders, can carry balances that did not get cleared.

Results Analysis (RA) is one of the more complicated functionalities in SAP Controlling used to calculate results on orders, projects, and sales orders. Auditors are always looking to reconcile this due to the direct impact RA has on the financial result, but again volumes are high and data sits in various modules making reconciliation and transparency hard.

Intercompany transactions occur via automated invoice exchanges that can fail, but often manual too. Transactions can happen within the SAP platform or between systems. Lots of companies are struggling with keeping this organized and reconciled. Again, this is a focus of auditors due to the impact on the group results.

Inventories lock up a big part of a company’s asset value. Reserved stocks (called special stocks in SAP) for Projects or Make to Order jobs can hide a lot of leftovers. Each company ends up building some kind of solution for slow moving and obsolete items, but price inaccuracy has a major impact too. Again volumes are high making automated analyses necessary to get insight.

Finance to controlling reconciliation is needed especially when multiple submodules in Controlling are used like CO Profitability Analyses (COPA). SAP has strong integrations and validations build in making it harder to cause discrepancies, but incomplete closing activities or system set up flaws can still cause FI and CO to be out of sync with COPA being the most error prone. Even though Simple Finance is going to address some of this, there are still many hand-offs between FI and CO.

Solutions

Staying on top of the data quality in your ECC system is good housekeeping and pays off tremendously in terms of reporting reliability and easy audit approvals. Having a plan and the tools in place to manage it is the first step, having the discipline to stay on top of it and adding it to your KPI reporting is the second.

My recommendation is that in finance data quality analyses should be part of the monthly cycle and incorporated in the closing schedule. Keeping up is much better than infrequent big clean up exercises. Standard SAP offers standard reports, but often these are complicated, narrow focused and require configuration. Business Intelligence companies offer various data clean up services too. However, your ECC system is the source of your SAP Financial data and you need to keep records up to date in there and reconciled. Linking and reconciling the financials to data in other modules gives you full insight and the confidence the financial reports represent the state of the business.

DQM stands for Data Quality Monitor and consists of a suite of solution focused to cover all FICO areas your auditors will look at each year. Closing validation is vital for reliable Income Statement reporting in SAP and offers great value for (SOX) audits.

Read Also

Banks and Fintechs- A Better Value Proposition

Banks and Fintechs- A Better Value Proposition

Steve Ellis, Head-Innovation Group, Wells Fargo
Making the Most of Exponential Technologies in Financial Reporting

Making the Most of Exponential Technologies in Financial Reporting

Tadd Morganti, MD, Finance & Enterprise Performance, Deloitte Consulting LLP
Digital Transformation in Financial Services: An Inflection Point is Upon Us

Digital Transformation in Financial Services: An Inflection Point is Upon Us

Mitch Siegel, Strategy Leader, Financial Services, KPMG LLP
Compete or Partner: Banks See Rise of FinTech Solutions

Compete or Partner: Banks See Rise of FinTech Solutions

Christopher Kennedy, VP-Quantitative Finance Manager, BankUnited [NYSE:BKU]

Fintech Special

  •  Fiserv: Redefining the Way Financial Services Industry Operates

Featured Vendors

  • Fiserv: Redefining the Way Financial Services Industry Operates
    Fiserv: Redefining the Way Financial Services Industry Operates
  • 1787fp: Working toward Financial Independence
    1787fp: Working toward Financial Independence
  • Datanomers: Automated Underwriting for Loans: The Next Frontier
    Datanomers: Automated Underwriting for Loans: The Next Frontier
  • Institutional Cash Distributors: Flexible, Efficient and Secure Trading
    Institutional Cash Distributors: Flexible, Efficient and Secure Trading

Copyright © 2019 CIOApplications. All rights reserved. Registration on or use of this site constitutes acceptance of our Terms of Use and Privacy Policy |  Sitemap  |  Subscribe

follow on linkedin follow on twitter follow on rss
This content is copyright protected close

However, if you would like to share the information in this article, you may use the link below:

https://fintech.cioapplications.com/cxoinsights/an-insight-in-ecc-data-issues-impacting-financial-results-nid-2104.html