Loading ...

Posted in: QQube    Excel Power Pivot

PO report for received but not invoiced?

Subscribe to RSS
  • 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

  • Answered

    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.

Page 1 of 1 (2 items)