How do you correct the average cost on an inventory item? For an example, our copper pipe usually cost anywhere from $3-$4 per foot. The average is roughly $3.50 per foot. Somehow our inventory item in QuickBooks got the average cost at -$819.00. Does anyone know how I can correct this?