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!

Rookie Asked on December 10, 2021 in Accounting.
Add Comment
2 Answer(s)

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.

Beginner Answered on January 26, 2022.
Add Comment

If it’s not on hand/available then you need to consider either adjusting inventory per above prior to the date which inventory was decremented, or using Journals to correct inventory valuation balance

Beginner Answered on January 26, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor