khultquist

Check out the API Governance and Script Usage Unit Limits pages in help. In a client script, you are allowed 1,000 units. Each record created costs 10, each record submitted costs 20, for a total of 30 per record. 1,000 units / 30 units per record = 33 records. So no, there's nothing wrong with the efficiency of your…

in Script execution usage limit exceeded Comment by khultquist Jan 12, 2017 4:22PM

Using the browser console, I loaded a Location record, then used .getAllFields() to see all the field names available. From here you should be able to test them out and see which ones give you the values you need. 1:"custrecordlocation_..." 2:"custrecordlocation_..." 3:"custrecordlocation_..." 4:"custrecordlocation_..."…

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

Also, checkout nlapiCopyRecord(type, id, initializeValues), you could reduce your code and future-proof it by copying all field values from the original, then change your quantity and createdfrom fields.

in Script execution usage limit exceeded Comment by khultquist Jan 12, 2017 4:32PM

A couple of things... Are both fields 'Date' types in NetSuite, or is either of them 'Date/Time'? Try using the NetSuite function nlapiStringToDate() instead of Date.parse() function ValidateLineDate() { var lineDate = nlapiStringToDate(nlapiGetCurrentLineItemValue('item', 'custcol1')); var expectedClose =…

in Script Works in Chrome but Not Firefox or Edge Comment by khultquist Sep 8, 2016 11:03AM

Yep, what David says. The type of your sublist should be 'item' so something like this function ValidateLineDate(type) { if (type == 'item') { var lineDate = nlapiStringToDate(nlapiGetCurrentLineItemValue('item', 'custcol1')); var expectedClose = nlapiStringToDate(nlapiGetFieldValue('expectedclosedate')); var msg = "The…

in Script Works in Chrome but Not Firefox or Edge Comment by khultquist Sep 9, 2016 4:27PM

Glad that fixed it! Also, you can clean up the code quite a bit like this function ValidateLineDate() { var lineDate = nlapiStringToDate(nlapiGetCurrentLineItemValue('item', 'custcol1')); var expectedClose = nlapiStringToDate(nlapiGetFieldValue('expectedclosedate')); var msg = "The date on this line is earlier than the…

in Script Works in Chrome but Not Firefox or Edge Comment by khultquist Sep 8, 2016 12:01PM

You should use a for loop instead of hard coding. I'm not sure why it would work in sandbox but I would suspect it's in your dates.reduce function. function EarliestLineDateVExpectedClose() { var numLines = nlapiGetLineItemCount('item'); var expectedClose = nlapiStringToDate(nlapiGetFieldValue('expectedclosedate')); var…

in Script Works in Chrome but Not Firefox or Edge Comment by khultquist Sep 12, 2016 10:15AM

It can be hard to get the field names in lines, and al3xicon is right about using the SuiteScript Records Browser. There are a few other ways too, you can look at the html source and kinda get the field name. But even better is to write a script that returns the field name when the field value is changed. Create a Client…

in Multiple actions based on value of Sales Order Line Item Comment by khultquist Aug 17, 2016 11:03AM

The syntax for column search is nlobjSearchColumn(name, join, summary) so I think your code should be var columns = new Array( new nlobjSearchColumn("tranid",null), new nlobjSearchColumn("trandate",null, null), new nlobjSearchColumn("custbody7"), new nlobjSearchColumn("memo"), // Fields for custrecord1 new…

in Bug With nlobjSearchColumn and fields with same name Comment by khultquist Aug 11, 2016 12:29PM

You cannot set quantityonhand or quantitycommitted, these are read only fields on Item records. To adjust quantities, use Transaction records.

in setLineItemValue - not working? Comment by khultquist Aug 11, 2016 11:58AM

By 'alert' do you mean through the user interface? An email alert would be pretty simple.

in Alert from an xedit field change Comment by khultquist Jul 28, 2016 4:36PM

My guess is that you are not using aftersubmit, but actually using beforesubmit. In order to use aftersubmit, you would need to reload the record, change the value of nextapprover, then submit again. Here's some suggested code (untested) function setNextApprover(type) { if (type == 'create' || type == 'edit') { var…

in Struggling with what seems like a simple UE script... Comment by khultquist Jul 26, 2016 5:14PM

One workaround idea: if you can wait up to 15 minutes, you can run a scheduled script and get the trigger to fire. You might also be able to deploy/schedule a scheduled script from your user event.

in Triggering an event on nlapiTransformRecord Comment by khultquist Jul 25, 2016 1:53PM

I'm running Chrome 51.0.2704.103 on Windows 7, I've never seen that issue. I have seen functions not work in View mode, but they always work in edit mode. As a side note, someone in the UG posted this: create a bookmark, edit it: [INDENT]Name: get field value (prompt) URL:…

in Google Chrome and Console functionality Comment by khultquist Jul 20, 2016 5:02PM

al3xicon is right, since you are summarizing/grouping, you have to use a different technique. Try something like this searchresults[i].getValue('internalid', null, 'group');

in Loading Saved Search Comment by khultquist Jul 19, 2016 10:36AM

can you copy/paste the results of your nlapiLogExecution

in Loading Saved Search Comment by khultquist Jul 19, 2016 9:35AM

Try using nlapiGetOldRecord() which will return the entire object, and then compare to the submitted record using getAllFields()

in User Event - Detecting fields that were modified Comment by khultquist Jul 18, 2016 1:12PM

Yes it is, see this thread https://usergroup.netsuite.com/users/forum/platform-areas/customization/suitescript-custom-code/8637-search-for-file-in-file-cabinet

in Searching File Cabinet Comment by khultquist Jun 15, 2016 6:34PM

My guess is that the address has tax implications, which means NS wants to recalculate each line item.

in Recalc Function in SuiteScript Comment by khultquist Apr 20, 2016 4:46PM

Can you post the whole loop that contains receipt.setCurrentLineItemValue('item', 'itemreceive', 'F'); I have a very similar script that works, but I use setLineItemValue instead ... var noOfItemCount = receipt.getLineItemCount('item'); for (var x = 1; noOfItemCount !== null && x <= noOfItemCount; x++) {…

in Item Receipt uncheck "Receive?" Checkbox Comment by khultquist Feb 26, 2016 9:54AM

Searching this forum is very confounding... You can search for "netsuite" and get 200 results You can search for "script" and get 200 results You can search for "test" and get 200 results You cannot search for "setCurrentLineItemMatrixValue"????

in setCurrentLineItemMatrixValue Comment by khultquist Apr 13, 2016 11:32AM

Hi Mark - take a look at nlapiGetOldRecord(). That should give you what you need.

in Userevent script: comparing original values in a field in the afterSubmit trigger Comment by khultquist Mar 9, 2016 1:23PM

I would mark the Custom Record with a checkbox, during the User Event script. Then call the Scheduled Script, which runs a search for any Custom Record with the checkbox.

in Passing a value from aUser Event script to nlapiScheduleScript Comment by khultquist Feb 18, 2016 10:29AM

Try nlapiSetFieldValue('location' , nlapiLookupField('customer', nlapiGetFieldValue('entity'), 'location'));

in Auto populate field SuiteScript Comment by khultquist Feb 5, 2016 5:04PM

You won't lose a connection, as it runs on NetSuite's servers. What you will run up against is an execution limit -- scheduled scripts have a limit of 10,000 units. Loading a record costs 10, and submitting it costs 20, so a rough estimate is that you can process up to 333 records before you reach the limit. Your searches…

in Scheduled script execution time limitation Comment by khultquist Jan 6, 2016 9:42AM

I believe something like this will work var d = new Date(); var delay = 1000; // milliseconds while (Math.abs(new Date() - d < delay) {};

in How to add a delay / sleep in a scheduled script Comment by khultquist Dec 21, 2015 4:05PM

Did you put the nlapiLogExecution line inside the loop? If so, and if nlapiGetLineItemCount('salesteam') is null or 0, it won't run. Make sure it's outside. function cs_EmailEngineer(){ console.log("Request SOW Button Pressed"); nlapiLogExecution('debug', 'email sent', 'Email was sent'); console.log("It got passed the…

in For Loop not iterating through sales team sublist Comment by khultquist Aug 12, 2015 2:21PM

Check out the function nlapiYieldScript() https://system.netsuite.com/help/helpcenter/en_US/Output/Help/section_N3053136.html#bridgehead_N3053967 Or add a custom field to your record (timestamp) that will assist in processing the correct records.

in Scheduled script woes Comment by khultquist Jun 16, 2015 1:43PM

I think the problem here is that if your class field is null, converting that to a string makes the string "null", which has a length of 4. Try this instead: function saveRecord() { // Check to see that Class is populated. If not, block the save and warn with a popup. for (var i = 1; i <=…

in Adding a script to validate if a line item has a value Comment by khultquist May 20, 2015 4:16PM

Well you could probably still do this as a scheduled script, it will lag behind real-time but maybe that's not critical for you.

in Journal Entry User Events Supported? Comment by khultquist May 22, 2015 2:43PM

MFA for Oracle Community

khultquist Red Ribbon

Comments