PST Data Validation Plug-In v1.0

 

The PST Validation Plug-In  will retrieve items from the database that have potentially corrupt data. The Data Validation tool can only test for missing data. Required fields that have invalid data needs to be corrected also. These queries will help you identify invalid data. It will fill the grid with the results from each query.

 

It will query the database for the following:

 

Account numbers that contain the Check numbers

Account numbers that Match the Check numbers

Account numbers that aren't in the lookup table

Amounts that are greater than...

Amounts that are less than...

Check numbers that contain the Account number

Check numbers that are greater than...

Check numbers that are less than...

Check numbers that are duplicated

Route + Account + Check numbers that are duplicated

Route codes that are not in the lookup table

 

 

If you want to use a date range, you can enter a date or dates to validate.