General discussion
Access Import Format not found in Import Assistance
Forums
Hi All,
Can any one help me in this issue please , i did not find in the Import Assistance Tab the Access Format and I am using IDEA 10.3.0.1139 (X86 Unicode) Thanks
- Read more about Access Import Format not found in Import Assistance
- Log in or register to post comments
Site will be offline during July
Forums
Hello everyone, I just want to let you know that the site will be offline sometime in July for an upgrade along with a move to a new host. Depending on how things go this could be over several days.
Brian
- Read more about Site will be offline during July
- Log in or register to post comments
Internal Auditors
Forums
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
- Read more about Internal Auditors
- 5 comments
- Log in or register to post comments
How to make a join with scripting - Criteria problem
Forums
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"
CIDA
Forums
Just got an email that I qualify to take the CIDA exam and wonder how useful having that certification actually is? I'm a CFE and have the IIA's Certified Govt Audit Professional.
- Read more about CIDA
- 1 comment
- Log in or register to post comments
Complete Guide to Auditing with Data Analytics Tools
Forums
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
Forums
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.
- Read more about Webinar on Custom Functions
- Log in or register to post comments
Empty Tables corrupting joins
Forums
Hello,
- Read more about Empty Tables corrupting joins
- 1 comment
- Log in or register to post comments
Thank you Brian
Forums
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!
- Read more about Thank you Brian
- 3 comments
- Log in or register to post comments
cost of IDEA and SDK
Forums
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.
- Read more about cost of IDEA and SDK
- 1 comment
- Log in or register to post comments