Scenario
When performing a negative inventory adjustment in NetSuite, the Estimated Unit Cost (Est. Unit Cost) field may default to the Location Average Cost instead of the Standard Cost, even when the item uses the Standard costing method.
- Item: Item A
- Costing Method: Standard
- Location: Test Location
- Standard Cost: 25.00
- Location Average Cost: 20.00
- Navigate to Transactions > Inventory > Adjust Inventory.
- Set the necessary fields and click Adjustment.
- For Item A, select Location as Test Location and adjust the quantity by -1.
Actual Result: The Est. Unit Cost auto-populates to 20.00 (Location Average Cost) and is grayed out, preventing changes.
Expected Result: The Est. Unit Cost should be 25.00, based on the Standard Cost.
Solution
For negative adjustments, the Est. Unit Cost is automatically set to the Location Average Cost and cannot be changed. After saving the adjustment, the system updates the cost to match the Standard Cost. For positive adjustments, the Est. Unit Cost defaults to the Location Average Cost, but users can edit it.
Key Points
- Negative Adjustments: Est. Unit Cost defaults to Location Average Cost and updates after saving based on Standard Cost.
- Positive Adjustments: Est. Unit Cost defaults to Location Average Cost but can be modified.
-----
If you find this information useful, let us know by reacting or commenting on this post!
