General discussion
Automatically e-mail an exported database
Forums
Hello,
I was wondering if it's possible to automatically attach and e-mail an exported database to myself? I'm trying to incorporate this into my script.
Thanks.
- Read more about Automatically e-mail an exported database
- 7 comments
- Log in or register to post comments
Smart Analyzer Routine listing and execution
Forums
Hi,
Excuse me. This might be an out of box question.
In IDEA Smart Analyzer tab, there is a 'Select and Run' option from which we can see routines imported into Smart Analyzer and execute routines.
My requirement is given below:
I have to list the routines showing under the 'Select and Run' in a separate windows application.
I would like to know if there is any library that I can refer and call method to list routines imported into IDEA Smart Analyzer.
Thanks,
Shafeer
- Read more about Smart Analyzer Routine listing and execution
- 1 comment
- Log in or register to post comments
New to Idea - Normalize Vendor Names
Forums
HELP! Is there a way to normalize vendor names in Idea? For example, AMAZON MKTPLACE PMTS to AMAZON, WAL-MART002 to WAL-MART, UPS 091238547 to UPS...etc?
The database I’m working with has at least 500,000 records.
Thanks in advance
- Read more about New to Idea - Normalize Vendor Names
- 4 comments
- Log in or register to post comments
Reasons to stop using spreadsheets for audit analysis
Forums
I just found this presentation by CaseWare on why you should stop using spreadsheets for audit analysis. Through everyone might be interested.
http://www.slideshare.net/CaseWare_Analytics/reasons-to-stop-using-spre…
Variance in totals appended versus excel
Forums
Hi Brian,
Hope you are doing good. I have a question regarding the differces found in totals with appended database and individual totals of the files.
for eg 12 months data in text imported into idea with four decimal places and to validate the appended database i have taken the total of each file from the field statistics and input the same into excel, but after appending all the 12 files i am facing a difference of more than 1000 with the appended database and the grand total of excel file. What could be the reason for this??
Thanks for your help.
- Read more about Variance in totals appended versus excel
- 5 comments
- Log in or register to post comments
Benford's Law in the Movies
Forums
I haven't seen the Ben Affleck movie the Accountant yet but I understand that he uses Benford's Law in one area. I guess he finds a larger than expected use of the number three which would entail him using Benford's law.
http://www.thewrap.com/accountant-adds-up-real-review-ben-affleck/
- Read more about Benford's Law in the Movies
- Log in or register to post comments
IDEA 10.2 has been released
Forums
Just saw this on the CaseWare Analytics web site that they have released 10.2.
https://www.casewareanalytics.com/blog/product-close-whats-new-idea-102
- Read more about IDEA 10.2 has been released
- Log in or register to post comments
6th IDEA User Conference and Anniversary Celebration
Forums
Just saw this posted on linkedin by Audimation:
We are pleased to announce that we will be hosting the 6th IDEA User Conference and Anniversary Celebration. Audimation will be 25 and IDEA will be 30!! Mark your calendars and make plans to join us in Houston, TX on November 1 & 2, 2017. It’s going to be a great time, with sessions by our expert IDEA users and hands-on training by our top-notch team of trainers. We hope to see you there! Registration will open in the spring. - Carolyn Newman
- Read more about 6th IDEA User Conference and Anniversary Celebration
- Log in or register to post comments
Calculating cumulative sum of a particular column
Forums
Hi,
Is it possible to calculate the cumulative sum of any column in IDEA?
Thanks,
Bibin
Question regarding Summarized Data
Forums
Hi,
Is it possible to get the base population file in case we are provided with only Summarized data? It is taking time to extract each summarized data (by cliking oin the number of records hyper link)and finally we need to append. Is there any easier way to do the same?. Thanks, Bibin
- Read more about Question regarding Summarized Data
- 4 comments
- Log in or register to post comments