Solved

MS CRM 4.0 postal code field won't except 0 as first number

Posted on 2012-03-14
10
529 Views
Last Modified: 2012-03-26
I just noticed that CRM removes the first character of a zip code if it is a Zero. This is a problem because there are states such as NJ and RI that have zero as the first number in the sequence.

I was wondering does anyone know how to make CRM leave the first zero there?
0
Comment
Question by:bigjdve
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
10 Comments
 
LVL 27

Expert Comment

by:Chinmay Patel
ID: 37722173
Hi bigjdve,

How about using a text datatype? I think you tried with a number datatype.

Regards,
Chinmay.
0
 
LVL 3

Author Comment

by:bigjdve
ID: 37722185
I have looked at that since that would be the way to fix it in Excel. However in CRM that field is predetermined and is set as a NVARCHAR.
0
 
LVL 27

Expert Comment

by:Chinmay Patel
ID: 37722283
Could you take a screen shot of the attribute and post it here?
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 3

Author Comment

by:bigjdve
ID: 37722480
Here is the screenshot.
attribute.docx
0
 
LVL 27

Assisted Solution

by:Chinmay Patel
Chinmay Patel earned 250 total points
ID: 37728652
Can you check if someone has inserted custom script on this field?
0
 
LVL 3

Author Comment

by:bigjdve
ID: 37748611
Nobody has made any changes to this particular field.

Any nvarchar field that you create by default will remove any 0 from the beginning.

I am trying to find a way to not have  that happen.
0
 
LVL 29

Assisted Solution

by:Feridun Kadir
Feridun Kadir earned 250 total points
ID: 37748649
That is definitely not normal behaviour for Dynamics CRM. Are you saying this happens to any field that you create of type nvarchar?
0
 
LVL 3

Accepted Solution

by:
bigjdve earned 0 total points
ID: 37749406
It looks like I found the issue.

The attribute was set to IME_Mode = inactive

I set it to IME_Mode = auto

and now it is working.

I compared against a couple other Nvarchar fields and found the one difference listed above and tried it.

Now it works.
0
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 37749716
Amazing, IME stands for input method editor and I thought it was only relevant for languages with complicated character sets. I've never changed the setting from auto but I'm surprised that setting it to inactive has the effect that it does.  One to remember.

Thanks for the points - a fair allocation.
0
 
LVL 3

Author Closing Comment

by:bigjdve
ID: 37764974
Feridun - I am giving you 1/2 the points as your comment got me to look more closely at all of the settings on the field.

Chinmay_patel - I am giving you 1/2 as well.

After seeing comments from both experts, I was able to fix the issue myself.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Duplicate Detection - CRM 2011 2 58
CRM 2011 Decimal Out of Range 2 51
Where is user Lync data stored 4 124
Problem: Word 2016 cannot import a .vsdx created with Visio 2013 6 109
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
This collection of functions covers all the normal rounding methods of just about any numeric value.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question