IDEA 11.2 released 13-Oct-2020 updates the analytic, Duplicate Key Exclusion: You can now view output of all the records that are related to the unique duplicate key exclusion.
There are 36 reversals (18 pairs) in the sample file, 20 instances (10 pairs) where the amount is reversed and later posted again. The CONTROL TOTALS for the AMOUNT field should match before and after. The point is to remove reversals PRIOR to running any analytics to identify duplicate transactions.
By Kris Willison Kris joined the Professional Services team in January of 2015 as a Solutions Specialist. She has an extensive background in Software and Database Development accumulated from thirty years in IT support with twenty years’ experience in database development, cleanup, audit and migration using Microsoft Access. In her time with Audimation, she has received client praise for her “Top Tier” engagement on Monitor and Scripting projects. Kris enjoys looking at problems from new angles to determine the most efficient means of meeting the clients’ needs. Kris has been breeding/showing purebred Balinese cats since 1972 and Oriental Longhairs since 1996. She also hosts one of the largest online pedigree database sites for Siamese and related breeds with nearly 600 users worldwide.
May 19
The Association of Certified Fraud Examiners (ACFE) 2012 Report to the Nations estimates ‘that the typical organization loses 5% of its revenues to fraud each...
Jul 27
Originally published in the June 2017 issue of Strategic Finance.
Written by Kurt Reding, Wichita State University, & Carolyn Newman, Audimation Services
...
Nov 15
Ottawa, Canada, December 4, 2017 – CaseWare Analytics, the developer of data analysis software for auditors, accountants and other finance professionals, ...