Forum Discussion

MarciaMiller's avatar
Qrew Member
3 years ago

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
No RepliesBe the first to reply