How to change the average cost of an item

Home » Categories » NCR Counterpoint » Inventory

How to change the average cost of an item

Cause:

The average cost field cannot be manually edited, even when the quantity on hand field is zero.

The average cost field can only be changed through posted transactions.

Solution:

  • Enter an inventory adjustment to bring the quantity on hand to zero and post the adjustment.
  • Then, enter a new adjustment to bring the item to the proper quantity at the proper cost.

Average Cost for the location will show for the cost entered when the last adjustment was made.

The Last Cost field must be manually updated. An adjustment will not update this field.

 

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to locate ’committed inventory’ for an item
Viewed 3016 times since Wed, Jul 29, 2015
’Use BOGO/Twofer pricing’ checkbox is greyed out when setting up a price rule
Viewed 1752 times since Mon, Jul 28, 2014
Changing the COS% in the inventory record does not update the item record’s COS%.
Viewed 1583 times since Wed, May 4, 2016
Error: Item cannot be deleted due to the following errors
Viewed 4229 times since Wed, Jun 18, 2014
How to set up a BOGO Price Rule using Mix-and-Match codes (Example)
Viewed 1999 times since Thu, Jul 5, 2018