How can I modify Transfer order item line field called 'Average Cost', i want to manually put amount from scrip!

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To modify the 'Average Cost' field on a Transfer Order item line, you would need to use SuiteScript. However, it's important to note that the 'Average Cost' field is a system-calculated field based on the inventory transactions and it's not directly editable. If you want to manipulate the average cost, you can do so indirectly by adjusting the cost of the item through an Inventory Adjustment. You can use the 'Adjust Inventory Worksheet' for this purpose. Here's how you can do it: 1. Navigate to Transactions > Inventory > Adjust Inventory Worksheet. 2. Select your date at the top, then select your item from the list. 3. Set the quantity to the same as the on-hand quantity (so you don't adjust the quantity) but then set the value to the new value you want and it will set the average cost for that item to that amount on the day you have selected at the top. Remember, this will affect the average cost across all transactions for that item, not just for a specific Transfer Order. If you want to capture the average cost at a specific point in time, you might consider creating a custom field and using a User Event script to populate that field with the average cost at the time of creation of the item receipt. Please note that manipulating the average cost can have significant impacts on your accounting and inventory valuation, so proceed with caution and consider consulting with your accounting team before making these changes.