netsuite | Ursus Code

Snippet to create a delay in a server side script

May 15, 2017 Adolfo Garza Comments 868 comments

The motivation behind the creation of this function stems from the absence of a built-in setTimeout functionality in the server-side environment of Netsuite. Although I personally had not encountered the necessity for such a function, I recognized the potential value it could hold for others facing similar circumstances.

It is essential to note that the provided code relies on a busy-wait mechanism, which is widely acknowledged as an antipattern and discouraged for use. This approach involves a loop that continuously checks the system clock until the specified duration elapses. While it serves as a makeshift alternative, it is important to exercise caution and consider alternative solutions whenever possible.

For your convenience, the function is provided below:

function setTimeout(aFunction, milliseconds){

var date = new Date();

date.setMilliseconds(date.getMilliseconds() + milliseconds);

while(new Date() < date){

}

return aFunction();

}

And then call it like this:

1	setTimeout(function(){ log.debug('Ran after 1 second'); }, 1000);

Beware of execution time limits when running this code. Always test first.

By incorporating this function into your code, you can simulate a delayed execution of a specified function after a given time period. However, it is advisable to explore more efficient and reliable alternatives for handling time-based operations in Netsuite’s server-side environment.

SuiteScript 2.0 Dialog Prompt + On SaveRecord

December 29, 2016 Adolfo Garza Comments 4,931 comments

One of the new modules in Suitescript 2.0 is the “N/ui/dialog” module but unfortunately it doesn’t include a prompt method. I did some digging and found that the dialog module uses Sencha Ext JS. Since Ext JS doesn’t require the dialog module it can run on both SS 1.0 and 2.0!

Here’s how they look like side by side:

Native JS

jsprompt

Ext JS

extjsprompt

Note: This is a hack.

Here’s the code sample on how to achieve this (Works on both SS 1.0 and SS 2.0):

function showPrompt(){

Ext.Msg.prompt("My Prompt Title", "Please enter your text:", handlePromptResult, this);

function handlePromptResult(buttonClicked, text) {

if (buttonClicked !== 'ok') { return; }

console.log("You entered: " + text);

}

Additionally, thanks to this post from Abaci I was able to run this code right before the record is saved, which can be very useful to set the value of a field right before saving.

Here’s the code sample running on SaveRecord in SS 2.0:

/**

* @NApiVersion 2.0

* @NScriptType ClientScript

* @NModuleScope Public

define(['N/ui/dialog'],runClientScript);

function runClientScript(dialog){

var DIALOGMODULE = dialog;

var IS_CONFIRMED; //This global is used to detect if user has pressed "OK" in the prompt box

var returnObj = {};

returnObj.saveRecord = saveRecord;

return returnObj;

//*********** HELPER FUNCTIONS ***********

function saveRecord(context) { //If user clicked "OK" in prompt box then save, else show the confirmation box if record passes validation

if(IS_CONFIRMED){

return true;

} else {

if(!validateSaveRecord()){ //Here you do your own saveRecord validation/automation.

return false;

}

Ext.Msg.prompt("My Prompt Title", "Please enter your text:", handlePromptResult, this);

}

//*********** HELPER FUNCTIONS ***********

function handlePromptResult(buttonClicked, text) {

if (buttonClicked !== 'ok') { return; }

console.log("You entered: " + text);

IS_CONFIRMED = true;

getNLMultiButtonByName('multibutton_submitter').onMainButtonClick(this); //NS Hack to call simulate user clicking Save Button

}

function validateSaveRecord(){//Here you do your own saveRecord validation/automation.

return true; //Return true if you want to proceed with the save.

}

I hope that was useful for you. Don’t forget to leave a comment if you have any questions!

Getting Item Earliest Available Date Programatically

December 2, 2016 Adolfo Garza Comments 39 comments

I was browsing through the Netsuite user group and I stumbled upon this interesting question:

I have a client that wants to automate the process of checking/calculating the ‘Earliest Available Date’ from the ‘Check Item Availability’ feature on the item level of a sales order. I know that this calculation is done using the ATP lead time, but I am not sure how to initiate this calculation via SuiteScript or Saved Search. I have shown this issue to NetSuite support and they told me that it is not currently possible to access the “Earliest Available Date” by either Saved Search or API. It literally requires someone to click the “Check Item Availability” which loads the popup dialog and shows the date. My client would obviously like to avoid having to drill into every sales order and check this date.

Does anyone know of a way to display the ‘Earliest available date’ via Saved Search or API? Or many another way to calculate it via some other ATP lead time calculation.

I was able to reverse engineer the process that Netsuite uses to calculate the “Earliest Available date” and I came up with a solution that works within the browser console. The solution loads the popup in the back, parses the HTML and gets the data. This may help you get started on designing a more robust solution.

Here’s a sample output:

{

"transactionnumber" : "SLS00000684",

"location" : "1",

"subsidiary" : "1",

"quantity" : "20",

"item" : "553",

"type" : "InvtPart",

"availableDate" : "12/1/2016"

}

Here’s the code ready to run in the browser console:

Note: Since this is running in the browser you might need to play around with the script to get over 100 items at a time as the governance would run out. Alternatively you could use an Ajax call instead of nlapiRequestURL.

function getItemsToProcess() {

var results = [];

var filters = [];

var columns = [];

filters.push(new nlobjSearchFilter('type', null, 'anyof', ['SalesOrd']));

filters.push(new nlobjSearchFilter('trandate', null, 'within', ['12/1/2016', '12/1/2016'])); //Change this as needed

filters.push(new nlobjSearchFilter('type', 'item', 'anyof', ['Assembly', 'InvtPart']));

columns.push(new nlobjSearchColumn('transactionnumber', null, null));

columns.push(new nlobjSearchColumn('location', null, null));

columns.push(new nlobjSearchColumn('subsidiary', null, null));

columns.push(new nlobjSearchColumn('quantity', null, null));

columns.push(new nlobjSearchColumn('item', null, null));

columns.push(new nlobjSearchColumn('type', 'item', null));

results = nlapiSearchRecord('salesorder', null, filters, columns);

var itemsToProcess = [];

for (var i in results) {

var result = results[i];

var row = {};

row.transactionnumber = result.getValue(columns[0]);

row.location = result.getValue(columns[1]);

row.subsidiary = result.getValue(columns[2]);

row.quantity = result.getValue(columns[3]);

row.item = result.getValue(columns[4]);

row.type = result.getValue(columns[5]);

itemsToProcess.push(row);

}

return itemsToProcess;

}

function getItemAvailability(itemId, itemType, itemLocation, itemQty, subsidiary){

if (itemType != 'InvtPart' && itemType != 'Assembly'){

return "UNSUPPORTED";

}

var myURL = '/app/accounting/inventory/atp/checkitemavailability.nl?item=' + itemId + '&location=' + itemLocation + '&quantity=' + itemQty + '&subsidiary=' + subsidiary;

//myURL+= '&unit=' + unitOfMeasure; //Needs more work to pass this

var myResponse = nlapiRequestURL(myURL);

var myHTML = myResponse.getBody();

var parser = new DOMParser();

var doc = parser.parseFromString(myHTML, "text/html");

var availableDate = getEarliestAvailableDate(doc, itemId, itemQty, itemLocation);

return availableDate;

//**** HELPER FUNCTIONS ****//

function getEarliestAvailableDate(myDoc, itemId, itemQuantity, itemLocation) {

var quantity = parseFloat(itemQuantity) || 0;

var earliestavailabledate = '';

if (quantity && itemId && itemLocation) {

var numberOfLines = getOrderMachineSize(myDoc);

for (var i = 1; i <= numberOfLines; i++) {

if (quantity <= parseFloat(getOrderMachineValue(myDoc, 'hiddenavailability', i))) {

earliestavailabledate = getOrderMachineValue(myDoc, 'hiddendorderdate', i);

return earliestavailabledate;

}

var atpleadtime = myDoc.forms['main_form'].elements['atpleadtime'].value;

if (!atpleadtime || !earliestavailabledate) {

earliestavailabledate = nlapiDateToString(nlapiAddDays(new Date(), atpleadtime));

return earliestavailabledate;

}

return earliestavailabledate;

//******* HELPER FUNCTIONS ******//

function getOrderMachineValue(myDoc, fieldName, line) {

return myDoc.forms['order_form'].elements[fieldName + line].value;

}

function getOrderMachineSize(myDoc) {

var numberOfLines = 0;

while (myDoc.forms['order_form'].elements['hiddenavailability' + ++numberOfLines] != null);

return numberOfLines - 1;

}

function run(){

var itemsToProcess = getItemsToProcess();

var itemsProcessed = [];

for(var i in itemsToProcess){

var itemToProcess = itemsToProcess[i];

itemToProcess.availableDate = getItemAvailability(itemToProcess.item, itemToProcess.type, itemToProcess.location, itemToProcess.quantity, itemToProcess.subsidiary);

itemsProcessed.push(itemToProcess);

}

return itemsProcessed;

}