Getting Item Earliest Available Date Programatically

Getting Item Earliest Available Date Programatically

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:

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.

 

  • Shoaib Mehmood

    Found very helpful, thanks for sharing