Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 10, 2023
Question

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

  • February 10, 2023
  • 4 replies
  • 28 views

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.

4 replies

clemmAuthor
February 10, 2023

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?

QuickBooks Team
February 10, 2023

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.

clemmAuthor
February 13, 2023

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?