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?
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.
Choose a location