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.