Understanding Batch Validation

You can also select multiple customers or suppliers from the Address Book Master table (F0101) and perform a batch validation using the Validate VAT ID VIES program (R74101). You perform the batch validation in one of the three modes that you set in the processing option:

  • Validation Mode First Run: If you select this mode, the system processes the records that you select in the F0101 table and saves the valid VAT identification numbers in the F74101 table. The system also generates a report listing the VAT identification numbers that are validated successfully through VIES. If the system finds an error in the process, it logs an error message in the work center with details about the address number and the error returned from VIES. The system also generates an exception report of the VAT IDs that did not validate successfully.

  • Validation Mode Re-Run (for existing records in the F74101 table): If you select this mode, the system processes related records from the F0101 and F74101 tables according to the date range entered in the processing option. It also generates a report listing the VAT IDs that were validated successfully through VIES. If the system finds an error in the process, it logs an error message in the work center with details about the address number and the error returned from VIES. The system also generates an exception report of the VAT IDs that did not validate successfully.

  • Display Mode: If you select this mode, the system displays records from the F74101 and F0101 tables. The system does not perform VIES validation in this mode.

Note: The Validation Mode First Run and the Validation Mode Re-Run modes validate only those records that have their country and tax identification number set up in the Address Book system and the corresponding country setup is complete in the VIES Validation UDC table (74/VV).
Note: After you activate the VIES Validation, you can override both the VIES validation and the existing JD Edwards EnterpriseOne validation by entering 0 (zero) in the Personal/Corporation Code field in the Address Book Revision program. In this case, the system will not perform a validation. You will still be able to enter a tax ID and save the address book record, but the F74101 table will not contain a related record.