khultquist

I had to turn this function off, it was throwing an error to some users in Chrome, but not to me. The error is seems to be user-dependent, but not role- or computer-dependant... hmmm... An unexpected error occurred in a script running on this page. init (pageInit) customform JS_EXCEPTION TypeError Cannot set property…

in Default Sub Items Tab to Items instead of Expenses for PO Comment by khultquist Feb 22, 2012 1:15PM

Yep, that space was the problem, thanks it works great in chrome.

in Default Sub Items Tab to Items instead of Expenses for PO Comment by khultquist Feb 17, 2012 9:01AM

Thanks James - I couldn't get that to work using Chrome. Is that IE only?

in Default Sub Items Tab to Items instead of Expenses for PO Comment by khultquist Jan 31, 2012 1:39PM

Something like this should work, but please be very careful, you are deleting records and if this script is misapplied, you will cause irreversible damage. I added a line to this script that forces you to use the exact name of the custom record that you are deleting. function after_submit(type) { var custom_record_name =…

in Method to not store data entered into a custom record Comment by khultquist Aug 15, 2016 4:43PM

You could do this with a User Event script: beforeLoad, check for allowed role & user combinations.

in User Permission | Custom Record Comment by khultquist Aug 23, 2016 4:43PM

If I understand correctly, this is only for cases where the script has been interrupted and <3 records were created. Which way are the loops nested? Is it Item first, then each Location? If that's the case, you might add summary criteria to the saved search, count of 'Item Inventory History' records <3. Alternatively, you…

in Custom records with complex parent/"foreign key" search Comment by khultquist Aug 10, 2016 11:08AM

I agree with the Suitelet, but if you already have it working with the custom record and are looking for a quick solution, you could create a very simple script that deletes the record nightly, or immediately.

in Method to not store data entered into a custom record Comment by khultquist Aug 15, 2016 2:17PM

My suggestion is to check for conflicting/overriding permissions in all these places: [LIST] [*]On the custom record 'Permissions' tab [*]On the custom record 'ACCESS TYPE' field [*]On each custom field on the custom record [*]On the role record [*]On the user/employee record [/LIST]

in Please Help! Custom Record Permissions Comment by khultquist Jun 16, 2016 4:38PM

A beforesubmit could catch it too. You could have a custom field (list) on the employee record for this type of permission, and then restrict new records based on this custom field.

in Permission to Edit but not Create custom record Comment by khultquist Jan 23, 2012 2:55PM

When you say 'customers being able to find them' do you mean through the webstore, or are the customers logging in with a Customer Center role? If it's the former, just remove the items from the webstore. If it's the second, you can try using 'Inactive' on the item, and make sure the role can't see inactive items.

in SCA Product Item Staging Comment by khultquist Apr 13, 2016 4:08PM

Maybe a saved summary search, with a count of related items

in If item has related items? Comment by khultquist May 23, 2012 3:10PM

You can run a saved search in javascript through the api and use your results as a variable.

in If item has related items? Comment by khultquist May 23, 2012 3:46PM

You might have to use a scheduled script and suffer the 15 minute lag.

in Is it possible to detect a Role change on a Contact? Comment by khultquist Sep 21, 2017 10:53AM

It sounds like you've created a Client script, you might want to consider this as a User Event script, which gives you the ability to limit to type=create. If you want to stick with a client script, there are a couple ways to do what you want. You can check to see if the field is empty, and then set it (see below). Or you…

in nlapiSetFieldValue script to run only once on create? Comment by khultquist Oct 12, 2017 3:15PM

You can hard code it again, or use nlapiResolveURL(type, identifier, id, displayMode) or other Application Navigation APIs to get the proper subdomain. https://system.na1.netsuite.com/app/help/helpcenter.nl?fid=section_N3059035.html#bridgehead_N3059898

in Finding the current datacenter Comment by khultquist Aug 15, 2017 2:17PM

Can you post your full script? If not, add some nlapiLogExecution(type, title, details) lines to find where the script is encountering errors.

in Rookie script writer - Error on deployment Comment by khultquist Jun 24, 2017 5:52PM

Try this code, and then you should be able to see if there are any variables that aren't getting the proper value, and you'll narrow down exactly which line is throwing the error function scheduledScript() { var searchid = '2921', searchresults = nlapiSearchRecord('transaction', searchid); if (searchresults !== null) {…

in Rookie script writer - Error on deployment Comment by khultquist Jun 25, 2017 5:04PM

To speed up testing in a scheduled script, create a new deployment of that script, making sure the keep the status as Not Deployed. Save it. Then edit it, and click Save and Deploy. It will be immediately added to the queue of scripts, no longer a need to wait for the scheduled time.

in Rookie script writer - Error on deployment Comment by khultquist Jun 23, 2017 6:22PM

Hi. For issue 1, consider changing this to a user event script (before submit) so that dependent fields can be updated. This will have an added benefit of running on records not created thru the UI. You do have to change the functions from getcurrentlineitem to getlineitem and specify the line number, but this is also much…

in Setting a Field Value On All Line Items - Exiting Loop Prematurely? Comment by khultquist May 12, 2017 4:24AM

Ok that makes sense... User Event scripts will not trigger other UE scripts or client scripts, so you will have to go back to the client script (or possibly a scheduled script). Hopefully you can get the client script to work using variables and not exiting the loop prematurely.

in Setting a Field Value On All Line Items - Exiting Loop Prematurely? Comment by khultquist May 16, 2017 10:25PM

Glad you figured this out. Adding in a bunch of debug lines will often help find the needle in the haystack! As for scaling the script, there are ways to accomplish what you are trying to do. You could create 12 searches but use only a single script, by having the script id's, fieldnames, etc in arrays, then loop the…

in Rookie script writer - Error on deployment Comment by khultquist Jun 26, 2017 9:35AM

I believe this is a read-only field, calculated by NetSuite.

in Setting Expected Ship Date on Sales Order Line Item Comment by khultquist May 2, 2017 9:40AM

'Apply WH Tax ?' {custcol_4601_witaxapplies} appears to be a custom field... how exactly does it trigger the WH tax to calculate, is there another script or workflow?

in Setting a Field Value On All Line Items - Exiting Loop Prematurely? Comment by khultquist May 16, 2017 10:03AM

You're on the right track, but nlapiGetNewRecord is going to cause you problems [h=2]nlapiGetNewRecord()[/h] Available in beforeLoad, beforeSubmit, and afterSubmit user event scripts. You are not allowed to submit the current or previous record returned by nlapiGetNewRecord. Your code would be cleaner without reloading the…

in Setting a Field Value On All Line Items - Exiting Loop Prematurely? Comment by khultquist May 15, 2017 9:30AM

I agree with pcutler this should be done server side, avoiding unpublished API. The trick on server side is to trigger the script only after once, when the copy button is used, otherwise the script will clear all lines every time that you edit the record. I believe you can use nlapiGetRecordId() to determine if this is a…

in Trigger the 'clear all lines' button on purchase request programatically Comment by khultquist Jun 20, 2017 2:24PM

Try the 'Item' field in criteria, this worked for me in a test.

in What is the best way to determine if an assembly item is used in any work orders? Comment by khultquist Apr 3, 2017 5:22PM

Hey thanks for that, I never realized there was a type = copy. I'll have to go back into my scripts and clean that up.

in Trigger the 'clear all lines' button on purchase request programatically Comment by khultquist Jun 20, 2017 4:28PM

With your latest code, you're no longer checking for nlapiGetFieldValue('custbody_containerbillcount') != '' so that's probably the difference.

in Client Script Field Change Stuck in Loop Comment by khultquist Feb 1, 2017 2:03PM

I'm not suggesting that you run this on a client... I'm showing how to get the list of all fields on a record for reference, instead of guessing what they might be.

in How to get the fields of an address from a location record using SuiteScript Comment by khultquist Jan 27, 2017 12:54PM

My guess is that nlapiGetFieldValue('custbody_containerbillcount') is NULL, but debug it like this: function onFieldChange(name){ <strong> var containerbillcount = nlapiGetFieldValue('custbody_containerbillcount'); nlapiLogExecution('debug', 'name', name); nlapiLogExecution('debug', 'containerbillcount',…

in Client Script Field Change Stuck in Loop Comment by khultquist Feb 1, 2017 1:18PM

MFA for Oracle Community

khultquist Red Ribbon

Comments