cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
clemm
Level 2

PO # column blank when running cost report - QB's Desktop help

I am trying to run a Job costs by vendor and job detail report (or similar), and when I add the PO # column in customize report, the column is blank. This is the case for every report I try to run to see what an item or transaction's associated PO number is. Each of these items in the below screenshot are associated with a PO, but they do not show up here. Anyone know why this is showing as blank and how to fix it? I need to see what PO was associated with each item over the last 5 years, so I can't do anything manually when it comes to thousands of lines of data. Thanks.

QB's Pic.png

4 Comments 4
clemm
Level 2

PO # column blank when running cost report - QB's Desktop help

To clarify, I am looking to have the VENDOR PO number shown for each item that is associated with it. I think the PO Number column in the report is trying to trace to the CUSTOMER PO number, which obviously wouldn't be connected to a billing item. 

 

Any ideas how to have a cost report by item show the associated vendor PO for each item?

CharleneMaeF
QuickBooks Team

PO # column blank when running cost report - QB's Desktop help

Adding the purchase order number is a great functionality, clemm.

 

As of now, you can only add the customer purchase order when running reports in QuickBooks Desktop. I'd suggest looking for a third-party app that can integrate with the program. This way, you'll have the option to add purchase order number to the Job Costs by Job and Vendor Detail report. 

 

Here's how: 

 

  1. Go to this link: https://desktop.apps.com/home.
  2. Choose the All Applications tab.
  3. Select the version in QuickBooks Compatibility and other appropriate options in the Categories and Developer sections.
  4. Enter Customize Job Cost Reports in the Search box.
  5. Click Search.
  6. Select View profile to learn more about the apps.
  7. Choose the right app for your business.

 

I'd also recommend sending feedback directly to our Product Development team. This helps us improve your experience and the features of the program. I'll show you how:

 

  1. Go to the Help menu and then select Send Feedback Online.
  2. Choose Product Suggestion.
  3. Add the type of feedback.
  4. Type in your feature suggestion.
  5. Once done, click Send Feedback.

 

For more details about running reports, please see this article: Understand Reports.

 

Additionally, I've included an article that'll help you assign a unit of measure in QuickBooks. This ensures you can easily track your items: Show Quantities, Prices, Rates, and Costs for an Item.

 

I'm only a few clicks away if you need assistance in managing your sales and expense transactions in QuickBooks. It's always my pleasure to help you out.

clemm
Level 2

PO # column blank when running cost report - QB's Desktop help

It does not seem like any of the third party apps support this reporting need.

 

Is there any ability within QB's desktop reporting to determine the time between invoice creation and receipt of items on the PO? If I can't trace a cost report to vendor PO's, how to I know how long it takes my suppliers to deliver the items I order?

AileneA
Moderator

PO # column blank when running cost report - QB's Desktop help

We hear you, clemm. 

 

I understand how the workflow you're looking for is beneficial to your business. However, as of this moment, we don't have the report to determine the delivery time of the items you've ordered from your supplier in QuickBooks Desktop. 

 

I recommend following my colleague's steps above on how to send feedback. These requests and suggestion are forwarded to the Product Development Team, and I want to let you know that your voice matters, and each update our developer team creates is considered that it benefits our customer's business. 
 

To know more about reports available in QBDT, check out this article: Understand reports.


Additionally, for more information about managing and customizing reports in QBDT, consider checking out this article for future reference: Customize reports in QuickBooks Desktop.


If you have other questions, please let us know by posting another one in the Community. Take care and stay safe always.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us