how to get average cost per location of an item in netsuite using suitescript

AI generated answer (using internal Slack threads):

To get the average cost per location of an item in NetSuite using SuiteScript, you would need to perform a search on the item record. The 'locationaveragecost' field is not directly accessible through SuiteScript, but it can be obtained through a search operation. Here is a general idea of how you can do this: 1. Use the

search.create

method to create a search on the item record. 2. Add filters to the search to specify the item and location you are interested in. 3. Add a column to the search to return the 'locationaveragecost' field. 4. Run the search and process the results to get the average cost for the specified location. Here is a sample code snippet:

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

var itemSearch = search.create({
   type: search.Type.ITEM,
   filters: [
      ['internalid', 'anyof', itemId],
      'AND',
      ['inventorylocation', 'anyof', locationId]
   ],
   columns: ['locationaveragecost']
});

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

if (result.length > 0) {
   var locationAverageCost = result[0].getValue({name: 'locationaveragecost'});
   log.debug('Location Average Cost', locationAverageCost);
}

In this code,

itemId

and

locationId

are the internal IDs of the item and location you are interested in. The 'locationaveragecost' field is retrieved from the search result. Please note that this is a simplified example and you may need to adjust it according to your specific requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******