Account Right - Request contacts returning null company name for few

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
3 REPLIES 3
Partner fm-work
3 Posts
Partner
Partner

3Posts

0Kudos

0Solutions

Re: Account Right - Request contacts returning null company name for few

Hi Shaun,

 

Yes, that was the reason.

 

Thank you!

Former Staff ShaunWilde
62 Posts
Former Staff
Australia
Former Staff

62Posts

3Kudos

0Solutions

Accepted Solution Solved

Re: Account Right - Request contacts returning null company name for few

Hi 

 

Are the contacts where '"CompanyName" = null' individual or non-individual contacts?

 

e.g.

 

CompanyName is only set when it is not an individual contact i.e. "IsIndividual" = false

 

FirstName, LastName are set when it is an individual contact i.e. "IsIndividual" = true

 

 

Regards

Shaun Wilde
Ultimate Partner Geoff_
1,721 Posts
Ultimate Partner
Australia
Ultimate Partner

1,721Posts

374Kudos

0Solutions

Re: Account Right - Request contacts returning null company name for few

Hi @fm-work

 

I have never come across that before however when the word is Googled it says"Null is a special marker used in Structured Query Language (SQL) to indicate that a data value does not exist in the database"?

 

So I don't no whether that helps in your query?

Geoff
Busselton Bookkeeping Service
MYOB Bookkeeping Partner, BAS Service Provider
Phone 08 9754 7680
Highlighted
Partner fm-work
3 Posts
Partner
Partner

3Posts

0Kudos

0Solutions

Solved: Go to Solution

Account Right - Request contacts returning null company name for few

We have a customer with company file id xxxxxx .

When we request contacts, we get few of them with Company Name = NULL. How is that possible?

 

 

Any help will be much appreciated 

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post