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

Reports

How do I create an itemized transaction report by customer?

I'm not looking for billing and payments recieved. I'm tryiing to find ALL purchases for materials on a particular job.

Thank YOu

Solved
Best answer February 04, 2020

Best Answers
Highlighted
QuickBooks Team

Reports

I'm here to walk you through in creating a report that you need, hiline1. 

 

We can pull up the Job Costs by Vendor and Job Detail to show the list of items in the vendor transaction with the job linked per item. 

 

Let me show you how:

  1. Go to the Reports menu and choose Industry Specific
  2. Select Job Costs by Vendor and Job Detail
  3. Click the Customize Report button.
  4. From the Display tab, search and check Item in the Search Columns field. 
  5. Click OK

When you create a Check or Bill with different items associated to different jobs, the item will be filtered under the job. You can refer to the screenshot below. 

 

You can check out these article that will help you in running vendor reports and customizing them. Let me know if you need more help!

View solution in original post

6 Comments 6
Highlighted
QuickBooks Team

Reports

I'm here to walk you through in creating a report that you need, hiline1. 

 

We can pull up the Job Costs by Vendor and Job Detail to show the list of items in the vendor transaction with the job linked per item. 

 

Let me show you how:

  1. Go to the Reports menu and choose Industry Specific
  2. Select Job Costs by Vendor and Job Detail
  3. Click the Customize Report button.
  4. From the Display tab, search and check Item in the Search Columns field. 
  5. Click OK

When you create a Check or Bill with different items associated to different jobs, the item will be filtered under the job. You can refer to the screenshot below. 

 

You can check out these article that will help you in running vendor reports and customizing them. Let me know if you need more help!

View solution in original post

Highlighted
Level 2

Reports

Thank You Catherine_B

Sorry for the slow response. I just got back in town.

With a little extra tweaking, this gives me exactly what I wanted.

 

Highlighted
Level 1

Reports

When I go to reports, and enter the criteria, there is no search button???

Highlighted
Level 2

Reports

Is there a refresh button?

Not sure what version you're in or what report you're running but that's how I get there

Highlighted
Level 2

Reports

Refresh?

Highlighted
QuickBooks Team

Reports

Hello there, @KennyG.

 

QuickBooks Desktop provides different reports that cater to your business needs. All available reports can be accessed through the QuickBooks Reports menu.

 

However, the industry-specific is only available in QuickBooks Enterprise and Premier version. If you're using QuickBooks Pro, I can help you run Vendor Balance Detail.

 

Here's how:

  1. Go to the Reports menu.
  2. Hover over Vendors & Payables, then choose Vendor Balance Detail.
  3. Click Customize Report, then select Filters.
  4. From the Display tab, search ItemFirst name, and Last name in the Search Columns field.
  5. Put a checkmark beside the ItemFirst name, and Last name.
  6. From the Filters tab, search Paid Status in the Search Filters field.
  7. Under Paid Status, click the Open radio button.
  8. From the Filters tab, search Detail Level in the Search Filters field.
  9. Under Detail Level, click All except summary radio button.
  10. Once done, click OK.

 

Also, you can visit this article if you want to customize reports: Customize reports in QuickBooks Desktop.

 

Please drop a comment below if you're referring to something else. I'm always here to lend you a helping hand.

Need to get in touch?

Contact us