how to make transfer order with specific average cost in netsuite i want to change the average cost , for the example the average cost 100 i want to make the transfer with average cost 80

AI generated answer (using internal Slack threads):

In NetSuite, the average cost of an item is calculated automatically based on the transactions related to that item. It's not possible to directly change the average cost of an item during a transfer order. The average cost is updated based on the costing cycle that you have set in your costing preferences (Setup > Accounting > Costing Preferences). However, you can indirectly influence the average cost by adjusting the cost of the item before creating the transfer order. You can use the Adjust Inventory Worksheet to update the cost of an item. Here are the steps: 1. Go 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. This will set the average cost for that item to that amount on the day you have selected at the top. After this, you can create your transfer order and the average cost should reflect the changes you made. Remember, this method should be used with caution as it can affect your accounting records. Always consult with your accounting team before making such changes. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******