How to download and use the Validate ABN Custom Function

How to download and use the Validate ABN Custom Function

Included with IDEA are over 100 @Functions used by the Equation Editor. For the majority of users, this list is enough. However, there are circumstances that arise where a function that is required does not exist. IDEA lets you create your own custom functions.

In the Equation Editor, custom functions are preceded by the pound sign (#). For instance, you might create a custom function called #ValidateABN.

Also custom functions have the file name extension *.ideafunc.

The #ValidateABN custom function verifies an Australian Business Number (ABN).

Warning: Please be advised that this custom function is provided for demonstration purposes only. It is provided without a warranty of any kind.

Return Type: Numeric, if the ABN is valid, 1 (True) is returned. If the ABN is invalid, 0 (False) is returned. 

You can download the custom function from the CaseWare Passport.   

Custom functions are located on the IDEAScript and Python Tab > IDEAScript  Custom Functions


1. Scroll down and click on the Validate ABN(Australian Business Number) custom function to download save in your Local Library folder C:\Users\[User Name]\Documents\My IDEA Documents\Local Library\Custom Functions.ILB


2. Unzip the downloaded file, ValidateABN.zip in the Custom Functions folder. Once a custom function has been added to the Custom Functions Library group, it is added to the functions list in the Equation Editor.

3. The ValidateABN function now appears in the Equation Editor under the Customs Functions>uncategorized group

    • Related Articles

    • How to download a Custom function?

      There are 2 ways to download a Custom Function from the IDEA Passport. Method 1 Download from the CaseWare Passport.    Custom functions are located on the Downloads Tab > IDEA Custom Functions Click on the custom function you want to download Unzip ...

    • How to download Custom functions for IDEA 12?

      The Custom Functions package contains 60 Custom Functions for use with IDEA V12 or higher.   This package contains Custom Functions relating to Data/Time, Character, Numeric and Financial. The package includes an installer package and a pdf that ...

    • Download and installing the CloudBridge

      In the Cloud Engagement file select Data / CaseWare Working Papers (else click here). Note: The current CloudBridge download is intended for use with the current release of Working Papers. If using an older version, please contact us. For users of ...

    • How to reference the ABN number using Connector

      CaseWare Connector allows users to connect to most of the Engagement Properties' fields in CaseWare Working Papers. However, one field is currently not available to select in CaseWare Connector, is the E.I.N / BN field. This field is used for ...

    • How to use the Agile Audit Balance Sheet and Income Statement?

      Agile Audit engagements provide a couple of financial statement documents, such as, Income Statement (4-450) and Balance Sheet (4-455) to review the variance amount and percentage changes between the current and prior year. Watch the video below to ...