ContributionsMost RecentMost LikesSolutionsRe: Using custom data rules to cleanse data in tables?Thanks Mark. This is helpful. Just to clarify, we have several master data tables within one application. I need to compare the table where users enter information to the master data tables to ensure that the information is correct. So I'm comparing fields in the master data tables to fields in the user input table and identifying those that are not the same. ------------------------------ Marcia Miller ------------------------------ Using custom data rules to cleanse data in tables?Hi all... I was searching this morning on the internet for a "how to" on creating exception reporting in QB. I came across several posts on using custom rules to validate data during input/imports. I have a need to validate data that is currently in tables within the QB app that was developed. This app has been in existence for a few months and it looks like the data that has been added by users is not always correct. I'm trying to find a way to evaluate all the data in various tables and identify exceptions to business rules. Ideally I'd like to have a report that does this validation daily so that the data remains clean. Any thoughts on how this can be accomplished? ------------------------------ Marcia Miller ------------------------------ Using custom data rules to cleanse data in tables?Hi all... I was searching this morning on the internet for a "how to" on creating exception reporting in QB. I came across several posts on using custom rules to validate data during input/imports. I have a need to validate data that is currently in tables within the QB app that was developed. This app has been in existence for a few months and it looks like the data that has been added by users is not always correct. I'm trying to find a way to evaluate all the data in various tables and identify exceptions to business rules. Ideally I'd like to have a report that does this validation daily so that the data remains clean. Any thoughts on how this can be accomplished? ------------------------------ Marcia Miller ------------------------------