This is not a recommended operation for regulated industries. In regulated industries, like cannabis, the best way to correct cost average is to reverse the entire incorrect supplier invoice and re-enter with the correct cost, or reverse the relevant line from the supplier invoice and re-enter it with the correct cost. See the linked articles at the bottom of this page.
How do I update the cost average of a product?
Follow these steps
Cost average errors often stem from posting supplier invoices with minor errors, like an incorrect value in units per case or unit cost. These tiny data entry errors impact your ability to use automated features like retail pricing rules and price books, and impact the accuracy of reporting.
To adjust the cost average, follow these steps.
- Locate the product and open it.
- Select the Inventory tab.
- Select the Cost Avg Adjustment button.
- Enter the correct unit cost average. Check Cost Includes Tax and Deposit if you use the all in cost average. Select Submit.
For more information about reversing supplier invoices, see the articles: