General discussion
Record Extractions - Error
Forums
I'm working in IDEA and I'm trying to extract specific information in a certain column. I deal with lots of data so when I'm looking for specific data only pertaining to a certain date, field or column, etc. I should be able to extract that information only. In the attached image you can see blue numbers in the NO_OF_RECS column. I should be able to to click on the blue numbers and it pull up the database for those records only. Mine is not working. No one else in my company who uses this program is having this issue.
- Read more about Record Extractions - Error
- 8 comments
- Log in or register to post comments
IDEA Tech Tip: Using PDFs
Forums
CaseWare Analytics have a new blog posting on tips on how to use pdfs. Of the four tips three of them come from this site
https://www.casewareanalytics.com/blog/idea-tech-tip-using-pdfs
- Read more about IDEA Tech Tip: Using PDFs
- 1 comment
- Log in or register to post comments
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