SPNM - Country Code Maintenance

New features added, version 7.5.2, 7.5.4R4, 8.4R4

 

images\btn_see_also_programs64.gif

 

Program SPNM, Country Code Maintenance, is used to enter country codes for your financial enterprise. You can maintain the codes, their names, their currencies, and their deletion flags.

The full ISO standard country list is loaded with NDS Applications, including both 2 character and 3 character ISO standard country codes. Country codes and country names cannot be entered multiple times.

Use program GMCP, Country Purge, to purge country codes for which the delete flag is set to on in this program.

See Also

Zip Code Formatting and Validation by Country Code

Entering Country Codes

Deleing Country Codes

SPNM Action Buttons

Zip Code Formatting and Validation by Country Code

Zip code formatting and validation for sales order entry is set up by country code in this program.

When a zip format mask is entered for a country code, the zip or postal code entered during sales order entry will be formatted as follows:

*   When the zip code is entered on the sales order address, any separators that were entered are removed.

*   The format mask is applied to the entered zip code.

*   If characters in the resulting formatted zip code violate restrictions imposed in the format mask, the zip code format is invalid. The sales order entry programs will return an error message if the format is violated, and entry cannot continue until the zip code format is corrected.

*   The [Reformat Existing Zip Codes] button should be used when the format mask is changed, as changing the format mask can invalidate existing zip codes. When pressed, this button will mass change all zip codes to use the new format in open sales orders, customer records, dealer records, prospect records, mailing addresses, and tax rates.

When the country has the Validate Zip Code checkbox set to on, the zip codes entered during sales order entry are validated against the zip codes entered in program SPZM, Zip Code Maintenance. If there are separators in the entered zip code, validation is applied to all portions of the zip code.

*   If a zip code entered on a sales order does not exist in program SPZM, Zip Code Maintenance, the program will return either an error or a warning, based on the setting of the OE_ZIP_WARN_ONLY parameter in program MURM, Initialization Parameter Maintenance.

*   When the OE_ZIP_WARN_ONLY parameter is set to Y, a warning will be displayed.

*   When the OE_ZIP_WARN_ONLY parameter is set to N, an error will be displayed, and the zip code must be corrected before the sales order can be saved.

*   It is recommended that this feature only be used in cases where the existing customer master and ship to zip codes are known to be mostly valid and all zip codes for the country are set up in program SPZM, Zip Code Maintenance.

Entering Country Codes

1. Press [New Record].

2. In the Country field, enter the 3-character country code.

3. In the 3166 field, enter the 2-character country code.

4. In the Name field, enter the description.

5. In the Currency Code field, enter the currency for the country.

6. In the Zip Format Mask field, enter the format mask for zip codes entered for this country during sales order entry. The following entries are valid.

*        A Alpha characters (A-Z) only in this position.

*        9 Numeric characters (1-9) only in this position.

*        X Alpha or numeric characters allowed in this position.

*        - , + : ; / . <space> The entered separator character should be inserted in this position.

*   See the Zip Code Formatting and Validation by Country Code section for information about this feature.

7. Set the Validate Zip Code checkbox to the desired setting.

*   When set to on, zip codes entered on sales orders will be validated against zip codes defined in program SPZM, Zip Code Maintenance.

*   When set to off, zip codes entered on sales orders will not be validated against existing zip codes.

*   See the Zip Code Formatting and Validation by Country Code section for information about this feature.

8. Press [Commit].

9. Set the Est Frt Allowed flag to the desired setting. Set this flag to on to allow custom calculation of estimated freight for this ship via code on sales orders.

Deleting Country Codes

1. Set the Delete flag to on for the code that you want to delete.

2. Press [Commit].

3. Use program GMCP, Country Purge, to delete the codes with the Delete flags set to on.

SPNM Action Buttons

Reformat Existing Zip Codes

This button should be used when the format mask is changed, as changing the format mask can invalidate existing zip codes. When pressed, this button will mass change all zip codes to use the new format in open sales orders, customer records, dealer records, prospect records, mailing addresses, and tax rates.