how to get inventory location average cost of an item in results tab in an inventory balance saved search

AI generated answer (using internal Slack threads):

To get the inventory location average cost of an item in the results tab in an inventory balance saved search, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Inventory Balance from the list. 3. In the Criteria tab, add the filters you need. For example, you can add 'Item' and 'Location' as filters and set them to the specific item and location you want to get the average cost for. 4. In the Results tab, add the fields you want to display in the search results. To get the average cost, you can add the 'Average Cost' field. 5. Save and run the search. Please note that the 'Average Cost' field in the inventory balance saved search shows the average cost of the item at each location. The average cost is calculated based on the total cost of the item at the location divided by the total quantity of the item at the location. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******