Cash Receipts Journal with Invoice Amount

SUGGESTED

Hello! I have Sage 50 and also the Intelligence Reporting. My question; Is there any was possible to create a report that is the cash receipts journal that has what the total $ the invoice is for whether or not if only 50% of it was paid? I can get the invoice #, the amount paid, customer, etc. But I need a report that shows me the total amount of the invoice too. Basically a report that will tell me each month; out of all the cash receipts, which invoices were paid in full? 

Also, I thought the intelligence reporting was going to be the answer but it looks like it only helps with customizing financial statements. What is the "Connector" add on? Will that help me customize more thorough reports of what I need? Like cash receipts, job profitability reports, etc.?