State Tax ID Numbers

The Address Book Additional Information - Brazil program validates state tax ID numbers if you set the processing options accordingly.

If you set the processing options accordingly, the system runs the validation routine when you click OK on the Address Book Additional Information - Brazil form. The system validates the data in the State Tax ID field (TX2) when all of the following conditions are met:

  • The processing option for Duplicate State Tax ID Numbers is set to blank.

  • The processing option for Duplicate State Tax ID Error or Warning is set to a valid value.

  • A valid state is entered in the State field in the address book record and the value of the Country Codes UDC (00/CN) for the address book record is set to BR (Brazil).

  • A valid state code exists in the State field (ADDS) in the address book record.

The validation routine does the following:

  • To validate, the system strips out alpha and special characters (!, @, #, $, %, ^, &, *, (, ), _, +, ., /) but displays the ID number in the State Tax ID field with the characters. For example, if you enter 011-445-22.5, the validation routine changes the ID number to 011445225.

    If the ID number in the State Tax ID field is an agricultural producer tax ID for São Paulo, the system allows the letter P in the first position of the ID number. For example, if you enter P100-444-8, the system changes the ID number to P1004448.

    Note: If an address book record does not have a tax ID number, you can enter the word INSENTO (uppercase) in the State Tax ID field and the system will not validate the tax ID number.
  • Stores the ID number with the special characters so that the ID number appears in reports with the special characters.

  • Recognizes that the special characters are a value that makes the number unique. For example, the system recognizes that these numbers are different:

  • 12345

  • 123.45

  • 12/345