Hi DBunz!

Thanks for the screenshot. Let me show you another report you can pull up that is similar to what you need.

Let's run the Open Invoices report, then customize it. Follow these steps:

1. Go to the Reports menu, Customers and Receivables, then Open Invoices.
2. Click the Customize Report button. From the Columns section under the Display tab, search and select these columns:
   • Type
   • Date
   • Num
   • Open Balance
   • Amount
3. Tap OK.

This is how it looks like:

However, since the Open Invoices report also shows the invoices that aren't paid, without partial payments, you'll want to export it to an Excel file. From there, you can remove those invoices. Simply click the Excel drop-down and select Create New Worksheet.

In addition, you'll want to visit https://developer.intuit.com since you mentioned Google Script. They can help you if you're building an application or integrating an app to QuickBooks Desktop.

I added this link for your reference in running, customizing, and saving a report in QuickBooks Desktop: Understand reports.

Comment again here if you have follow-up questions about running reports. Take care!