I am looking for some some best practices for storing phone numbers for customers in JDE E1 address
We have been using JDE for a long time.
We store phone numbers for the customers as well as for all of their who's who contacts. For the customer, they store the name of the individual in the same field as the phone number to know's phone number it is. For example, "123-4537, chris". A screen shot is attached as an example.
At the who's who level that practice is less common.
These phone numbers are not valid and can not be used to automatically identify who the caller is using the Caller ID.
The question is, how to avoid the need of storing names in the number. Have anyone else run in to similar problem?