Arthur Bagumyan
05/15/2026, 5:48 PMCeligo AI
05/15/2026, 5:48 PMAI generated answer (using internal Slack threads):Based on the conversations, updating the unit cost on existing inventory adjustments in NetSuite can be done as follows: 1. For positive adjustments, you can directly edit the 'Est. Unit Cost' field when making the inventory adjustment. This field allows you to enter the cost of each item being added to the quantity on hand. 2. For negative adjustments, you cannot directly edit the 'Est. Unit Cost' field. The cost of the items being removed from the quantity on hand is calculated based on the item's Average Cost. 3. If you are moving inventory from one lot to another and facing issues with the Estimated Total Value due to rounding off of the unit cost, you can get the correct cost from a search/SQL query based on the location inventory value and on-hand quantity. This will give you the accurate, 8-decimal value. 4. Be aware of the cost calculation order when transactions are entered on the same day. For example, if an adjustment has both in and out lines for the same item, the order of the transactions can affect the cost calculation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
05/15/2026, 5:49 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.852661192
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848510742
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.84387207
Celigo AI
05/15/2026, 5:49 PM