User creates a negative Inventory Adjustment by following these steps:
- Navigate to Transactions > Inventory > Adjust Inventory
- Set the mandatory fields.
- Click Adjustment
- Set these fields:
- Item: Item A
- Location: Test Location
- Adj Qty By: -1
Actual Result: Est. Unit Cost is auto-populated with 15.00 which is the item’s location average cost. The field is also grayed out.
Expected Result: Est. Unit Cost should be equal to 20.00 because the item uses standard costing method.
Regardless of the Costing Method of the item, the value in the Est. Unit Cost field is derived from the Location Average Cost of the item. When reducing the quantity of the item or creating negative Inventory Adjustments, the latter field is grayed out and cannot be changed. As soon as an Inventory Adjustment is saved, the system calculates the correct cost based from theCosting Methodof the item and replaces the defaulted Location Average Cost.
If users are adding quantities or creating a positiveInventory Adjustment, this field will still default to the Location Average Cost but users have the option to accept/retain or change the value on the Est. Unit Cost field. If a user chooses to retain the value, it will be treated as if the user entered it manually. Users may be able to edit it any time after saving as long as the Posting Period is open.