MJPNUH

Something like SUBSTR({zipcode}, 1, (LENGTH({zipcode}-3)) Hey JCirocco That worked a treat, very slight tweak to order: SUBSTR({zipcode}, 1, (LENGTH({zipcode})-3)) Thanks a lot.

in Trim trailing 3 characters from string Comment by MJPNUH Jan 5, 2018 11:57AM

Hello, Sorry for the delay in response. Just thought I'd let you know this works perfectly now thanks to your formula. Not sure why I didn't think to try the IS Statement. Cheers

in SQL Help - CASE WHEN Blank Date Field Comment by MJPNUH Nov 28, 2011 6:35AM

Hello, I am trying Find the difference between a customers first purchase date and last purchase date. I am trying to achieve this using a transaction search that looks at all sales orders which are closed. In the results I then have 'date closed' twice, one that has the minimum date and the other shows a maximum date. Is…

in 100 Ways to Use Formula Fields Comment by MJPNUH Sep 7, 2010 10:50AM

Good to know we're not alone, Stability has been a real issue over the last month or 2.

in NetSuite Slowdown Comment by MJPNUH Mar 9, 2017 6:44AM

Anyone else suddenly getting timeout's/poor performance again?!

in time-outs with eu2 Comment by MJPNUH Feb 7, 2017 5:33AM

[h=2]RECENT POSTS[/h] 2/7/2017 A datacenter-wide incident in our EU Central facility has resulted in a degradation in performance for customers local to that datacenter when attempting to access accounting functionality. Operations Engineers were notified of the issue by monitoring and are working to resolve it as quickly…

in time-outs with eu2 Comment by MJPNUH Feb 7, 2017 7:14AM

I haven't tried editing products but performance certainly does seem terrible today. We do have an error coming up when trying to attach PDF's to invoices using the advanced PDF/HTML templates. I've had to revert all our Transactions forms back to simple PDF's for now. Also when trying to attach something to an email from…

in Netsuite down? Comment by MJPNUH Oct 23, 2015 7:27AM

Hmm, it was supposed to be an embedded pic of the https://status.netsuite.com/status_en_US.html

in NetSuite Malfunctioning Comment by MJPNUH May 23, 2014 8:31AM

Oh Dear....

in NetSuite Malfunctioning Comment by MJPNUH May 23, 2014 8:31AM

It's been fine all week (since the issues last Thurs/Friday), but today we just seem to be getting random bouts of slow page loads. It then seems fine for a bit and then someone else shouts out...

in Performance Issues Comment by MJPNUH Mar 28, 2014 10:08AM

We're down now?!

in Netsuite down? Comment by MJPNUH Mar 21, 2014 9:43AM

Is anyone else seeing horrible performance since 3PM UTC? We're nearly at a stand still!

in Netsuite Down in UK??? Comment by MJPNUH Feb 7, 2014 11:18AM

Just an FYI, it seems that one of the NetSuite sending IP's is currently on a Spamhaus Blacklist. Defect #- 252154 SUMMARY: Spamhaus Block: [167.216.129.170] blocked by Spamhaus-ZEN

in Problems with emails sent from NS not getting received Comment by MJPNUH May 24, 2013 5:30AM

Hi both, I had wondered, thanks confirming. I'm not our scripting guy here so I'll see what they say :) Thanks Mike

in Update Opportunity Fields from Customer Record Comment by MJPNUH Jan 19, 2017 4:29AM

Hello, I've just started to play with workflows too and whilst the example on help is very easy i can't seem to create one that completely different. I'm trying to set a workflow up that will 'Close' all scheduled calls when a Lead becomes a prospect. It'd be perfect if i could remove only the phone calls in certain sales…

in Workflow great if you know it! - Who does? Comment by MJPNUH Oct 8, 2010 12:00PM

MJPNUH Green Ribbon

Comments