Formatting country address layouts

Use the area located below the Address Fields field to format the address layout (Country_Addr_Layouts.ADDRESS_LAYOUT). The formatted address layout combines the component fields of the address with four formatting codes:

• [U] - Uppercase. Enter [U] before a component field to make the data in the field all uppercase. For example, [U]CITY would generate all capital letters for a city such as NEW YORK or LONDON.
• [N] - New line. Enter [N] after a component field to insert a carriage return. For example, ADDRESS_1[N] would generate a carriage return and place the next component field on a different line in the address.
• [S] - Space. Enter [S] after a component field to insert a space between component fields. For example, [U]STATE_PROVINCES[S][U]ZIP would display as TEXAS 75208 when generated in an address.
• [C] - Comma. Enter [C] after a component field to insert a comma between component fields. For example, CITY[C][S][U]STATE[S][U]ZIP would display as Dallas, TEXAS 75208 when generated in an address.

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.

Click to view image

Do the following to enter an address format:

1. In the Advanced Accounting Console, go to Settings > Membership > Set up tables > Country address layouts, or Settings > Membership > Set up tables > Country names and click Address Layouts.
2. In the Country address layouts window, click New. The Format field automatically populates with the next succeeding format code. For example, if the last format code created was 15, then format code 16 will be entered automatically in the Format field.
3. Enter a Description for the country address format.
4. Arrange the component fields in the area located below the Address Fields field to suit the desired address layout. For example, if you want the country name to display on the first line in the address layout, press Enter before ADDRESS_1[N] to move it to the second line, highlight COUNTRY and press Ctrl+X, then press Ctrl+V.
5. Enter the formatting codes in the Address Layouts field to format the address.
6. Click Save.

Make sure the country that you want to apply an address format to has been added to the Country_Names table.

Do the following to apply an address format to a country:

1. In the Advanced Accounting Console, go to Settings > Membership > Set up tables > Country address layouts, or Settings > Membership > Set up tables > Country names and click Address Layouts.
2. In the Country address layouts window, click Find.
3. Click the lookup icon in the Format field to choose the format code for the address format that you want to modify.
4. Click OK. The address format assigned to that code opens in the window. The countries for which no address formatting has been applied display in the Available Countries drop-down.
5. Click Edit.
6. Select the countries from the Available Countries list for which you want to apply address formatting.
7. Click Add to move the selected country from the Available Countries list to the Layout Applied to list.
8. Click Save to apply the address format to the country.
9. (optional) Click Test Layout to verify that the formatted address layout produces the desired result.