What is the best way to return the Transaction totals (like Amount) along with other details from the Transaction Body? There is no "Transaction_Total" field in the "Transactions" table.

I want to return the same fields you're able to easily do using a custom search on Transactions where Type = "Invoice" and Mainline = True.

I need to return the following columns for each invoice:
Inv#
Inv Date
Customer
Ship Date
Days Overdue
Inv Total
Amount Paid
Amount Remaining

I know I can get the Inv Total by a SUM(Amount) on the Transaction_Lines table joins with the Transactions table. But what's the most efficient way to get all of the columns I need?