DataConsulting February 2011 Newsletter


DataConsulting is an ACL Channel Partner in the UK. As well as being your first point of contact for ACL software we also provide ACL training and consultancy services. If you would like pricing on an ACL product, please go to our website to request a quote. We would like to keep you up-to-date with the news on ACL and other activities, so enjoy the news, and submit your best ACL tips! We look forward to hearing from you soon.

ACL AuditExchange 3 released

The latest version of ACL’s AuditExchange was launched on Monday 7th of February 2011. The newest release will introduce support for Unicode, Oracle 10 & 11 and Windows 64-bit operating systems.

DataConsulting Completes Duplicate Payments Review

A FTSE100 chemicals company has commissioned us to perform a review of their accounts payable data to detect duplicate payments. Using data extracts provided by the client of their SAP and JD Edwards systems we were able to do the analytics and also provide them with the scripts so that they could perform the same tests on when required.
If you would like to find out more about our Data Assurance services, .

ISACA presentation – Birmingham, January 2011

Robin Clough, Managing Director of DataConsulting, gave an insightful talk into the area of Continuous Auditing prompting a good number of questions from the attendees. Click for a copy of Robin’s slides and a brief synopsis of the talk.

Virtual Training

The next round of ACL Virtual Training starts this month. Sessions focus on common audit problems with solution techniques. Click for more information on live and on-demand virtual training sessions.

Upcoming Events
Visit us at ISACA EuroCACS 2011

Robin Clough will be appearing at the ACL stand at the ISACA EuroCACS event in Manchester which is running from 20th to the 23rd March.  Robin will be there on the 21st and 22nd and will also be presenting at 11:00 till 11:30 on the 22nd.

Come and say hi! Check out further details of the event on the link below:

User power!

The inaugural ACL London User Group meeting was held last November and was well attended by an enthusiastic audience. This is a group of ACL users that exchange ideas and techniques about using ACL and discussing best practice. It is run by the users, for the users.

The next meeting will be held on Thursday 24th February from 17.30 to 19.30. There will be two member presentations on building applications using ACL and also on script building.  This will be followed by an outline on the ACL product roadmap by Jerome Leplat of ACL.

If you are interested in attending a meeting, please by Tuesday February 15th and we will facilitate an invitation.

More indispensible information
ACL Insight

Check out the ACL newsletter Insight: . In particular, we recommend the practical advice on using analytics to tackle fraud, waste and abuse and the Continuous Controls Monitoring processes implemented by Dun & Bradstreet.

You can also find previous editions on the ACL website or subscribe to have them sent directly to your inbox.

Send us your ACL tips and win a prize!

Do you have a great ACL tip that you’d like to share with everybody? If so, send the details to us. For the best one selected we’ll publish the tip and award the top tipster £50 in M&S vouchers.

Send your tip to by Friday February 25th. The winner will be announced and the tip published in the next newsletter in March.

Try this tip from Robin – Find function

At DataConsulting we’re big fans of the Find function, if you don’t use it already try so now. It allows you search for strings of text across a whole table or a particular field. The function is not case sensitive and will go to work looking for the text string regardless of whether its in the middle of a larger string of text or on its own. Below is an example of how it may be used:

  • Find(“Champagne”) – looks through whole table
  • Find(“Champagne”,Expense_Description) – looks for the word Champagne in just the Expense_Decsription field


Handy short cut keys

Did you know also that if you’re working in script or just typing an expression in the filter bar or expression builder you can press the following keys:

  • F2 – Brings up available Fields plus more
  • F4 – Brings up available Project Items e.g. Table Layouts
  • F8 – Runs the Data Selector

We look forward to receiving your top tips!

Sport report

What does data assurance have in common with sport? DataConsulting are proud sponsors of two talented triathletes, Liz Burrows and Victoria Burrows-Bilton. We have been proudly following the twins’ careers for 3 years now and are eagerly looking forward to a new summer’s racing. For now, though, Liz is currently in New Zealand training in the sun while Victoria is getting good results from cross-country running over the winter in Yorkshire. You can follow Liz’s races and results at

Tuesday, February 1, 2011 In: Newsletters Comments (None)

Contact us

3 Appleton Court, Calder Park
Wakefield, WF2 7AR

+44 (0) 1924 254 101

Mailing List

Subscribe to our newsletter.