How do I show the Location Average Cost for the Inventory Profitability report?

AI generated answer (using internal Slack threads):

To show the Location Average Cost for the Inventory Profitability report, you can follow these steps: 1. Navigate to Reports > Inventory > Inventory Valuation. This report provides point-in-time reporting on cost data, including the average cost. 2. If you want to capture the location-specific average cost in a custom field based on the location selected in the item receipt, you can use a User Event (UE) script. The field on the item record is called 'location average cost'. This field changes as inventory moves or landed cost gets added. 3. If you can't find the 'location average cost' in the SuiteScript browser, it might be because it's only available for searches. 4. If you're dealing with transfer orders and want to calculate the location average cost, make sure you have ticked the 'Use Item Cost as Transfer Cost' on the Transfer Order (TO). The schedule for calculating the location average cost is defined in Set Up > Accounting > Inventory Costing Preferences. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******