cancel
Showing results for 
Search instead for 
Did you mean: 
Yok33
Level 2

Open Invoice Statement

I am trying to create an Open Invoice Report for one specific customer.  I am having a hard time getting the Quantity and Unit Price (Sales Price) to show on the report.  Similarly, I would also like the "Item" and "Item Description" to show on the report.  I go into the customize report, then to window where you choose the available invoice information to show on report and check all of these and then go to filter and filter by customer, but the "item", "item description", "Qty" and "Sales Price" all are blank on the report itself.

 

Please help ASAP if you would.

 

Thank you,

 

2 Comments 2
SarahannC
Moderator

Open Invoice Statement

Hello there, Yok33.

 

I'll make sure to share you with the information on how the QuickBooks Desktop reports work. 

 

The program uses a concept called Source and Targets, which helps you maximize Report Filters. This way, you can create more effective reports. I'd encourage you to check on how QuickBooks generates reports. This includes information about the Source and Target concept. 

 

Another report that you can run is the Transaction Detail report. It gives you the option to customize and display the information you need, such as QTY, Item, and Sales Price. The steps below will help you get this done: 

 

  1. Go Reports on the left panel.
  2. Click Custom Reports. Then, select Transaction Detail.
  3. Click the Customize Report button.
  4. Add all the columns you need to generate by putting a check. (Item, Memo, Qty and Sales Price). You can utilize the Memo column for the item description.
  5. In the Filter tab, select Transaction Type. Then, choose Invoice.
  6. Search for Paid Status. Then, choose Open.
  7. Once done, click OK.

 

This is how it looks like:

anotehr w.PNG

Also, you can read through these resources for additional guide about handling reports in your company file:

 

 

If you have other questions later on, please don't hesitate to go back here and post them. I'll be here to help. Take care and stay safe.

SarahannC
Moderator

Open Invoice Statement

Hi Yok33,


Hope you’re doing great. I wanted to see how everything is going about getting the information you need from the report. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.


Looking forward to your reply. Have a pleasant day ahead!

Need to get in touch?

Contact us