cancel
Showing results for 
Search instead for 
Did you mean: 
talk2khurram
Level 3

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,

 

Solved
Best answer August 29, 2020

Best Answers
gayatriluthfias20
Level 6

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:

  1. Go to the Reports tab.
  2. Choose Custom Reports.
  3. Select Transaction Detail.
  4. Click the Customize Report button.
  5. In the Display tab, update the report date.
  6. On the same page, click Paid from the Columns section.
  7. Go to the Filters tab.
  8. In the Filter section, click Posting Status then select Either from the options.
  9. Click Transaction Type from the Filters, and choose Purchase Order from the Transaction Type drop-down.
  10. Click OK.
  11. 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:

  1. Go to the Reports tab.
  2. Click Purchases.
  3. Choose Open Purchase Orders by Job.
  4. Click the Customize Report button.
  5. Go to the Display tab.
  6. In the Columns section, click Debit and Credit.
  7. Click OK.

Comment back, cheers.

View solution in original post

1 Comment
gayatriluthfias20
Level 6

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:

  1. Go to the Reports tab.
  2. Choose Custom Reports.
  3. Select Transaction Detail.
  4. Click the Customize Report button.
  5. In the Display tab, update the report date.
  6. On the same page, click Paid from the Columns section.
  7. Go to the Filters tab.
  8. In the Filter section, click Posting Status then select Either from the options.
  9. Click Transaction Type from the Filters, and choose Purchase Order from the Transaction Type drop-down.
  10. Click OK.
  11. 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:

  1. Go to the Reports tab.
  2. Click Purchases.
  3. Choose Open Purchase Orders by Job.
  4. Click the Customize Report button.
  5. Go to the Display tab.
  6. In the Columns section, click Debit and Credit.
  7. Click OK.

Comment back, cheers.

View solution in original post

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