Customizing the validation rules for the NACHA specification

A user can adapt the NACHA specification validation rules to meet their needs by customizing the NACHA validation rules that are provided with Common Services.

The NACHA validation rules are customized by using the data setup utility (DSU) and the following sets of workbook and properties files:
NACHA validation rules DSU files
these files are provided by Common Services and contain the validation rules that conform to the NACHA Operating Rules and Guidelines specification
Adjustment validation rules DSU files
these files are used to define the customized validation rules

To differentiate between the rules that conform to the specification and the rules that have been customized, the validation rules table uses the SPEC column. Rules that conform to the specification have a Y in the SPEC column. Rules that have been customized using the adjustment workbooks have an N in this column. When you are trying to determine why a validation rule set an error code or why an error code was not set and should have been, use the SPEC value to determine which DSU workbook set the rule is defined in.

Customize the validation rules by overriding or disabling the rules that are in the NACHA validation rules DSU files. The following sections contain more information about how to override or disable the validation rules: Table 1 shows the adjustment DSU files that correspond to the DSU files with the NACHA specification validation rules.
Table 1. DSU files used for customizing the NACHA validation rules
NACHA validation rules DSU file Corresponding adjustment validation rules DSU file
EditsNachayyyyImport.properties
Note: The specification year, yyyy, is in the name of the file.
 EditsNachaAdjustImport.properties
EditsNachaExport.properties EditsNachaAdjustExport.properties
EditsNachaXREF.xls EditsNachaAdjustXREF.xls
EditsNachaMap.xls EditsNachaAdjustMap.xls
EditsNachayyyyConfiguration.xls
Note: The specification year, yyyy, is in the name of the file.
 EditsNachaAdjustConfiguration.xls

Overriding validation rules

The following steps describe how to override validation rules:
  1. Copy the validation rules to be overridden from the worksheets in the NACHA workbooks to the worksheets in the corresponding adjustment workbooks.
  2. Modify the validation rules in the adjustment workbooks, making sure to change the value in the SPEC column to N for each rule.
  3. On the import worksheet of the adjustment cross reference workbook, change the import mode of the associated rules tables to InsertUpdate.
  4. Use the DSU to import the adjustment validation rules. Ensure that the NACHA validation rules have been imported before importing the adjustment validation rules.

Disabling content validation rules

The following steps describe how to disable content validation rules:
  1. Copy the content validation rules to be disabled from the worksheets in the NACHA workbooks to the worksheets in the corresponding adjustment workbooks.
  2. Change the edit required column to N.
  3. Change the value in the SPEC column to N
  4. On the import worksheet of the adjustment cross reference workbook, change the import mode of the associated rules tables to InsertUpdate.
  5. Use the DSU to import the adjustment validation rules. Ensure that the NACHA validation rules have been imported before importing the adjustment validation rules.

Disabling context and collection validation rules

The following steps describe how to disable the collection validation rules and all of the different types of context validation rules:
  1. Copy all of the collection or context validation rules from the worksheets in the NACHA workbooks to the worksheets in the corresponding adjustment workbooks.
  2. Remove the validation rules that are to be disabled from the worksheets in the adjustment workbooks.
  3. On the import worksheet of the adjustment cross reference workbook, change the import mode of the associated rules tables to Replace.
  4. Use the DSU to import the adjustment validation rules. Ensure that the NACHA validation rules have been imported before importing the adjustment validation rules.