Why is the Last Unit Cost zero for some inventory items

• Inventory Adjustment increased Quantity on-hand but Unit Cost field was left at $0.00
• Data corruption in inventory records

Section I: Inventory Adjustment

• There are two ways the program updates the Last Unit Cost for an inventory item:
  • Purchase of the item (purchase invoices)
  • Inventory Adjustments
• If an inventory adjustment is dated after the latest purchase invoice for the item, the Last Unit Cost will be the Unit Cost on the adjustment. If this is $0, so will be the Last Unit Cost.
• To find the last transaction that increased quantity on-hand or adjusted cost:
  1. Click Reports & Forms, Inventory
  2. Open the Item Costing Report
  3. Click Options
  4. Set Date to All
  5. Select the Item ID filter, and check the item in question
  6. Click OK

Section II: Inventory Data Corruption

Note: These steps require single-user access to the company

1. Click File, Backup and save a backup of your company
2. Open Integrity Check:
   • In Release 2013 and newer, click Help, Customer Support & Service, Integrity Check
   • In Release 2012 and older, click File, Integrity Check; if Integrity Check is not listed, see Article 10292: DocLink: Integrity Check Guide for instructions to enable it
3. Click Continue
4. Check Reindex Files; on the Reindex Files List, click Inv Cost, then click OK
5. When the test completes, reopen Integrity Check and click Continue
6. Check Inventory/Journal, then click OK; click OK on any error corrected messages that appear
   
   Note: This test can take a quite a while to run; do not interrupt the process. If leaving it to run unattended, uncheck the option Pause when error detected before clicking OK
7. Verify that the item now shows the correct Last Unit Cost

Section III: Adjust Cost Manually

• If the steps in Section I and II do not correct the cost, manually adjust the item cost to correct it
• See Article 11963: DocLink: How to adjust the last unit cost of an inventory item for instructions