how to get average cost on location line on new item without receving it?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the location average cost is not directly accessible via SuiteScript. However, you can use the

getCurrentSublistValue

function to get the value of the location average cost for a specific line item. Here's a general idea of how you can do it: 1. Use the

getCurrentSublistValue

function to get the value of the location average cost for a specific line item. This function requires the sublist ID and the field ID as parameters. For example, if the sublist ID is 'locations' and the field ID is 'locationaveragecost', you can use the function like this:

javascript
var locationAverageCost = record.getCurrentSublistValue({
    sublistId: 'locations',
    fieldId: 'locationaveragecost'
});

2. If you need to get the location average cost for a specific location, you can use the

findSublistLineWithValue

or

getSublistValue

function to find the line number of the location. Once you have the line number, you can use the

getCurrentSublistValue

function to get the location average cost.

javascript
var lineNumber = record.findSublistLineWithValue({
    sublistId: 'locations',
    fieldId: 'location',
    value: 'your_location'
});

var locationAverageCost = record.getCurrentSublistValue({
    sublistId: 'locations',
    fieldId: 'locationaveragecost',
    line: lineNumber
});

Please note that this is a general idea and you might need to adjust the code according to your specific needs. Also, keep in mind that using a saved search to get a field on your line item might not be the best solution due to the governance allocated for search and how much it took on your process. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******