The 21st Minute


Global Energy Corporation Uses IDEA to Identify Duplicates

Custom IDEAScript Performs Duplicate Tests for AP and P-Card Payments


A global energy corporation requested an IDEAScript to perform duplicate tests for accounts payable and purchasing card payments, and eliminate previously identified duplicates.


The duplicate research group received new data every month and compared it to the prior year of data to detect duplicate payments, which produced an overwhelming number of duplicates which had already been researched in prior months. 


An IDEAScript was developed to detect duplicates and matches within accounts payable and P-Card payments while automatically maintaining archives for the various tests. The archives were used to filter out previously found duplicates. 


The use of the Archival Mechanism dramatically reduced the number of duplicates to be researched by almost 95%. The duplicate research group was able to focus on auditing only new, relevant duplicate pairs. The efficiency gain allowed some staff to focus on higher level functions and the designing partners received a promotion.


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