Best Of

@Zeen You're welcome!

I understand that clients ask for things, but sometimes, they ask and expect things without properly thinking them through.

I suspect that VersaPay withholds their fees from payments - as most others do. However, you can't just magically pass those fees onto customers without communicating and agreeing with your customer that they will pay them.

IE- a line added to my $100,000 invoice for an item related to credit card fees could bring my invoice total to $102,900.00. Now, as a client, I can pay that invoice.

The negligent amount of the fees to cover the cost of me paying the fees has to be eaten by your client.

The simple way to put this is that you cannot collect money from customers that isn't owed by customers. For a customer to owe, it either must hit AR or be captured on a cash sale. One or the other.

Hi @User_6S2Q2 , I had a look over the help text and there's nothing that jumps out to suggest a limitation. It could be worth testing.

However, I'd challenge the business requirement on having > 1000 segments to understand why.

Hello @User_F5QAS

There are a few things you should do.

First - review your undelivered emails. Lists>Mailing>Undelivered emails

Next review your bounced emails. Lists>relationships>Bounced emails.

If an email is undelivered, NetSuite captures that and won't send new emails to that address unless their bounced email is cleared and the reason for the bounce is resolved. Often emails bounce because senders don't fill out their profile at Home>Set Preferences. Without having a sender, many hosts reject the emails.

Give it a try and let us know?

Hi @User_00DQF

I agree with Francesca's response that the LCS is a great place to learn how to build saved searches. If your company find's that the LCS pass is out of budget then you could pay consultants for this training. If that's also out of budget, you can find some great sources on YouTube going through the basics and more advanced searches. You can also check out SuiteAnswers for some introductory information.

@Kedalene , you may navigate to the license manager via Setup > License Client > License Dashboard. On this you should have an entry for "Electronic Payments" if it's active.

If it doesn't appear here, you'll need to confirm that it's part of your license. It doesn't appear on the Billing Information page.

Hiya, I believe this should work, though I wasn't sure in my instance what fields I could use to test the minuets on. I see you're converting the dates into MM/DD/YYYY HH24:MI:SS, so you may just need a little tweaking to it, but the math of my process and how I end up with a concatenated string of hours and minuets should fit your need.

TO_CHAR(FLOOR(ABS(({actualproductionenddate} - {trandate}) * 24)))

|| ':' ||

CASE

WHEN MOD(ROUND(ABS(({actualproductionenddate} - {trandate}) * 1440),0),60) < 10

THEN '0' || TO_CHAR(MOD(ROUND(ABS(({actualproductionenddate} - {trandate}) * 1440),0),60))

ELSE TO_CHAR(MOD(ROUND(ABS(({actualproductionenddate} - {trandate}) * 1440),0),60))

END

Hours
TO_CHAR(FLOOR(ABS(({actualproductionenddate} - {trandate})) * 24: converts days into hours and makes sure the value returned is a positive. Floor removes decimals to round down and To Char returns a string.

Concatenate
Now that we have the hours, we concatenate : to it and then begin to calculate the minutes.

Minutes
The CASE WHEN will first check if the minuets returned by the formula are < 10 and if so will then return minutes prefixed with a 0 so that 1 hour 9 min would become 01:09 instead of 01:9.

The formula itself:
TO_CHAR(MOD(ROUND(ABS(({actualproductionenddate} - {trandate}) * 1440),0),60))
We first calculate the total minutes with ABS(({actualproductionenddate} - {trandate}) * 1440)
We multiply the difference between the dates by 1440 minuets in a day
Then we ROUND 0 that value to whole minutes
Then we MOD 60 to remove the hours of minutes and return the remaining minutes
Then convert it to a string to concatenate everything together - Hours + : + Minutes

Possible improvement: work out how to use the value from MOD as the hours instead of calculating hours in a separate formula.

I dunno if this is possible with the default fields. I think you would need to build your own field that references and links to the contact list so you have more control over the data type.