I'm in the same boat now as well. I've got 36k records that need to have the subscriptions updated and there is no way to do it thru NetSuite. Any suggestions NetSuite?

Thank you - I voted for the enhancement. I hope it makes it into the system, it would be very useful to have.

I am essentially trying to duplicate the following screenshot in my saved search so it can be used to do the analysis and also the import to create the journal entries. It is possible that the debiting account could change with future circumstances. The Debit account will be a constant, however the credit account will vary…

That worked beautifully!!! Thank you so much!

I am also trying to update a field by adding 30 days to the firstorderdate field, I've tried the example in this post and my results are really off. This is what I'm using: var firstorderdate = results[i].getValue('firstorderdate'); var esttransdate = results[i].getValue('custentity_esttransdate'); var transdate =…

I know how to add them to the actual transaction form, I need to know how to add them to the Transaction PDF form (the ones that are printed/emailed). When I put a hyperlink in the pdf, it displays the whole link instead of simply 'click here'.

Yes, if I change the custom field it is populating from a date/time or date to a free-form text the script runs without issue.

Hi all, I'm back... Same script as posted 3/5/2015 at 2:03pm, new caveat.. I released this in Sandbox and after testing it was noticed that when mass updates are done and the customer record is changed the script is not firing. It is only firing on a direct edit of the customer record. I need this to fire whenever the…

Thank you both for your help. I have the following script successfully running in Testing mode, but when released it doesn't update the field. Can you help me once more? It is set to Before Submit so I could step it prior to actually doing anything. function beforeSubmitRecord() { var recordId = nlapiGetNewRecord(); var…

I figured it out, I had to set an audience on the script. Thanks to another user who had the same issue I was able to find the solution.

I did this (which worked perfectly) however, this route doesn't actually update the contact record. I essentially need to set a check box or value of some sort on the contact record so it records an update on the contact record. Does this make sense? We are trying to update the contact records for an automated process that…

I still cannot get the script to run via mass update. I have tried if type == 'xedit' || type == 'edit" and what jbrox called out above. When creating the script I have tried User Event and Mass Update. When the user directly edits the UI it runs without a hitch, when running a mass update and even attempting to debug, the…

I have a saved activity search that is pulling in company and data from a custom field that points to a custom list that is made up of 4 values. So it is an activity search returning 2 columns (Company and MyField) with MyField having a criteria of any of Dead Lead, Marketing, Move to next steps, none. What I need to do…

Thank you so much!!!

.setSummary('max') is throwing an error...

Thank you everyone, I was able to get the script to run - much time spent in the help files refreshed my memory. :)

What would I filter on?

EUREKA!! I FOUND IT! It only took 2 days of reviewing SuiteScript API function setEmail(){nlapiSetFieldValue('email', '', null, true);} :)

If I create a new case and remove the email from the Email(s) field by selecting it and hitting the backspace key, I can save the record without error, I did have a script yesterday (don't know what the nlapi method was now) that set it to either ' ' or '-' and it threw an error. There has to be a way to do this without…

Worked beautifully! Thank you so much!!! **If anyone else needs to use this script, you will have to change if(nlapiGetRecordId() == ‘’ to if(nlapiGetRecordId() == '', if not NetSuite will throw an error at you.

So would it be: function beforeLoad() { if (nlapiGetRecordID == 'null') then {nlapiSetFieldValue('email', '', null, true);} end }

Ultimately, I'd like this to fire off when a new case form opens, not editing of an existing one so any email address entered upon creation is not overwritten. So, ultimately, it could be one or the other based on the descriptions of the new script setups. I apologize for sounding ignorant, I haven't had to write scripts…

Ok, so I got that to work, now how should the script be written to only run on create of a support case and not edit? :h_a_w:

We understand having to enter a bill variance if the amount is incorrect, however, when we try to change which GL account the transaction is going to post to we receive the same error.

Thank you.

Enhancement 81740

I'm also trying to find the same information - does anyone have any idea how to capture the data from this field? :h_a_w:

It seems it would always be false because {trandate} can be in either 2009 or 2010 or neither, but never both. So case statements in sql expressions can't evaluate 2 scenarios when actually specifying what to look for? I called out the transactions in both 2009 and 2010, and there are transactions in both years, with…

Hi, How about changing the AND to OR, see formula below: CASE WHEN ((CASE WHEN {trandate} >= to_date('1/1/2009', 'MM/DD/YYYY') AND {trandate} <= to_date('12/31/2009', 'MM/DD/YYYY') AND {item.custitem1} = 'License' THEN {amount} ELSE 0 END) != 0 OR (CASE WHEN {trandate} >= to_date('1/1/2010', 'MM/DD/YYYY') AND {trandate} <=…

The NetSuite sql expression doesn't like the + in place of the AND... I really wish it would've worked... Knowing that the result should be TRUE and its returning FALSE is driving me mad!! lol..