
An insight in ECC data issues impacting Financial Results


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.
Check this Out:Top Reconciliation Companies
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.
Your ECC system is the source of your SAP Financial data and you need to keep records up to date in there and reconciled
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.
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.
Solution in the DQM suite are:
DQM FICO FLOW: Financial closing validation solution for Income Statement with COPA reconciliation feature.
DQM RAR: Financial tool to perform Results Analysis reconciliation between GL balance and the CO calculation by cost object.
DQM GRIR: Offers a swift overview and breakdown of multiple facets of your GR/IR balance and items.
DQM ICR: Tie out your Intercompany balances and drill down into your out of balance records.
DQM AR: Look at your AR aging in the most comprehensive way.
DQM-MV: Find what hides in your inventory.
DQM-ORD: Find aging orders, order balances and easy mass close.
DQM-PPV: Break down your Purchase Variances on your PPV account and in inventory.
Featured Vendors
projektraum36 / p36.labs: Delivering Native SAP Cloud-based Solutions for the Life Sciences Industry
My Supply Chain Group (MSCG): Enabling the Intelligent Enterprise and Digital Supply Chain through SAP
Configurable Management: Get Control of your SAP Master Data and Automate Manual Business Processes—Rapid Deployment Solutions
Global Software, Inc: Creating the Ultimate Excel-based SAP Reporting Platform with Spreadsheet Server
EDITOR'S PICK
Essential Technology Elements Necessary To Enable...
By Leni Kaufman, VP & CIO, Newport News Shipbuilding
Comparative Data Among Physician Peers
By George Evans, CIO, Singing River Health System
Monitoring Technologies Without Human Intervention
By John Kamin, EVP and CIO, Old National Bancorp
Unlocking the Value of Connected Cars
By Elliot Garbus, VP-IoT Solutions Group & GM-Automotive...
Digital Innovation Giving Rise to New Capabilities
By Gregory Morrison, SVP & CIO, Cox Enterprises
Staying Connected to Organizational Priorities is Vital...
By Alberto Ruocco, CIO, American Electric Power
Comprehensible Distribution of Training and Information...
By Sam Lamonica, CIO & VP Information Systems, Rosendin...
The Current Focus is On Comprehensive Solutions
By Sergey Cherkasov, CIO, PhosAgro
Big Data Analytics and Its Impact on the Supply Chain
By Pascal Becotte, MD-Global Supply Chain Practice for the...
Technology's Impact on Field Services
By Stephen Caulfield, Executive Director, Global Field...
Carmax, the Automobile Business with IT at the Core
By Shamim Mohammad, SVP & CIO, CarMax
The CIO's role in rethinking the scope of EPM for...
By Ronald Seymore, Managing Director, Enterprise Performance...
Driving Insurance Agent Productivity with Mobile and Big...
By Brad Bodell, SVP and CIO, CNO Financial Group, Inc.
Transformative Impact On The IT Landscape
By Jim Whitehurst, CEO, Red Hat
Get Ready for an IT Renaissance: Brought to You by Big...
By Clark Golestani, EVP and CIO, Merck
Four Initiatives Driving ECM Innovation
By Scott Craig, Vice President of Product Marketing, Lexmark...
Technology to Leverage and Enable
By Dave Kipe, SVP, Global Operations, Scholastic Inc.
By Meerah Rajavel, CIO, Forcepoint
AI is the New UI-AI + UX + DesignOps
By Amit Bahree, Executive, Global Technology and Innovation,...
Evolving Role of the CIO - Enabling Business Execution...
By Greg Tacchetti, CIO, State Auto Insurance
Read Also
Tech Continues To Transform The Broker’s Universe
How Digital Innovation Is Transforming Real Estate
Significance Of Flexible Leadership In Real Estate Business
Innovating The Single-Family Leasing Industry To Simplify The Home
How Technology Fuels The Future Of Work
Digital Transformation & Innovation
