I've checked all of your recommendations along with an online Quickbooks agent twice, they could not figure it out, and it's not working.  As mentioned the accrual balance sheet inventory balances are correct and reflect all transactions.  The cash balance sheet only reflects the opening inventory balance and doesn't list all of the transactions.  It's believed to be a coding issue of some sort.  Quickbooks notified me that it has been an issue for other clients as well and they were working on it, but that was a month ago....