Purchase Order Report

talk2khurram · ‎August 29, 2020

Hello

Kindly find attached Purchase Order and Vendor Balance Detail Report.

My question is I want to see my purchase order report like Vendor Balance Detail Report.

My purchase order report showing a grand total. I want to see subtotal vendor wise than a grand total.

Thanks and regards,

gayatriluthfias20 · ‎August 29, 2020

Hi @talk2khurram , thank you for joining QB community.

You'll need to pull up 2 reports so you can compare the transactions and balances. Here's how:

Go to the Reports tab.
Choose Custom Reports.
Select Transaction Detail.
Click the Customize Report button.
In the Display tab, update the report date.
On the same page, click Paid from the Columns section.
Go to the Filters tab.
In the Filter section, click Posting Status then select Either from the options.
Click Transaction Type from the Filters, and choose Purchase Order from the Transaction Type drop-down.
Click OK.
In the Total By drop-down, select vendor.

This report will show the PO's received or billed. To view open PO's, you can use the Open Purchase Orders by Job. Follow the steps below:

Go to the Reports tab.
Click Purchases.
Choose Open Purchase Orders by Job.
Click the Customize Report button.
Go to the Display tab.
In the Columns section, click Debit and Credit.
Click OK.

Comment back, cheers.

View solution in original post

gayatriluthfias20 · ‎August 29, 2020

Hi @talk2khurram , thank you for joining QB community.

You'll need to pull up 2 reports so you can compare the transactions and balances. Here's how:

Go to the Reports tab.
Choose Custom Reports.
Select Transaction Detail.
Click the Customize Report button.
In the Display tab, update the report date.
On the same page, click Paid from the Columns section.
Go to the Filters tab.
In the Filter section, click Posting Status then select Either from the options.
Click Transaction Type from the Filters, and choose Purchase Order from the Transaction Type drop-down.
Click OK.
In the Total By drop-down, select vendor.

This report will show the PO's received or billed. To view open PO's, you can use the Open Purchase Orders by Job. Follow the steps below:

Go to the Reports tab.
Click Purchases.
Choose Open Purchase Orders by Job.
Click the Customize Report button.
Go to the Display tab.
In the Columns section, click Debit and Credit.
Click OK.

Comment back, cheers.

HGM · ‎November 16, 2021

Regarding Step 6 in your post........In the Display Tab: determining what columns I want to display......that seems to be a preset list. My purchase order is customized to display a "Job Name" along with "Expected" and "Ship Via". Can I customize the Columns to select from to display my Job Name?

Mich_S · ‎November 16, 2021

Thanks for joining the thread, @HGM.

I understand the importance of being able to customize a purchase order report in QuickBooks.

Currently, there's no option to add a Job Name on the Purchase Order by Jobs report. You can manually open the PO instead to check the job name associated with it.

Here's how:

Go to the Vendors menu.
Select Vendor Center.
Locate and open the vendor name the PO is associated with.
Double click the PO you want to review the job name with.

I'm adding these photos for your convenience:

Furthermore, you can export the report in QuickBooks Desktop. This will help you access all information from the PO.

Check out this article also to know more about how to handle POs in QBDT: Manage purchase orders in QuickBooks Desktop.

It's my pleasure to always help if you have other questions with QuickBooks or PO. Just feel free to comment back to this thread. Take the best care!

Topics

Training

Community

Resources

Purchase Order Report