Ursus Code – Page 5

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…

Convert Salesforce Ids from 15 to 18 characters using Javascript

December 1, 2016 Adolfo Garza Comments 798 comments

I figured this will be useful for anybody working with Salesforce. I used this within Netsuite and worked beautifully. Here’s the code:

function convertSFDC15To18(sfdcID15){

if (sfdcID15.length == 15) {

var s = "";

for (var i = 0; i < 3; i++) {

var f = 0;

for (var j = 0; j < 5; j++) {

var c = sfdcID15.charAt(i * 5 + j);

if (c >= "A" && c <= "Z")

f += 1 << j;

}

s += "ABCDEFGHIJKLMNOPQRSTUVWXYZ012345".charAt(f);

}

return sfdcID15 + s;

} else {

throw "Error : " + sfdcID15 + " has not a length of 15 characters. Current length detected: " + sfdcID15.length + " characters.";

}

//Example:

var sfdc18 = convertSFDC15To18('5003000000D8cuI'); // Returns 5003000000D8cuIAAR

Free Automatic Translation Within Netsuite using Yandex Translate API

December 1, 2016 Adolfo Garza Comments 701 comments

In this challenge I decided to integrate Netsuite with Yandex Translate REST API for the following reasons: Free version includes: Up to 10 million characters a month (or 322,580 characters per day spread evenly in 31 days) Up to 1 million characters in 24 hours (would last 10 days only as max is 10 million per month) Translation quality is decent. Great for small translation projects. Let’s say we want to translate a FreeText field, that has a max of…