I have been trying to figure out a way to report on PO's with receipts that have not been invoiced, ideally with QQUBE and PowerPivot.  I think the issue may be that the example PO report provided by QQUBE is for open PO lines and once a lin eis fully received QuickBooks and QQUBE consider it closed.  Am I missing something or is there a workaround?

Thanks

If you use the purchase subject, you can use the Purchaes Orders as your Document Type, and then filter by Linked Posting Transactions = 'Item Receipt'.   The linked transactions are not available to use in the PowerPivot tables - only the regulard pivot tables.

Alternatively you could use Access or Crystal Reports to get the information.