Hagar Ahmed
09/22/2024, 1:47 PMCeligo AI
09/22/2024, 1:48 PMAI generated answer (using internal Slack threads):Based on the conversations, it appears that the Est. Unit Cost field can be used when adjusting inventory in NetSuite, but there are some conditions to consider: 1. When increasing the stock level via an Inventory Adjustment, you can enter the cost of each item being added to the quantity on hand in the Est. Unit Cost field. This will increase the total stock value. 2. If you are reducing the stock level, you cannot enter anything in the Est. Unit Cost field. The cost of the items being removed from the quantity on hand is calculated by NetSuite. 3. When importing an Inventory Adjustment, the Est. Unit Cost from the CSV file may not be taken into account. It seems that when doing an adjustment manually, you can't enter anything into the Est. Unit Cost field when reducing inventory. 4. The unit cost on the adjustment line is rounded until the cost account status resolves, then it will be the accurate, 8-decimal value. You can get the correct cost from a search/SQL query and use that for your inventory adjustment. 5. If you are doing zero-balance adjustments, be aware of the cost calculation order when transactions are entered on the same day. An adjustment that has both in and out lines for the same item may affect the cost calculation. Remember, these are based on the conversations and may not apply to all scenarios. Always test and verify in your own NetSuite environment. ****** 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
09/22/2024, 1:48 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.856895387
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837202489
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836209714
Celigo AI
09/22/2024, 1:48 PM