Skip to main content
A
Anonymous
August 28, 2020
Solved

Problem with the report "Transaction List by Vendor"

  • August 28, 2020
  • 1 reply
  • 0 views

I am running the report called Transaction List by Vendor for the prior fiscal year (2019).

 

The basic report works perfectly, however, when I customize the report so only show a single, specific Class. then the report show no data.

 

How do I solve this?

Best answer by

Hi there, @998777.

 

Let me step in and assist you with your concern.

 

The class field will appear once you turn on the Use class tracking for transactions option in your Company References. That way, you can assign the class to the transaction, and not as a line item. You can follow these steps on how:

 

  1. Go to the Edit menu.
  2. Select Preferences.
  3. Choose the Accounting tab.
  4. Click Company Preferences.
  5. Put a checkmark in the Use class tracking for transactions box.
  6. If you want a reminder when you haven't assigned a class, select the Prompt to assign classes checkbox.
  7. Click the OK button.

 

Once done, you can view the Class field on the top of the window when you create an invoice, sales receipt, estimate, and bill.

 

For more detailed information about setting up classes, you can read this article: Set up and use class tracking in QuickBooks Desktop.

 

Additionally, you can view this article for insights on how you can filter reports by class: Filter, sort, or total reports by Class in QuickBooks Desktop.

 

Please know that I'm always around here in the Community to help. Keep safe, and have a wonderful day.


@Rejeil_O @JasroV @Angelyn_T @katherinejoyceO @Candice C 

 

Sadly all of you are absolutely wrong. Please know that I REALLY do appreciate your efforts.

 

Be that as it may, 100% of the Intuit team members responses are so far off from correct, that it scares me that you all are not getting the proper product training to really support paying users on the platform.

 

It turns the product is able to support filtering the Transaction List by Vendor by class. And not one person was even in the ballpark getting the working solution. Instead, I was directed to do other stuff, read other articles, do anything but actually resolve the issue – which it turns out was 100% resolvable AND very easily.

 

Here is the solution – before I list the steps, you can watch the video from the following URL:

https://d.pr/v/S1nugu

 

  1. from the REPORTS window, run the Transaction List by Vendor report for the time period you want – once the report displays then do the following
  2. then click Customize Report
  3. show the Class column from the Display tab
  4. then go to the Filter tab and select class
  5. then choose the class you want to filter by
  6. then hit ok
  7. now the report will be blank (which was my issue that nobody could solve)
  8. now click Show Filters
  9. then click the X next to the Detail Level: Summary only

BOOM – done that's it!

 

That's literally it. That's the answer.

 

I hope the Intuit team members will show this to their managers and use it to explain that they need more product training. Please know the reason I come here to is to find expertise from dedicated Intuit team members. It makes me nervous that I am not getting it. Sorry to be harsh, just trying to share what its like to be a customer.

 

Many thanks for all the efforts.

1 reply

JasroV
JasroV
August 28, 2020

Thanks for sharing the details with me, @998777.


You’ll want to adjust the date of the report to All. That way, it'll show all the classes. Then, look for the year 2019 transactions for reference. Let me show you how in your QuickBooks Desktop (QBDT) software.

 

Here's how:

  1. Go to the Reports menu.
  2. Select Reports Center.
  3. Type Transactions List by Vendor from the search field.
  4. Click Run to open the report.
  5. Select Customize from the top menu.
  6. Click the Filters tab.
  7. Select Class from the filters menu.
  8. From the Class drop-down menu select Multiple classes and choose the class of your choice then click OK. 

You can also check this link for more details in customizing reports in your QBDT software.


Once done, you can memorize the report to save its current settings. This way, you won’t have to customize it in case you need to run it again in the future.

 

Let me know if you have other concerns about reports in your QBTD software @998777, it’s always my pleasure to help you anytime. Have a great day ahead.

A
Anonymous
August 30, 2020

@JasroV 

 

Thanks for this. I have not had a chance to do this yet, but I only need the data for fiscal year 2019 as mentioned in the original post.

 

How do I get just the class(es) I want AND just for the time frame I want.

 

Many thanks in advance.

J
JonpriL
August 30, 2020

Hello @998777,

 

Let's run the QuickBooks Utility tools so you can open and customize the Transaction List by Vendor report without any issues. Doing so, QuickBooks will automatically run a quick repair and fix possible data damage on your company file.  I'll show you how.

 

A. To Verify Data

  1. Go to File.
  2. Click Utilities.
  3. Select Verify Data.
  4. Click OK.

B. To Rebuild Data

  1. Go to File.
  2. Click Utilities.
  3. Select Rebuild Data.
  4. Click OK.

In addition, here's an article you can read to learn more about the QuickBooks tools: Verify and Rebuild Data in QuickBooks Desktop.

 

Lastly, I've also included this helpful article for ideas about the other vendor reports you can customize: Customize vendor reports.

 

Keep me updated in the comments if you have any other questions. I'll be here to lend a hand.

Terms & ConditionsAccessibility statement