QAD Enterprise Edition requires all US suppliers for 1099 reporting (vd_1099 = true) to have unique non-blank Federal tax IDs (ad_gst_id).

This utility reports duplicate or missing Federal tax IDs and lists VAT registration IDs that do not comply with the ISO format, when applicable. If execution of this utility is necessary, it is noted on the Data Preparation Report.

Additionally, if Validate VAT Registration in Global Tax Management Control (2.13.24, txtxcmt.p) is true, VAT registration IDs for customers and suppliers in EU countries must conform to their country’s ISO format.

If Validate VAT Registration in Global Tax Management (2.13.24 - txtxcmt.p) is later disabled (for all Domains) to eliminate VAT registration ID errors on the Data Preparation Report, the conversion does not create the validations for VAT registration IDs. If users desire such validations post-conversion, they must manually create them or install a QAD-provided XML file containing predefined validations post-conversion. They then make any necessary corrections to VAT registration IDs that fail the validations.

For eB2.1 and later, run the utility in each active domain. If the Validate VAT Registration is true for any single domain, the validation is considered true for all domains. This action is necessary because Business Relations are created from the address records and Business Relations are system-wide within QAD Enterprise Edition.

The utility provides a simulation mode that allows you to preview the effects of the update.

The report output file name is uxtaxid-<dbname>-<domain>-<date>_<time>.prn.

Correct any discrepancies identified in the report by running the utility in update mode. If 1099 reporting is required, manually correct these errors through Supplier Maintenance (2.3.1, advnmt.p).

If 1099 reporting is not used, set this field to No in the utility and it assigns vd_1099 = false for all U.S. suppliers, reducing the number of Federal tax ID errors.

Correct VAT ID errors (if applicable) through Supplier Maintenance and/or Customer Maintenance (2.1.1, adcsmt.p) and/or Company Address Maintenance (2.12, admgmt06.p), based on the values in the List column of the report. Invalid VAT IDs are listed in the State ID column of the report.

The utility only affects 1099 reporting for US-based users and only when producing year-end 1099 forms.