In a Customer record saved search, set the criteria logic to be,

• • Return a list of customers where the transaction/item’s ID is –None–

Hi Maira,
Email delivery is a big topic with lots of variables. Here’s several that I’m aware of. Noting that we are doing more with WhatsApp, Telegram and other chat messaging to connect with customers. Email seems to have a low open rate.

Do your recipients have your sending domain white-listed with the receiving account.

Sometimes, recipient’s inbox-actions can result in your emails being reported, by the receiving system, as abuse or SPAM, which affects delivery.

The email was delivered but deposited to the recipient’s junk folder and they just didn’t see it.

The recipient’s past inbox-behavior, with your emails, is causing the receiving system’s AI to quarantine them. So, they don’t appear in inboxes.

Are you using NetSuite’s default email system or sending email via a 3-d party SMTP server. Have you got SPF, DKIM and DMARC aligned, if you are identifying email with your corporate domain? This is related to your reputation.’

Best,
Stephen

Thanks Ramu,
I was able to get this handled, for my use case, in the search results.

Item: Date [Seminar start date]
Summary Type: Maximum

This listed items with the most recent date.

For clarity, we present seminars and people attend the same seminar every year. So, we have multiple attendance records over time for a client. Hope that helps with why would someone purchase the same seminar over and over? 🙂

I went with a script that inputs lat/lng based upon the customer shipping address.

One thing to be aware of, when we first enabled the script, it began to run on updating the entire database. We incurred a bill from Google for geocoding. There’s is a limit of 2,500 records a day and after that billing applies

We build a queuing system so as not to exceed 1,000 records and our system is working well.

Adding to Sam-I-Am’s suggestion, we use a workflow to send invoice emails.

We have three companies working with different currencies (AUD, EUR, USD) and have created three custom email templates, one for each company/currency. The workflow controls which template is used, based on the company.

Vishal,

Before accepting someone else’s point of view about what happened i.e. ‘de-linked all the existing bills’ you need to assess several records that changed due to the mass update, and establish exactly what changed with those records and when.

Then, from what you discover,  investigate if it is possible for a de-linking to occur. If it is not, and you are clear, then investigate records that were de-linked and see if there is any correlation e.g., dates/times, or was it something else.

System notes is your friend.

It appears, via the map link, NetSuite sends the actual client address to Google Maps, which then geocodes it and populates the map.

I discovered there is some functionality in in Suite Answers:

•  Get the Latitude and Longitude Value of an Address Using Google Geocoding

Has anyone used this before or have examples of its use?