No

Extraction Based on Date

Background: 

A small script that allows you to do an extraction based on a date.

Generate Audit Number

Background: 

This script will create an number field that keeps a count based on the selected field.  When the contents of the field change it resets to 0 and starts the count over.  There is also a second script that will order the field based on a date field.

Date Creation Database

Background: 

This script will create a date database based on a start and end date.  The script can do all date or the beginning or end of the month.

Fill Down Utility

Background: 

This script will allow you to fill empty cells within a database from information contained in the previous cell.

Copy Header Info

Background: 

The script will copy the header info from one file to another file.  This can be used when importing an excel file in which the data is over several tabs but the header info is only on the first tab.  The script will take the header info from the first and copy it to the second file.

The script was updated on March 17, 2016.  It now has an option to copy the old header name to the field description so that information is not lost.

Export Delimited File

Background: 

This script gives additional options for anyone wishing to export an IDEA file in a delimited format.

2015-08-15 - Updated the script so that the if you user select to include field names that they are separated by the selected field separator and not the ",".  Also added code to format numbers, it seems that if you had a number like 12.10 it would be stored in the text file as 12.1, this has been fixed.

Top Records Extraction Exclusion

Background: 

This script will perform the Top Records Extraction function within IDEA but at the same time it will also creates a second file with all the records that are not part of the Top Records Extractions. After selecting your file and hitting ok you will be taken to the Top Records Extraction dialog where you can enter all the parameters needed for the Top Records Extraction.  The script will then perform the extraction and then do a join to extract all the non selected items.

Z-score

Background: 

Calculates the z-score of a selected numerical field.  The user has the option of having the analysis performed based on the population standard deviation or the sample standard deviation.

Mod Calculation Script

Background: 

This mod test looks for round number in multiples of 100, 1000 and 10000 when taking into consideration the possible tax rate.

Number Duplication Test

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 RSS - No