Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Custom Entity Field (Customer) Formula - Primary Contact Fields
Hi All,
I'm trying to create a custom field on the customer record which displays the full name (including salutation) of the customer's primary contact. I'm using a formula as follows:
{contact.salutation} || ' ' || {contact.firstname} || ' ' || {contact.lastname}
The problem is that this seems to be taking each of these fields from different contacts (not only the primary contact).
For example, one customer has the following contacts:
1) Mr Joe Bloggs - Primary Contact
2) Ms Jane Doe - Accounts Payable Contact
The custom field would display - "Mr Jane Bloggs"
Is there a problem with my formula or is this a problem in Netsuite?
0