Skip to main content

General discussion

Report Reader and Adobe Pro DC

At my office we recently switched from Adobe 9 (I think) to Adobe Pro DC. We are finding some issues when we now import PDFs into Report Reader. For example Report Reader isn't reading the PDFs as clearly as before. It may turn the number 0 into the letter o. Usually we add a page number to the PDF, so if the Report Reader misses something, we can easily see where the problem is. However, adding the page number now seems to hinder from reading the PDF clearly. We have IDEA version 10. Would version 11 fix this? Or is anyone else running into a similar problem?

ODBC Import - Date Filter

Hi there,
Does anyone know how data can be imported using the ODBC connection feature in IDEA with applying a filter on a date field?  I have tried numerous formats for dates ('YYYY-MM-DD') and ('MM/DD/YYYY'), using both a live Oracle database and Excel practice files but nothing seems to work.  I can filter on character and on numeric fields with no problems, but date fields do not seem to work.  
Does anyone know how to fix this or is this a bug in IDEA with the ODBC connection?
Any help would be appreciated!
Mike

Internal Auditors

How many people here are internal auditors?  I'd love some ideas on ways to use IDEA in all sorts of areas.  I work for a tribal govt in Internal Audit and am also a CFE.  I use IDEA in a variety of ways usually for special projects like the new Covid 19 payroll, and determining turnover but would love to develop some weekly/monthly recurring analysis using the data I can get from our accounting system and the HR system.  Eventually I'd like to get access to the gaming data.    How many have the IDEA certifications?  I've been looking at jobs and a lot of

How to make a join with scripting - Criteria problem

Hi!!
While I was studying, i tried to make a join between 2 databases that I already have both IMD files.
I have a criteria inside IDEA, but I can't use the same criteria using IdeaScripting..
Would you mind helping me to fix it? Please!
 
Set db = Client.OpenDatabase("SR3_STEP1.IMD")
Set task = db.JoinDatabase
task.FileToJoin "SR3_STEP2.IMD"
task.IncludeAllPFields
task.AddSFieldToInc "ID_SR"

Complete Guide to Auditing with Data Analytics Tools

I have this and it breaks down various areas to audit (AP, AR, GL, etc) and gives a list of things to do but no examples of how to do them using IDEA?  Is there somewhere that provides this information?  Is there a script out there or in the Analysis area?  Thanks in advance.