cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
xrbbaker
Level 1

Transaction List by Customer Report - multiple PO's?

Hello,

 

The Transaction List by Customer Report would be very useful to me if I could customize it to include a list of POs.  It works great when I filter by a particular PO, but I want to see a report with only a certain list of about 10 POs.  Is there a way to do that?  I tried simply entering two PO numbers separated by a comma but no such luck.  -Thank you

7 Comments 7
Trish_T
QuickBooks Team

Transaction List by Customer Report - multiple PO's?

Hi xrbbaker,

 

I'm glad to see you reaching out to Community.  Welcome!  Using purchase orders is a great way to to let your suppliers know what items you're looking to purchase.  QuickBooks Online has the report you need to see a list of purchase orders you've created that can be customized.   I'd be happy to assist!

 

Here's how to see a list of purchase orders:

 

1. From the left menu, select Reports

2. Enter Purchases By Supplier Detail report 

3. Select the Date Range

4. From the drop-down arrow in the Group by field, choose Supplier

5. Click on the Customize button to the right

6. Open the Filter and Select the Transaction Type (Purchase Order) 

7. Use the drop-down arrow to select the Supplier and any other items you'd like on the report

8. Hit Run Report

Note:  You can also click on the small Gear in the top right of the report to Show More options.  This is where you can include the Customer and other fields.

9. Select Save Custom Report (optional) and fill the necessary fields to Share or Add to a Group of reports.

 

Here's a couple of articles for your reference:

Run reports in QuickBooks Online

Customize reports in QuickBooks Online

 

If you have any other questions, please reach back out.  We'd be glad to help!

xrbbaker
Level 1

Transaction List by Customer Report - multiple PO's?

Thank you but my question is, is there a way to create a list of POs within the filter?  I don't want to have to enter in a PO, run the report.  Enter in a different PO and run the report... times a dozen different POs.  I'd like to create a list of POs such that the report runs for just the POs in that list.  Does that make sense?  -Thank you

Trish_T
QuickBooks Team

Transaction List by Customer Report - multiple PO's?

Hi xrbbaker,

 

I'm glad to see you reaching back out for clarification on creating a list of purchase orders.  When using the reports in QuickBooks Online, customization is an incredible feature that offers everything you need to see what you want on one report.  I'd be happy to provide the options available for you!

 

In addition to the information in my previous post, when you type 'Purchase" into the search field, it brings up a list of all available reports for anything related to purchases.  Whether by class, location, product/service, supplier and open invoices.  When you Customize and open the filter you'll set your Transaction Type to Purchase Order.  You'll then go down the list and use the drop-down arrow to select Not Specified and then hit Run Report.  You may prefer to review the Open Purchase Order List report.  Open the report and set your Date Range and Group by fields and then hit Run Report.

 

Please don't hesitate to reach back out if you have any other questions or need additional assistance.  We're here for you!

 

xrbbaker
Level 1

Transaction List by Customer Report - multiple PO's?

Hi - Thanks for trying to help me.  When I key in "purchase" into the search field, there is no Purchases By Supplier Detail report.  What I'm trying to do is get a list of invoices by Purchase Order.  I don't need a list of Purchase Orders.  I want to see all of the Invoices for Purchase orders 123 and 345 and 454 and 676, etc.  I can do it one at a time.  I bring up the Transaction List by Customer Report, filter by transaction type: invoice, customer:  abc, PO Number: 12345.  I give it a date range of 1/1/2021 - 10/31/2021.  This then brings back all of the invoices for that PO for that timeframe.  PERFECT!  What I'm trying to do is instead of just having it search and report on one PO number, I want to give it a list of PO numbers.  That way I don't have to run the report 10 times, changing the PO number each time.  Thanks.

JamesM4
QuickBooks Team

Transaction List by Customer Report - multiple PO's?

I can see the benefit of being able to have the report you've described. Since this report isn't available in QuickBooks, I encourage you to send feedback about this to our engineers. The good thing is you can directly send feedback to our engineers by clicking the Gear icon > Feedback. Are you able to locate the Purchases By Supplier Detail report on the Reports screen in QuickBooks? The report should also appear under Expenses and suppliers. I'll be on standby. 

xrbbaker
Level 1

Transaction List by Customer Report - multiple PO's?

Thank you.  In "Expenses and vendors" I have:  Purchases by Product/Services Detail, Purchases by Class Detail, Purchases by Vendor Detail.  It shows the same 3 reports when I search the "Find report by name" box.  There is no Purchases by Supplier Detail.  One note.  I'm in the US and I see the Canada flag in the upper right.  Could that possibly make the difference?  -Thank you

Trish_T
QuickBooks Team

Transaction List by Customer Report - multiple PO's?

Hi xrbbaker,

 

Thanks so much for the additional information and your location.  QuickBooks Online Canada features will have some differences that would definitely have an impact when searching for a specific report.  I'd be happy to point you in the right direction so you can get back to what you love!

 

Please follow this link to touch base with QuickBooks Community in the U.S.

 

It was a pleasure working with you.  Take care and enjoy the rest of your day!

 

 

Need to get in touch?

Contact us