Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I want to know LastName and PersonEmail from account. So I made sql like this:
[SELECT AccountNumber, LastName, PersonEmail, Phone, BillingPostalCode FROM Account]
But it doesn't work properly and errors.
No such column 'LastName' on entity 'Account'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names. How can I get LastName from Account Object?
Is Person Accounts feature enabled in your salesforce org?
For LastName, PersonEmail and other related fields, ensure field visibility is enabled.
If you are querying person account fields from Account object then put a where clause IsPersonAccount=True in your query.
Person Accounts combine both Contact and Account where some Contact Info is also displayed in the Account Detail page. In a person account, the Contact.Name field is displayed as the Account.Name field. To get a separate FirstName and LastName, you need to query the Contact object.
Your query would need to look more like
[SELECT LastName, Email, Phone, PostalCode, AccountId from Contact]
If you query it from Account, you'd need to do a subquery to get the Contact's LastName.
[SELECT AccountNumber, Phone, BillingPostalCode (SELECT LastName, Email FROM CONTACT) FROM Account]
You might optionally want to add WHERE clause like: WHERE Account.NAME contains Contact.LastName
IsPersonAccount=true. In which case, there are a number of Contact fields that then become available as IsPersonAccount fields that can be queried directly from Account. In either case, the fields will still exist under Contact.
Jun 18, 2017 at 21:52
If person account is enabled in your Org you will have a record type called 'Person Account' when you try to create a new account.
