Documentation
Documentation

Settings: Addresses

Address settings allow you to customize address formats for addresses all over the world. To access these configuration settings, go to Settings > Addresses.

Address formats

Address formats are standard formulas for shipping addresses and are associated with countries. iMIS comes with several out-of-the-box formulas that are already set up for you to use. You can Select to edit the out-of-the-box address formats, or you can add new ones. Before you create a new address format, review one of the existing out-of-the-box formats as an example. From the Staff site, go to Settings > Addresses > Address formats.

The following address formats outlined in the table below are predefined for specific countries. For example, format 12 is applied to Bulgaria, format 13 is applied to Japan, and format 14 is applied to Korea. It is recommended that you review these formats to be sure that they fit your business needs. If necessary, you can modify the formats (change the format that applies to a country). For countries that have not had address formats applied to them, you must format address layouts and apply them to the countries.

Click to view table
Format Address Layout
0

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

CITY[C][S]STATE_PROVINCE[S][S]ZIP[N][U]COUNTRY

3

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

[U]CITY[N][U]ZIP[N][U]COUNTRY
4

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

[U]ZIP[S][U]CITY[N][U]COUNTRY
5

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

[U]ZIP[S][U]CITY[N]STATE_PROVINCE[N][U]COUNTRY
6

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

[U]ZIP[S][U]CITY[S]STATE_PROVINCE[N][U]COUNTRY
7

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

[U]CITY[S][U]ZIP[N][U]COUNTRY
8

CITY[N]ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

ZIP[N]STATE_PROVINCE[N][U]COUNTRY
9

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

CITY[N]ZIP[S][U]COUNTRY
10

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

ZIP[S]CITY[N]STATE_PROVINCE[S]COUNTRY
11

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

[U]ZIP[S][U]CITY[N][U]COUNTRY
12

COUNTRY[N]STATE_PROVINCE[N]ZIP[S]CITY[N]

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]
13

COUNTRY[N]ZIP[S]STATE_PROVINCE[S]CITY[N]

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]
14

COUNTRY[N]ZIP[N]STATE_PROVINCE[S]CITY[S]

ADDRESS_1[S]ADDRESS_2[N]ADDRESS_3[N]
15

ADDRESS_1[N]ADDRESS_2[N]ADDRESS_3[N]

[U]CITY[N][U]ZIP[N][U]COUNTRY
Required address field formatting codes

Use the available fields 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 (In the Advanced Accounting Console, 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.

Creating a new address format

Do the following to create a new address format:

  1. From the Staff site, go to Settings > Addresses > Address formats.
  2. Select Add address format:
    1. 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.

      2. 📘 Note

      If a new format was created and saved with the number 15, and then later deleted, the next address format created will still be 16, and not 15 again.
    2. Enter a Description for the country address format.
    3. Begin selecting components to populate the Formula.
  3. Click Save.
Applying an address format to a country

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

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

  1. From the Staff site, go to Settings > Addresses > Countries.
  2. Select the desired country.
  3. From the Address format drop-down, select the correlating address Format code.
  4. Click Save & Exit.
Countries

iMIS comes with several out-of-the-box countries that your organization can begin using. You can edit a country or add a new one that iMIS does not have:

  1. From the Staff site, go to Settings > Addresses > Countries.
  2. Select Add new country.
  3. Enter in the full Country name.
  4. Enter the two-letter Country code.
  5. Enter the ISO 3-digit code for the country.
  6. Select the Address format you want associated with this country.
  7. Select the Default shipping method when shipping orders. The values in this drop-down are populated using the SHIP_METHOD general lookup table.
  8. (optional) Enable Use GST/HST/GSTINC style taxation if this country uses GST/HST/GSTINC style taxation.

    9. 📘 Note

    This option only appears if the default organization is configured for GST style taxation.

  9. The following options appear if the default organization is configured for VAT:
    • (required for EU member countries) The EU country code is a two-character code assigned to each European member country. Enter a code in this field if the country is an EU country.
    • (required for EU member countries) Intrastate code - The intrastate code is a country code that is used on intrastate reports. These reports list the transactions between an organization and customers from EU member countries.
    • Since code lengths vary by country, you can automatically validate the number of characters entered by specifying code length parameters in the Minimum size of VAT number and Maximum size of VAT number fields.
    • To automatically validate VAT codes, you can write a VAT validation procedure and attach it. In the Validation procedure field, enter the name of the stored procedure to run against any VAT codes entered into the system.
  10. Click Save.