3943513 Green Ribbon

I've figured it out. I've got it working on a page init script instead. also has the benefit that I can call alert() to tell the user what's going on!

nice idea. I guess I just use nlapiSetRedirectURL for that?

Hi, I'm trying to do this now using the following script: if (type == 'edit' && status == 'Processed') { var url = window.location.href; url = url.replace('&e=T', ''); window.location = url; } on a beforeLoad script. However, I'm getting an error: TypeError: Cannot read property "href" from undefined…

I'm doing this at the moment for my instance of Netsuite. My approach is to create a different form with the fields all locked down and then run a script that tests the status of the sales order (pending approval, approved, billed, etc.) and setting 'custom form' based on the status. I.e. if status = billed then set…

This is the script I use which works fine for me: function inOpenPeriod(date){ if (date == null) return true; var contractchangescloseddate = nlapiLookupField('customrecord_contractchangescloseddate', 1, 'custrecord_closeddate'); //convert date object to users date/time format date = nlapiDateToString(date); if…

so the good news is that accounting periods are now available to scripting. nlapiLookupField('accountingperiod', 135, 'periodname'); returns the period name...

I guess it will have to! I thought that it wasn't possible so knowing it's in the next release is good news... Thanks,

I've spent the past 6 months or so learning how to do scripting. Best place to start is the user guides. Go to 'Help' in the top right hand corner of the screen (next to the global search) and there are two guides you want: 1. Suitescript Developer Guide 2. Suitescript Reference Guide Read the developer guide first. You…

actually, thinking about it. I think you could run a search for clients where 'RecordA' is the parent and then run the script on that?

RecordA can have multiple child records so my guess would be that the child records has to be a sublist on Record A. Just had a look for the sublist name for the list of child records but i'm not sure it's supported for scripts: https://system.netsuite.com/app/help/helpcenter.nl?topic=EDIT_TRAN_SALESORD Can someone from…

you could change the field to be a list with values "Yes" and "No" and make that mandatory. That way the client can say "No" and then you can deal with it. other way is to use a client-side javascript on the form that checks if the field is ticked if not then it pops up to say "Please agree to conditions or something like…

Thanks Mathieu, that was it. The array returned what I was expecting when it was iterated as you suggested. Thanks!

Hi, I am trying to use nlobjRecord.getFieldValues(fldnam) in my script but I'm getting some funny behaviours. My (simplified) script is below: function beforeLoadPOTEST(type){ nlapiLogExecution("DEBUG", "Script Start", "Started"); var id = nlapiGetRecordId(); nlapiLogExecution("DEBUG", "Info", "Id:" + id); var recordtype =…

a saved search will do this. Check the help files for details on "creating saved searches" and "customizing your dashboard"

I am having the same issue as above. Did you manage to get this fixed? Your help would be much appreciated!

yep, I tried that but the comparison is still returning true whatever happens: if (nlapiStringToDate(apptendtime) <= nlapiStringToDate(appttime)) {validation = validation + 'Appt End Time is not later than Appt Time';} So if apptendtime = 2:00 am and appttime = 1:00 am the validation is still saying "Appt End Time is not…

I can confirm that this is now fixed. Converting to date object using nlapiStringToDate works. Although be warned, nlapStringToDate takes a time of day field and assumes it is today's date. This isn't always the case so be careful when running a script that you convert it to the correct date!

did anyone have any luck with this? I am trying to find the tag for the Company ID for a contact. I.e. From a contact record i want to source the ID of the Parent Company for that contact. At the moment, I can only source the NAME of the parent company (but can't source the ID). Any ideas?

you can reimport the records using the overwrite existing data option so that the zip codes are overwritten. I remember having a similar problem with leading zeros on our import. Can't remember how we fixed it but i think we had to make sure that the value in the CSV file was a text value (not a number value). If you're…

what i find most irritating is that they have pulled the free accountant role WITH NO COMMUNICATION at all! No Account Manager phone call, no email, no annoying pop up when we login to tell us. NOTHING! Netsuite's customer management is amazing (-ly poor)

afraid not...

i'm having trouble running server side scripts. Have been for the past 5 hours or so. Guess they might be related?

my script is still waiting in the queue. It's now been waiting for 3 hours! I guess there's a problem?

yep, i'm having problems too. I've only just started using server scripts though so I don't know how long they should take! I set one running at 9:09am today and it's still in the queue (it's now 11:30am!)

I am having the same issue but with all of my scheduled scripts.

I have a multi-select list that i want to show on a transaction form but i get the same "..." truncation. Is there anyway to get the list to wrap or put the list with returns after each entry?

did anyone get an answer on this? This is causing problems for me too...

i presume you'll need to use a script to do this but my skills don't reach far enough to suggest a method...

The TinyURL thing definitely won't work in that case. I had a similar problem when I did my survey. Basically, the company ID (on it's own) isn't available on the contact record. On the contact record, you need to create a custom field type Free-Form text, Store Value = T. Set it up to source: Source List = Parent; Source…

weird. When i did that the NLCOMPANY field returned data I couldn't use. The NLCOMPANY returned something like "CL100212 The Company" rather than just "CL100212". The URL needed just the CL100212 bit. Good old Netsuite behaving inconsistently... Glad it worked for you!