Skip to main content

General discussion

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.

Webinar on Custom Functions

I did a webinar for SAMA on custom functions.  It is not available on YouTube if you want to see it.  It is about 45 minutes long, first 30 minutes is my presentation and the rest is questions.  I go through three items, one is a simple custom function to show how they can be created, two is showing how you can take a fairly difficult equation in the Equation Editor and make it more readable as a custom function and third is creating custom functions that aren't available in the Equation Editor.

Thank you Brian

I want to thank you Brian and others who helped me with setting up and running a script automatically.  I got upgraded to version 11 and so far am just using Task Scheduler to run the script I needed.  It runs like a Ferrari and is saving me about a days worth of work so THANK YOU so much!

cost of IDEA and SDK

Hello @ all,
first of all many thanks to this forum. Here you will always find inspiration for new projects and competent help and advice!
 
I don't know if someone can help me with my current problem.
In my work I regularly use IDEA10. In this context I have made a suggestion for an extensive macro to make certain processes more efficient. On the part of my German employer I was informed that a corresponding macro would not save any time. I spare myself a comment on this.

Open file - Address inside IDEA Script

Hi!
I have some questions:
1) Is there a way to open all files from a folder? -> and put the different names (addresses) to an array?For example, now I ask the user using Input to say the address from the file, but I would like to process a lot of different .xlsx files at the same time.
2) If the user write the address as folder1/folder2/open.xlsx 
Is there a way to break the string and get only the "open"?
 
Thank you!!

Free Idea Internal Resources

hi Brian
I have a program that creates some databases and delete them while the script is running, the script loops few hundred times until it finishes.
somewhere along the execution path the script crashes, in different places, with Idea internal error message. The reason I think it is resources not freed correctly issue is because when I restart the PC I can progress from a saved point to the next crash and so on until the script reaches not so safely the promised land.