Negative average cost

You can see Sales Orders for non-inventory parts, I have all of my manufactured parts set up that way.

That's interesting,. because we can't. You do a "Quick Report" on a non-inventory part and Sales Orders are not shown. Even when it is invoiced, only the invoice shows, not the sales order.

Even in the Inventory List, if you show the "On Sales Order" column, it is blank.

Ahh, I see, yes that works the same way on mine. I just haven't ever searched for sales orders that way. The way I normally bring them up is through the "Open Sales Orders by Item" or "Open Sales Orders by Customers" reports.

Back to the subject, does anyone know how QB could give an item a negative avg cost? We have a part that went from a qty of zero before our physical inventory to 228 with a negative cost. It was NOT entered that way. If nothing else, QB would not allow us to put in a negative cost. So, where did it come from???

Obviously you had customers come in and drop off their spare parts in your bin.

You need to do a report on that part and see where you issued a credit memo and didn't have an invoice for it?

There has been no change in inventory for that part since the Physical Inventory. In fact, I have restored a backup from right after the Phys, and it shows a positive average cost. There have been NO transactions for it at all, but the avg cost is now negative. Also, according to the backup, at the end of the physical, we had an inventory value of around $250k. Now, if I go back through the Chart of Accounts into the Inventory Asset value to after inventory, it now shows an inventory value of only $35k! In fact, if I go back far enough, it now shows a couple of years ago we had a negative inventory value!! Something in QB2006 hicupped and it changed our inventory value going back to 1999 when we started using QB. Any ideas what would cause QB to, BY ITSELF with no transactions involved, change an avg cost negative?

None, but here is something to try. If you have a pre -06 file around, make a copy of it and convert the copy to -06. Without entering anything, see if your inventory valuation is the same as your pre -06 QB program comes up with. If it isn't, time to call QB, you've found a bug. If it does print the same, then you know it wasn't the conversion. You might want to look at a trial balance to see if something jumps out at you.