Other 2 field not populated on Purchase Order report

Hello there, @Anthony Howard.

QuickBooks follows the Sources and Targets concept to build a company and financial reports. This means that the data you see on every report is derived from the details of its source transaction.

Since the columns having blank data, consider that this report you're pulling up involves transactions without these fields. Therefore, the system is unable to pull the information in there.

As a workaround, you may pull up another report that shows open purchase orders. Then export it to Excel and combine the information manually there.

Here's how: 

1. Go to the Reports menu.
2. Select the Open Purchase Order from the result.
3. Click the Customize Report button at the top and update the Report Date Range.
4. Once done, go to the Filters tab.
5. In the Filter search box, enter and select Transaction Type. Choose Multiple Transaction Types and or other transactions you need.
6. Hit OK when you're done.

Once you have the data ready, export both reports to Excel using the Excel button at the top of the report. From there, fill in manually or copy the columns to get the desired reporting format.

Another option is using the Memo field. Double-click the transactions on the report and add the check number and paid date one at a time in that field. That way, you're on the same report and no longer need to export anything outside the program.

I'm also adding this article to learn more about the reports in QuickBooks: Understand reports.

Let me know if you have other questions. I'm always here to help.

Excuse my follow-up, but what's the second report your suggesting I run to combine with my Purchase Orders report?  The steps you've outlined....

1. Go to the Reports menu.
2. Select the Open Purchase Order from the result.
3. Click the Customize Report button at the top and update the Report Date Range.
4. Once done, go to the Filters tab.
5. In the Filter search box, enter and select Transaction Type. Choose Multiple Transaction Types and or other transactions you need.
6. Hit OK when you're done

...seems to create a Purchase Order report that is still missing this 'Other 2' data.  Are you suggesting I can run a different report that shows the 'Other 2' data and match the two together?  If so, what steps do I take to report on the 'Other 2' information?  Thanks.