Validate Tables

Data Source: PFWTAB

To open the Validate Tables screen, hover over the Configuration link from anywhere within IntelliDealer and select Utilities> Validate Tables from the drop down list.

The Validate Tables screen allows you to submit a table validation to a batch. This process validates all table configurations to ensure that there are no conditions that may cause problems throughout the system. For example all G/L account numbers are validated to ensure they exist and are active accounts. A report is generated that will identify the specific table that need to be fixed.

Note:  Any tables found to have an error with the severity of 30 and above will halt billing runs and the database and will need to be addressed immediately.

The following fields appear on the Validate Tables screen:

Field Description
Company

Enter the company code of the location you wish to perform a table validation on.

The company code or AA for all companies.

Division

Enter the division code of the location you wish to perform a table validation on.

The division code or AA for all divisions.

Branch

Enter the branch code of the location you wish to perform a table validation on.

The branch location number or AA for all branch locations.

The following buttons allow you to complete your work on the Validate Tables screen:

Button Function
Submit Submits the job to the batch.
Close Closes the Validate Tables screen without submitting the batch and returns to the Configuration Quick Links screen.