Skip to content

Number transformation

Phone Connect prepares stored phone and mobile phone numbers for caller lookup. It stores trimmed values in separate fields according to the configured rules. The original phone numbers remain unchanged.

Configuration

To perform the number conversion, the following steps must be executed:

  1. In the Phone Connect Admin Role Center, open Setup > Module Setup.
  2. In the module setup, select the action Number Substitution.
  3. On the Number Substitution page, you can define the special characters that should be transformed.
  4. Phone Connect provides standard trim values for the transformation of phone numbers.
  5. After completing the configuration, return to the Phone Connect - Module Setup and execute the Trim Phone Numbers function from the menu bar.

Important

The value "DEL" is used to delete the character from the phone number. Spaces are automatically removed from the phone number.

Trim Phone Numbers

Select Number preparation > Trim Phone Numbers in Module Setup to start the processing report Phone Connect Generate Config. (report 5227422). The action is available to Phone Connect administrators. Confirm the prompt to start processing in the current company. The currently processed business mapping is displayed during execution. The report does not produce a printed document.

Run the action after changing number substitutions, the country or area code, or phone number fields in a business mapping. It updates existing records using the current setup:

  1. The report processes all business mappings in the company with configured phone or mobile phone fields and all records in their respective tables.
  2. For each configured field pair, it reads the original number and calculates a trimmed value using number substitutions and the country and area codes in Module Setup.
  3. It stores the result in the corresponding trimmed number field. If the source field is empty, the corresponding trimmed field is cleared. Only changed records are saved.

Trimmed values help match caller numbers to stored records. The source fields remain unchanged. Processing may take longer when there are many records.

Prerequisites and troubleshooting

At least one business mapping with phone or mobile phone fields must be configured. For each number field, both the source field and its corresponding trimmed field must be specified. The fields must exist in the mapped table, be different from each other, and have the Text or Code data type.

If the setup is invalid, the report stops with an error. Check and correct the indicated business mapping, then run the report again. Fully processed mappings remain saved because changes are committed after each mapping.

Scheduled execution

The report can also run through the Business Central Job Queue. In the desired company, create a job queue entry with object type Report and object ID 5227422, and set a recurrence if needed. The executing user needs access to the report and read and modify permissions for the tables used in the business mappings. Background execution displays neither the confirmation prompt nor the progress dialog; errors can be checked in the job queue log.

Examples of Standard Trim Values

The following values are predefined for number conversion after completing the Checklist in the Admin Role Center:

From Value To Value
- DEL
( DEL
) DEL
, DEL
. DEL
/ DEL
| DEL
+ 00

Example

If + is replaced with 00 and no matching country or area code is configured, +49 123 456 becomes the trimmed value 0049123456. The original phone number remains unchanged.

See also