International address formatting in iMIS reports

International address formatting requires reports in all modules to
use the FULL_ADDRESS, Name.FULL_ADDRESS, Name_Address.FULL_ADDRESS, Orders.FULL_ADDRESS, or Order_Badge.FULL_ADDRESS fields rather than a concatenation of the individual address fields.

These fields are calculated based upon the address format associated
with the Country name in the Name Address record. Whenever FULL_ADDRESS is calculated, it is built based upon the appropriate address format.

If international address formatting is set up, these FULL_ADDRESS fields are calculated based upon the address format associated with the Country name on the Name Address record. When a new record is inserted into the database, a new ASI stored procedure called sp_asi_AddressUpdate calculates all FULL_ADDRESS values based upon the country specific address formats.

To update the FULL_ADDRESS fields for existing records in the database, you will need to execute the Run AddressUpdate script (select Utilities > Reports and Queries > Table Maintenance). This script calls the ASI AddressUpdate stored procedure that recalculates the FULL_ADDRESS fields based upon the appropriate address format.

If you have to run the Rebuild Name_Address Pointers script for any reason, please note that you will also need to run the Run AddressUpdate script in order to rebuild FULL_ADDRESS based upon the international address formats.