Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
Adjust Wrong lot in Bin using inventory Adjustment
We need to correct quantities that were stored in Bin under the wrong lot and move them to the correct lot. Following the NetSuite Community reference “NSC | Adjust Wrong Lot Number In A Bin — NetSuite Community”, we created both positive and negative lines within the same Inventory Adjustment. However, the est. unit cost on the negative line is recalculated by the system, causing a significant variance in COGS and the Inventory Adjustment account on the Income Statement. For the positive line, we used the system-populated unit cost.
Our goal is to fix the lot assignment without impacting COGS or any other financial accounts. Essentially, the net financial impact of the Inventory Adjustment should be zero when using same positive and negative quantities. How can we achieve this?