Creating Custom Address Styles
If the five address styles that Receivables provides do not suit the requirements of the countries in which you do business, you can create your own, custom address styles. You can then use these custom address styles for entering addresses for your customers, banks, suppliers, payments, and remit-to sites.
To create a custom address style:
1. Choose address style database columns.
Attention: When you set up a new address style you must decide which columns from the database you are going to use and how you are going to order them. See: Choosing address style database columns.
2. Map address style to database columns.
3. Add address style to the address style QuickCode.
Choosing address style database columns
To choose address style database columns:
- Decide which columns from the database you are going to use and how you are going to order them.
- AP_BANK_BRANCHES.ADDRESS_LINE1
- Customer and Remit-To Addresses
- PO_VENDOR_SITES.ADDRESS_LINE1
For example, notice in the Japanese address style that the address element called Province maps onto the STATE database column and that in the United Kingdom/Africa/Australasia address style the address element called County also maps onto the STATE database column.
We recommend that all custom address styles also include at least the above database columns because these address columns are used extensively throughout the system for printing and displaying.
Warning: Most reports do not display the PROVINCE, COUNTY, or ADDRESS4/ADDRESS_LINE4 database columns for addresses.
Mapping address styles to database columns
To map address styles to database columns:
To do this mapping, you must create a new context value for each of the following descriptive flexfields:
|
Bank Address
| Banks
|
Remit Address
| Remit-to Address, Customers
|
Payment Address
| Payment Summary, Payment Overview
|
Site Address
| Suppliers
|
1. Using the Application Developer responsibility, navigate to the Descriptive Flexfield Segments window.
2. Query the appropriate address descriptive flexfield and uncheck the Freeze Flexfield Definition check box.
3. Navigate to the Context Field Values region. This region contains the address styles that have already been defined for the flexfield.
4. Enter a name and description for your new address style. The name should be a short, unique code similar to the ones already provided.
5. Choose Segments, then create address elements for your address style. Each segment consists of a database column, which will store the address information, and the prompt the user will see inside the address window. The columns you assign to your address elements are restricted to the address columns that have been predefined for the flexfield.
You can also define any validation you want to use on a particular segment of your address in this region. To do this, enter an existing Value Set, or choose Value Set, then enter a new value set. See: Address Validation.
6. Recheck the Freeze Flexfield Definition check box, then save your new address style.
7. Follow the above steps to set up the same address style for each address descriptive flexfield that you use.
The address styles must be identical across all address flexfields; otherwise, you risk creating addresses that are incompatible with different windows.
Adding a new style to the address style QuickCode
To add a new style to the address style QuickCode:
1. Using the Application Developer responsibility, navigate to the Special QuickCodes window.
2. Query the ADDRESS_STYLE QuickCode.
Receivables displays all of the address styles used by Flexible Addresses.
3. To add your new address style, enter the following information:
This must correspond exactly to the name you assigned your flexfield context value in the Context Field Values region of the Descriptive Flexfield Segments window.
This should correspond to the short description you provided for your address style in the Context Field Values region of the Descriptive Flexfield Segments window.
Note: Do not enter a start or end date.
4. Enable this style by checking the Enabled check box.
See Also
Flexible Addresses
Setting Up Flexible Addresses
Entering Flexible Addresses
Maintain Countries and Territories