Not displaying correctly? View in Browser

Hi Guest,

Newsletters are back!

We'll be sending some tips, tricks and news every other month to our IDEA customers. 
If you've got colleagues that might want to receive it, get them to subscribe here:

In this edition:
  • @Workday function explained
  • CaseWare IDEA Script Vault feature
  • Resource List reminder
Till next time...

Pauline Laidlaw
Manager, Analytics

Want the Global version of CaseWare IDEA News? 

Did you know that the Global IDEA team has a newsletter which shares the latest insights into IDEA. All you need to do is subscribe HERE. [You will need to scroll to the very end of the page.]

Customer Support Service

Give our customer service team a call if you're confused or unsure about any CaseWare IDEA function or feature!

+61 3 9660 4688

Need training? 

Look out for our Level 1 and 2 public course dates on our websiteWe deliver our public courses online using GoToTraining as our online training platform. If you need training sooner, or you have a few members of your team interested, we can conduct private training as well. 

Please contact us via or on (03) 9660 4680  to discuss your training needs. Register on the next course by clicking the button below:


Reminder list of all the available

CaseWare IDEA resources...

  • Tutorial Guides: Get more practice with a variety of tutorial guides including IDEA, Report Reader and SmartAnalyzer. These are installed with IDEA and located on your Start menu > All Programs > IDEA > Documentation
  • CaseWare Passport: IDEA 10 users with a current support and maintenance contract have access to the CaseWare IDEA resources such as knowledge base, videos, documentation, custom functions and more. 
  • Customer Service team: We are here to help with your IDEA support questions on or 03 9660 4688. 
  • Revamped IDEA Website: Visit the IDEA website for IDEA Tech Tips, Blogs, Webinars and more 
  • Training: New to the organisation and want to learn more about IDEA? Our next IDEA Level 1 Public Online training is on the August 28 & 29. This two day course acquaints new users with the bulk of IDEA’s basic functionality and breadth of tools.


Spotlight on IDEAScript Vault in the CaseWare Passport

The IDEAScript Vault has a large number of functional IDEAScripts. We've highlighted a few of the IDEA scripts that you may find useful.

  • Accumulated Total: calculates a running total based on a Numeric field in an IDEA database
  • NEW Append Database Report: This has been released recently and generates a text report showing all differences between field types in a range of user selected IDEA databases. This is useful when doing append operations in IDEA where the various source databases may have different field types. 
  • Export Multiple Databases to Excel: export multiple databases from the current project onto different worksheets in a single Excel workbook.
  • Import Multiple Files: This script imports multiple files of the same type.
Where can you find the IDEAScript Vault? 
Access CaseWare Passport within IDEA (File > Passport) or via your browser .  Select IDEAScript > IDEAScript Vault.

Have you used @Workday?

Looking for transactions posted on the weekend such as journals, invoices or sales? The @Workday function in IDEA will return the number 1 if the date falls on a weekday and 0 if the date falls on a weekend. 

How to use this function

@Workday(Date) where the Date is the date expression or field for which you want to determine if it falls on a weekday or weekend. 

For example, let’s extract a database with invoices processed on the weekend using @Workday (INV_DATE) = 0