Get File Name

Brian Element

A function to obtain the file name from a string that also contains the directory info.  This was updated on April 4, 2012 to add functionality for files that may be in sub directories.  Also added functionilty where you can get the file name or the file name with the directory imbedded in the IDEA working directory.

Field Dialog

Brian Element

This code creates a menu that allows you to pick multiple fields.  The code should be inserted as part of the menu structure and as part of the menu, usually based on a select statement option of a button being selected from the main menu.

Adding a timer to the script

Brian Element

You can add the following lines to a script to check how long it takes to process.  The commented lines show how to get the date and time.  The timer gives the seconds and milliseconds so it is great for using as a timer.

Since the Timer function counts seconds from midnight if your run time passes midnight then it will return an inaccurately large result.

GEL-2

Brian Element
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.

The Same-Same-Different Test (SSD)

Brian Element
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.

Review Status

Brian Element
Background

This script is a good utility script for adding x number of multistate fields along with opotion comment fields.  This would be useful for anyone using IDEA to change a sample database into one where a user can track and comment on audit steps.

Number Duplication Test

Brian Element
Background

This test will drill down into the data table to identify the exact transactions that were causing the spikes in the frist-order test and summation graphs.  The NDT Test is based on Chapter 8 of Nigrini, Mark J., Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations, New Jersey: John Wiley & Sons, Inc., 2011: Print

Subscribe to