web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Increasing Field Length in Customer.emailAddr from 30 to 50

(0) ShareShare
ReportReport
Posted on by 455

 Is there an easy way to increase the field length without screwing up the customer table.

 

Thanks

Kevin

 

*This post is locked for comments

I have the same question (0)
  • Toni Savage Profile Picture
    260 on at
    Re: Increasing Field Length in Customer.emailAddr from 30 to 50

    There's really no way to increase any field length... they may have made it longer in version 7 FP1, which is more email-oriented.

  • Brian Kuehl Profile Picture
    30 on at
    Re: Re: Increasing Field Length in Customer.emailAddr from 30 to 50

    ISIS software has a product called Expanded Master Information that provides you with 75 fields (dates, values, characters) that you may be interested in. Some of the character fields can be made at least 50 characters long. I've used this for the way you've described so that the email address would fit.

    Of course you'll also have to modify any reports that would need this information as well.

    Brian Kuehl

    ePartners, Inc.

  • George Sagen Profile Picture
    1,005 on at
    Re: Re: Increasing Field Length in Customer.emailAddr from 30 to 50

    You made me curious, so I just checked v7 and it's still 30 characters. I have an idea I'd like to test. What about creating a contact record for the customer in the Exchange Global Address Book and setting their Alias value to their customer number or something short? Then put the customer # in the e-mail address field. I don't know if the Exchange Global Address book is available to the sending application for alias resolution, but it might be worth a try.

  • Toni Savage Profile Picture
    260 on at
    Re: Re: Re: Increasing Field Length in Customer.emailAddr from 30 to 50

    And you made ME curiouis... so I checked SL7 FP1 (where the address fields are increased)

    The email field is now 80 characters!

  • George M Sagen Profile Picture
    165 on at
    Re: Re: Re: Re: Increasing Field Length in Customer.emailAddr from 30 to 50

    Schweet! Now I don't need to do my contortionist test using global address book. I was so looking forward to it...

  • kevinmcg Profile Picture
    455 on at
    Re: Re: Re: Re: Re: Increasing Field Length in Customer.emailAddr from 30 to 50
    Ok, so here's the Big question we have the SL6.5 Manufactures Version with Work order and Om Management and ASI email addon , do I spend the time doing the whole conversion up to SL 7.0 for just one field. ?
  • Toni Savage Profile Picture
    260 on at
    Re: Re: Re: Re: Re: Re: Increasing Field Length in Customer.emailAddr from 30 to 50

    No, ALL the address fields are larger. If you have international addresses, or just need more room for longer names, that's a plus. 

    And the BIGGEST things that people like seem small:  Editing a field now inserts rather than overwriting, and you can SORT on nearly all grid screens.  (If a vendor says, did you pay my invoice xxxx, you can sort in the documents tab of Vendor maint on vendor invoice number, for example.  Or by date)

    And they added more things you can email (I'm not sure what... haven't dealt with that yet)

     Note that this assumes you went to the FEATURE PACK.  The FP is the equivalent of version 7.5 in the old terminology.  It is much more than a service pack.

  • kevinmcg Profile Picture
    455 on at
    Re: Re: Re: Re: Re: Re: Re: Increasing Field Length in Customer.emailAddr from 30 to 50

     When we converted from Solomn 2.04 to SL 6.5 in Nov 2007 they actually left the 7.0 disk to Upgrade in the future but there was a whole process converting OM and our customizations. I may have to build another server and run some tests on an off-production server before we go ahead.

    Thanks

    I have been the Sysadmin for our company and have been using Solomon from the old 1.4 Netware days. This new version sounds like a good choice.

      

  • Toni Savage Profile Picture
    260 on at
    Re: Re: Re: Re: Re: Re: Re: Re: Increasing Field Length in Customer.emailAddr from 30 to 50

    It's a good choice especially because it's Windows 7 compatible, and soon that's all you will be able to get on workstations.

  • George Sagen Profile Picture
    1,005 on at
    Re: Increasing Field Length in Customer.emailAddr from 30 to 50

    You'd be robbing yourself if you didn't at least check it out in your test environment.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans