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

"Qty on PO" field not included in export, but showing on screen when looking at Sales-All Sales in QBO

Hello folks,

 

I am trying to export my "Products and Services" list to Excel, and have the column "Qty on PO" included which is showing on my screen in this list.

 

When I export to Excel, it is not in the spreadsheet however, thoughts?

 

Thank you.

 

1 Comment
Highlighted
Moderator

"Qty on PO" field not included in export, but showing on screen when looking at Sales-All Sales in QBO

Good day, Patterns Guy.

 

The Quantity on Purchase Order (Qty on PO) won't show up when you export an Excel file from the Product and Services list. The system always follows the default columns. Though, you can use the Product and Services report, then add the Qty on PO column. Here's how:

  1. In the left panel, click on Reports tab.
  2. In the Search (magnifying) box, type Product then, and then choose Product/Service List.
  3. Under Product/Service List Report page, click on Customize button.
  4. In the Rows/Columns drop-down arrow, click Change columns.
  5. Put a check on Qty On PO box.
  6. Click Run report.

QuickBooks Community team is always open for all your inquiries. Have a great one!

Need to get in touch?

Contact us