I am creating inventory adjustments and moving the inventory from one lot to another.For the original inventory, NetSuite is showing est. unit cost for up to 8 decimal places (for example 6.49964286). While I am getting the unit cost from the original line and setting it on my adjusted line, it is rounded up (for example 6.50). This is creating the problem with Estimated Total Value not getting 0. I have tried loading and updating the lines again but no results. How can I fix this?

the unit cost on the adjustment line is rounded until the cost account status resolves, then it will be the accurate, 8-decimal value. I would suggest getting the correct cost from a search/SQL query and using that for your inventory adjust in

Thanks @David B. I will try that. But the search will not return the correct 8-decimal value until the cost account status resolves, right? So, how do I "wait" during this period? Please don't suggest scheduled script 😞

search for the costing based on the location inventory value and on-hand qty (presuming you're using locations)

Okay, I will try this and update you here.

I know you're doing zero-balance adjustments, but just wanting to make sure you're aware of the cost calculation order when transactions are entered on the same day (i.e. an adjustment that has both in and out lines for the same item) _*edit, forgot the SA link_