cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Mwaqar
Level 1

Item name/description is not showing in report

I am trying to generate a report containing all transections and net balance of customers (transection by customer). Report is generated showing correct balance and transection (invoice/Payment) amount. But it does not show the item of any invoice (what is sold to the customer). How can i solve this issue.

3 Comments 3
Tori B
QuickBooks Team

Item name/description is not showing in report

Good morning, @Mwaqar

 

Thanks for taking the time to reach out to the QuickBooks Community for support. I hope you're enjoying the day so far. 

 

Since you'd like to see the item included on your report, I recommend we use the Custom Transaction Detail report. I've included some steps to run and customize the report below. 

 

  1. Go to the Reports menu. 
  2. Choose Custom Reports, then Transaction Detail
  3. In the customization window, make any necessary changes. Also, you'll want to ensure in the Display tab to select the Item and Item description columns.  
  4. Hit OK when you're finished. 

 

Then your report should show everything you need. I've included an example report below to reference. 

 

 

That should do it. For additional details about customizing reports, check out Customize reports in QuickBooks Desktop

 

Please let me know if you have any further questions or concerns. I'm always here to lend a hand. Take care! 

 

Mwaqar
Level 1

Item name/description is not showing in report

I tried by generating custom report but it mess up the transections and customer balance and increased  transections which i dont understand. I run manufacturing industry and use build assembly feature. Image is attached for understanding. First is custom generated report have items and second image is customer balance details with actual transections, but it does not show items even selected.Custom transection report.pngCustomer balance detail.png

AlcaeusF
Moderator

Item name/description is not showing in report

Hi @Mwaqar,

 

Thank you for getting back and sharing screenshots about the result. Allow me to provide additional information about running reports in QuickBooks Desktop.

 

When you run a transaction report, the line items on a specific invoice will show separately. That's why it looks like invoices are increasing when viewing the data.

 

The balance appearing in the transaction report will base on the debit and credit columns. Since these two have different targets for the data, the Customer Balance Detail will show the correct balance based on your invoices and payments.

 

Items will not show in the customer balance report because of the sources and targets. The source is the Report set. That's why only summary information of the transaction show and not the detailed info like the item and item description.

 

I want to share a link that helps you know more about how the reports work. It'll help with customizing and choosing the right report based on what you need: Understand reports.

 

Additionally, I've attached an article for your reference on how to configure reports in the Desktop version: Customize reports in QuickBooks Desktop.

 

Drop me a comment if you have questions about the reports or gathering data. I'll be around to help. Have a great day ahead.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us