cancel
Showing results for 
Search instead for 
Did you mean: 
hiline1
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
Catherine_B
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
Catherine_B
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

hiline1
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.

 

KennyG
Level 1

Reports

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

hiline1
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

hiline1
Level 2

Reports

Refresh?

Maybelle_S
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
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up