The 21st Minute


O&G Supplier Uses IDEA to Test Controls Across Multiple ERP Systems

Analytic Toolbox Helps Test Revenue & Receivables Controls


A Global 500 supplier of technology, integrated project management and information solutions to the oil and gas industry needed to process data from their ERP systems to test controls for revenues and receivables.


Large amounts of data, stored in multiple ERP systems and formats, created a challenge for auditors to effectively test critical financial areas. The company also needed a way to produce, manage and share results.


The Solutions Development team created a suite of customized tests designed to interrogate financial data for outliers and anomalies. A custom IDEAScript was developed to automate the testing process and deliver consistent results.


The Analytic Toolbox enabled the client to process seven different data sets in multiple locations, and import the data into IDEA for testing. Results were presented in pivot table format and included color codes to quickly identify key areas of interest.  The Toolbox also helped automatically configure date formats for global consistency. The new solutions provided consistent results and improved preparation of revenue data to assist field auditors with performing inspections.


Automate Procedures , Success Story

Posted By


Related Posts
Turn Your Data into a Competitive Advantage
Nov 05 Download the eBook We are in the midst of a data explosion where every action is collected, from a credit card swipe to the vibration of a factory machine. Y...
Infusing Python into Your Analysis with IDEA
Oct 06 The tech community often refers to Python as the official programming language for non-programmers. It’s free and easy to learn (even if you don’t know wher...
Exploring IDEA's Built-In Power of Python
Aug 20 In December of 1989, Dutch programmer Guido van Rossum was looking for a hobby programming project to keep him occupied during a slow work week around Christmas...

This website has been designed for modern browsers. Please update. Update my browser now