Smart Controls
It's Just Good Business

IDEA Tech Tip: Using the Duplicate Key Exclusion Task
CaseWare IDEA Tutorials:Duplicate Key Exclusion

Use the "Duplicate Key Exclusion" task to identify duplicate records in a database, but only where a further specified field is different, such as duplicate supplier numbers. You can use it to identify duplicates within a single field or duplicates in a combination of up to eight fields. The fields selected are known as keys.

 
Watch the Tutorial Video to learn more about Duplicate Key Exclusion.

Whitepaper (New!)  

Download our whitepaper "Data Analysis: The Cornerstone of Effective Internal Auditing" from the CaseWare Analytics website. 

 

The whitepaper outlines the six key steps that can help Internal Audit become a more effective and valuable resource for control and operational issues as they arise in the organization.

Read More


Success: Dubai World Trade Centre Uses IDEA to Increase Audit Coverage 

The Dubai World Trade Centre (DWTC) business operations span venue/exhibition and event management, hospitality services and facilities management. DWTC sought a solution that could increase the scope of their data analysis and internal audit reviews in a comprehensive manner while also providing reliable and value-added results.

 

Using IDEA, the DWTC audit team has been able to add value to the business through increased coverage that allows them to prioritize potential risk areas, identify control gaps and test the reliability of system reports. By also implementing Smart Analyzer,  the audit team is using pre-packaged audit analytics to identify cost savings opportunities through the assessment of their General Ledger, Accounts Receivable and Payable, Fixed Assets and Inventory.    

 

 Read More

As An IDEA User We Think You Might Be Interested In:

 

Help Develop the Newest IDEA Features: Sign Up for IDEA Beta Testing

Users that sign up for Beta Testing help assess and influence new features and usability. If you are currently using IDEA version 9.2 and are interested in participating in our next beta test cycle please send an email to cwanalytics@caseware.com. 

 

NB: Please note we have a limit on the number of Beta Testers.

 

AuditNet® Premium Content for Supported Users

AuditNet® is the leading online portal for the global audit community, hosting a comprehensive catalogue of audit procedures. Their premium content is now available via the  IDEA Support Site.

 


Join us for these Upcoming Events:

IIA GAM Conference  

March 9th - March 11th

Las Vegas, NV

  

During the General Audit Management Conference (GAM) Chief Audit Executives, Audit Directors and Audit Committee members come together to discuss and learn about best practices, and new technology.  

  

Recommended Presentation:  

Harnessing Technology to Streamline Audit Processes

 

Presented By:  

Andy Carroll (IDEA User), CPA, CISA

Senior Director of Security and Governance  

Ralph Lauren Corporation  

 

Date: Tuesday, March 10th (Track 4) 

 

ISACA CACS
March 16th - March 18th
Orlando, FL

This annual conference promises to deliver all of the information you need to help you stay ahead in the rapidly changing world of IT Audit, Assurance, Security, Risk and Governance. 


Recommended Presentation:
Building Momentum: Integrating Data Analytics into Risk-Based Assessments

Presented By:
Seren Dagdiveren (IDEA User), CPA, CIA
Internal Audit Manager, Ivanhoe Cambridge

Bob Cuthbertson, CPA
COO, CaseWare IDEA Inc.

Date: Monday, March 16th at 4:00pm