Hi BNS , go to the Inventory, Item List, edit the item and see what values are displayed for Qty and on hand value. If they are different, try using those values for the adjustment.
Thanks for your response Mike. Unfortunately it didn't help as it showed zero items on hand with zero value so nothing to adjust. Reports are all still showing 2 items on hand with a value though. Any ideas how to do it when the Item list says no items on hand?
The item information screen is probably correct. The reports that may agree are the item register detail and the inventory value reconciliation report.
Yes but unfortunately it is showing on my Balance Sheet as a separate line item which is why I need to clear it up. Makes me think maybe the item list isn't correct at all.
Hi BNS, the inventory value reconciliation report shows each asset account separately. For that account, does it show a stock total of nil and a GL amount, therefore the same amount as out of balance? If so, just write off the GL value to cost of sales.
