Yes

Unlimited Key eXtraction (UKX) with Selection

Submitted by ravisdxb on Mon, 03/25/2019 - 06:05
Background: 

This can be used to extract unlimited number of keys, with a facility to select/de-select keys as required.

Replicate DB

Submitted by ravisdxb on Thu, 03/21/2019 - 02:46
Background: 

Sometimes developers and script writers may want to use bigger datasets to test the duration of processing or to test how well the script handles bigger datasets. This script replicates the data to the required number of times.

Unlimited Key eXtraction (UKX)

Submitted by ravisdxb on Sun, 03/17/2019 - 07:34
Background: 

This script can be used to extract unlimited number of keys, which tries to address the limitation of IDEA wherein Key Value Extraction is possible only for the first 500 keys.

Date Extraction

Brian Element's picture
Submitted by Brian Element on Sat, 03/30/2013 - 20:25
Background: 

This script extracts a maximum of 24 specified dates entered (Enter Dates button) or loaded from a text file (Load Dates File button).  Days of the week can also be extracted into separate files. Specified dates or days of the week selection can be inverted by checking the "Output all dates NOT selected" box. Dates must be entered using the DDMM format. Text files with dates can be created for subsequent reuse or loading by selecting the Save Button after inputting dates via the Enter Dates button.

Payment Date vs Due Date

Brian Element's picture
Submitted by Brian Element on Tue, 10/09/2012 - 16:57
Background: 

This script allows you to take two date fields and perform three different extracts:

  1. First date field is less than second date field,
  2. First date field is equal to second date field, and
  3. First date field is greater than second date field.

It will then summarize the findings based on year and month.  You can select which date field to use for obtaining the date and month information.

Script updated Feb 12, 2019

Text Search

Brian Element's picture
Submitted by Brian Element on Wed, 09/26/2012 - 08:21
Background: 

The text search script gives you an alternatvie interface to performing a text search from within IDEA.  The script allows you to select up to 10 different search terms (you can use the wildcards), it also allows you decide if the search is case sensitve or not and the type of search, i.e.

2nd - 3rd - 4th digit test

Brian Element's picture
Submitted by Brian Element on Tue, 08/07/2012 - 13:47
Background: 

This script will perform the 2nd, 3rd and 4th digit test which is based on Benford's Law.  The test is based on Mark J. Nigrini's book Benford's Law Applications for Forensic Accounting, Auditing, and Fraud Detection.  The script will create one file for each digit test.

Feb 14, 2013 - Updated for IDEA v9.

GEL-2

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 09:06
Background: 

The purpose of the GEL tests (GEL-1 and GEL-2) is to detect relationships or links within a data file that serve as potential indicators of fraud.

Same-Same-Same Test (SSS)

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 08:50
Background: 

The purpose of the Same-Same-Same test (SSS) and the Same-Same-Different test (SSD) IDEAScripts are to identify abnormal duplications as potential indicators of errors or fraud.

Updated Sept 17, 2015 - Updated the dialog.

The Same-Same-Different Test (SSD)

Brian Element's picture
Submitted by Brian Element on Fri, 07/13/2012 - 21:41
Background: 

The purpose of the Same-Same-Same test (SSS) and the Same-Same-Different test (SSD) IDEAScripts are to identify abnormal duplications as potential indicators of errors or fraud.

This script was originally writting using the Duplicate - Exclude function in IDEA but it turns out that there is a bug in version 7 and 8 of IDEA in which this function does not capture duplicate entries, it would only capture the first entry.  The script was rewritten to capture dulicates that fit the Same-Same-Different test.

September 2015 - Rewrote the interface.

Pages

Subscribe to RSS - Yes