how to create a saved search in suitescript 2.0 that given the itemid it returns the lot with the closest expiration date

AI generated answer (using internal Slack threads):

To create a saved search in SuiteScript 2.0 that given the itemid it returns the lot with the closest expiration date, you would need to use the

N/search

module. Here is a general example of how you can create a saved search in SuiteScript 2.0:

javascript
var search = require('N/search');

var itemSearch = search.create({
   type: search.Type.LOT_NUMBERED_INVENTORY_ITEM,
   filters: [
      ['itemid', 'is', itemId]
   ],
   columns: [
      'inventorynumber',
      'expirationdate'
   ]
});

var resultSet = itemSearch.run();
var results = resultSet.getRange({start: 0, end: 100});

In this example,

itemId

is the ID of the item you are searching for. The search is set to return the lot number (

inventorynumber

) and the expiration date (

expirationdate

) of the lot. Please note that this search will return all lots for the given item. To find the lot with the closest expiration date, you would need to sort the results by the

expirationdate

column and take the first result. Also, please note that the

N/search

module is part of SuiteScript 2.0, so you need to make sure your script is running in a SuiteScript 2.0 environment. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******