Partner Zone
Partner Zone

Account Right - Request contacts returning null company name for few

This thread is now closed to new comments.
Some of the links 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
fm-work
Partner

3Posts

0Kudos

0Solutions

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

Hi Shaun,

 

Yes, that was the reason.

 

Thank you!

Highlighted
Former Staff ShaunWilde
53 Posts
Former Staff
Australia
ShaunWilde
Former Staff

62Posts

3Kudos

22Solutions

Accepted Solution Solved Solution

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_
461 Posts
Ultimate Partner
Australia
Geoff_
Ultimate Partner

1720Posts

373Kudos

180Solutions

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
Partner fm-work
3 Posts
Partner
fm-work
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