General discussion

 
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

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…

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.

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/

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

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

Hi,
 
Is it possible to calculate the cumulative sum of any column in IDEA?
 
Thanks,
Bibin

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

CaseWare IDEA has just released a white paper entitled 5 Key Areas to Test when Building an Effective Audit Plan.  This document has a list of tests that an auditor might perform in the areas of Accounts Payable, Accounts Receivable, General Ledger, Payroll and Inventory and Stock Data.  Well worth checking out.  https://www.casewareanalytics.com/sites/default/files/whitepapers/5_key…

Hi everyone,
I know this is a basic question, but is it possible to add one single column at a time to existing view?
I didn't see where this functionality exits in IDEA but maybe I missed it?  Any help would be appreciated!
Mike