Home » Categories » Multiple Categories

Fix Inaccurate Avg Part Cost

You need to take the item down to ZERO QOH so that it is forced to start calulating Avg Cost all over again.
 
1. Go to Inventory List screen, enter the part number and click Search.
2. With the selected part highlighted, click on Edit to open the inventory item. Make note of the current QOH (Quantity On Hand).
3. Change the On Hand quantity down to 0 [zero] and then click OK to save this change. (you can skip through the manual change warning)
4. Click on Edit to open the same part item again; change the On Hand back to the previous figure and click OK. (skip the manual change warning again)

As long as the QOH remains above zero, the average cost will continue to calculate.
0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Comments Comments
Related Articles RSS Feed
Posted Order Report Totals Higher Than Totals On Cash Receipts Report
Viewed 10352 times since Wed, Jun 11, 2008
Export 5.9 data to Excel 2002/2007
Viewed 7999 times since Thu, May 31, 2012
Merge Inventory Master Record
Viewed 1700 times since Thu, Jul 26, 2012
No ODBC Data Source / 3031 Error
Viewed 3767 times since Tue, Oct 29, 2013
Late Fee Calculation - Annual Percentage Rate (APR)
Viewed 2230 times since Fri, Sep 2, 2016
Install Revisions Report
Viewed 3012 times since Fri, Aug 13, 2010
Experts’ Schedule Advice
Viewed 3132 times since Sat, Mar 14, 2009
Recommendations Unable to Be Saved
Viewed 1217 times since Thu, Jul 26, 2012
SE Recommended Local Backup Instructions
Viewed 5634 times since Wed, Jan 14, 2015