Hey Gurus - hoping someone can give some direction here; so the client went live with items with no values, they have been doing inventory adjustments for 2 months without any actual item values, hence they have been down dollars wise. The items had no base/sale price hence nothing made its way to the IA's. What I found was that Item values on existing IA's cannot be modified, it’s a system limitation so trying to see if inventory worksheet would help in any way however I doubt it will but I could be wrong. The other approach in mind is to work through JE's to balance GL for those 2 months, or the 3rd option I am thinking is to delete those IA, and reimport them in once after all items have had values entered on them. Any pointers would be helpful, thanks!

@Adnan Azam it's ugly, but i went through something similar once. You can delete and replace those inventory adjustments and back date them. Netsuite will fix total COGS for the company, but individual transactions will still look like 100% profit

Thanks @AK47. I was thinking the same thing, trying to make sure have exhausted all other options.