Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Open Invoice report with item names and descriptions

The default Open Invoice report QuickBooks creates, cannot be modified to display the Item Name or the Item Description from invoices. 
The default Open Report will only display the source information of the invoice and not the target information. 
 
A Custom Transaction Detail Report will need to be created in order to display the Open Invoices and invoice detail such as Item Name and Item Description.
Solution Description
To create a custom report:
  1. In QuickBooks 2011 and earlier: From the Reports menu, select Custom Transaction Detail Report.
  2. In QuickBooks 2012 and later: Go to Reports > Custom Reports > Transaction Detail.
  3. Click on the Modify Report option.
  4. On the Display tab change the 'Total By' option to 'Customer'
  5. On the Display tab place a check mark next to Item and Item Description under Columns.(You can also deselect any columns you do not want (i.e. Debit & Credit).
  6. Click the Filters tab.
  7. In the Choose Filter window select Transaction Type, Under the Transaction Type select Invoice.
  8. In the Choose Filter window select Detail Level, Under Detail Level select All except Summary.
  9. In the Choose Filter window select 'Paid Status', select Open.
  10. Click OK. 
  11. The report will now display open invoices as well as the detail from the invoices including item names and descriptions. The report can now be memorized for future use.

If this solution does not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site. You can also review other available QuickBooks support options for additional guidance.

 

Your opinion counts!  Please use the voting and feedback buttons to help us build a better Knowledge Base.

KB ID# HOW12934
7/28/2014 3:31:01 PM
PPRDQSSWS403 9102 Pro 2013 692274