Change Cost of Lot for Lot Numbered Item
I need to change the cost of specific lots of a given item in inventory that is configured with Lot Numbered costing method. The Inventory Adjustment page won’t allow me to do this, so I am wondering if there is either another screen somewhere in the system or a way to accomplish this using SuiteScript.
Example: I have part number ABC123 and there are three lots in inventory: lot ABC123-1, lot ABC123-2, and lot ABC123-3. Each lot has a different cost. I need to change the cost of lot ABC123-2 from whatever it is to $0.
NetSuite support is “investigating the issue” but I think someone should have surely had to do this already. Any ideas? Thanks!
If the inventory for lot ABC-123-2 is still on hand and available, you need to adjust this out (at value, which NS will do for you) and then back in at your desired value.
The adjustment IN needs to occur either on the next calendar date from the adjustment out, if done in the same location, or in a separate location.