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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Company column empty

(0) ShareShare
ReportReport
Posted on by

Currently I'm working with Leads, using My Open Leads view and All Leads view. I've added the column Company to sort by, however every Lead entry's Company field is simply blank in these views.

Every lead does have a Company name, the field is populated properly when going to a detailed view.

Suggestions?

*This post is locked for comments

I have the same question (0)
  • jlattimer Profile Picture
    24,562 on at

    Just to confirm - did you add Company Name under Lead?

  • Community Member Profile Picture
    on at

    By default, the Company field shows up in the Lead New screen (same as double-clicking any existed Lead to edit as well)

    So I've never added it, it's part of the default configuration (brand-new install)

    So the Summary area has CONTACT and details, and COMPANY and details. Under COMPANY I have in Lead entry: Company, Web Site, Street, City, State/Province, ZIP/Postal Code, Country/Region.

  • jlattimer Profile Picture
    24,562 on at

    Could you post a screen shot of your My Open Leads view? Just asking if you added the "Company Name" field to that view or the "Customer" field - which is a lookup to an existing record.

  • Community Member Profile Picture
    on at

    Yup, I just verified that Company in the Summary area is in fact the 'Company Name' field.

    Does anyone know how to allow this to carry over to the Company column of the All Leads view?

    Is this broken for everyone else?

  • SyedHussain Profile Picture
    1,820 on at

    If you're exclusively working with the Leads entity, and you have the Company field in there, populated with data and it's not showing in the same entity view (Lead - My Open Lead) then that is weird. I would check your attributes to see if you have a duplicate "Company" attribute in there that is presented on the form but not on the screen.

    If that's the case; then do you have an on-premise install or are you online? It makes a difference. You can diagnose you're on-premise install to see what's happening by checking SQL DB to see if data is there in the right field. I don't know if this is the case.

    If it's a question of using Accounts entity or other entities and the data not being populated like it should, you can try and restore the Leads field mapping.

    Posting a screenshot of your form in customisation mode is probably a good thing.

  • Community Member Profile Picture
    on at

    I double checked everything, went through every possibility for a column. I've got the Company column selected, and it's obviously correct.

    There's a disconnect on the two machines in our firm that are using this software so far, both were installs on-premise. My setup is as an Administrator and the other computer is not. Both have the same blank Company column in My Open Leads or All Leads view.

    Leads field mapping shows that the field in data entry is called Company Name. So it seems mapped correctly. Maybe erase that field and put it back, to try to reset it?

  • SyedHussain Profile Picture
    1,820 on at

    I don't think that will make a difference but you can of course try. If that doesn't work, I would work backwards - Check DB > Check field names, mapping to see if anything is there. There might be a possibility your DB is screwed up because I can't see a reason it wouldn't show up.

    If everything is fine DB side, try exporting your record to to Excel to further diagnose.

  • Community Member Profile Picture
    on at

    Is there a quick Rebuild database?

  • SyedHussain Profile Picture
    1,820 on at

    I just saw your other post regarding the Lead entity and not using the Last name, the last name is mandatory in CRM (well somewhat), I can't remember but I think the "Last Name" maps out to the company name. I don't have CRM 2011 next to me so I can't check. Try adding some last names in your lead entity.

  • Community Member Profile Picture
    on at

    I figured out how to make the Last name (and other fields, such as Topic), Recommended instead of Mandatory. Some entries have Last name, some don't - all of that pushes through just fine. It's just Company name that doesn't.

    Someone mentioned checking the SQL DB, how is this done? Where is it located?

    Now I'm wondering - if I migrate to the 'New Experience' (which allows me to have a better native iPad experience), would this possible reset something and fix this?

    If there's trouble this way, can I go back to the 'old experience'?

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 CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans