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?