Recalculate the Average Cost for a product

When a product is received without a cost or at the incorrect cost, its Average Cost must be manually recalculated in order to adjust its margin when sold.

Before you begin:
  • Make sure your system is properly setup for Inventory Adjustments.
  • Know that margin will not be updated on past sale transactions and sales reports. Past sale transactions were marked as completed in the system and can not be updated.

From within the product editor


1. Select the Adjustment icon next to the quantity field in the product record.



This opens the Inventory Adjustment window.  

 

2. Select Other from the Type dropdown.
3. Select Decrease in the Action dropdown.
4. In the Unit cost field, accept the default value.
5. In the Quantity field, enter the amount you need to fix (so if I incorrectly received 3, I'd enter 3). 
6. In the Comments field, explain the reason for the adjustment (such as Case Qty incorrectly set at receiving). 
7. Click Save.

You have successfully removed the incorrectly received products. Now you need to re-add them at the correct cost.

8.Select the Adjustment icon next to the quantity field in the product record again.
9. Now, select Other from the Type dropdown.
10. Then select Increase from the Action dropdown.
11. In the Unit cost field, enter the correct cost for an individual product.
12. In the Quantity field, re-enter the item that was received (so in my situation, I'd enter 3 again). 
13. Select Save.

From outside the product editor


1. From the Ascend desktop, select Create > Inventory Adjustment.
2. Enter the product UPC, part number, description, etc. in the Search field to find the product.
3. Select the Search icon.
4. Double-click the correct product in the results, if needed.



5. Select Other from the Type dropdown.
6. Select Decrease in the Action dropdown.
7. In the Unit cost field, accept the default value.
8. In the Quantity field, enter the amount you need to fix (so if I incorrectly received 3, I'd enter 3).
9. In the Comments field, explain the reason for the adjustment (such as Case Qty incorrect set at receiving).
10. Click Save.

You have successfully removed the incorrectly received products. Now you need to re-add them at the correct cost.  
Repeat steps 1 through 4.

11. Now, select Other from the Type dropdown.
12. Then select Increase from the Action dropdown.
13. In the Unit cost field, enter the correct cost for an individual product.
14. In the Quantity field, re-enter the item that was received (so in my situation, I'd enter 3 again).
15. Select Save.

Feedback and Knowledge Base