In QuickBooks desktop, I would like an Accounts Payable report that shows, for each vendor:

Bill Date

Reference Number

Due Date

Amount (original amount of the invoice)

Amount Paid (amount of partial payments made on each invoice)

Open Balance (difference between 2 amounts above)

This is for an accounting client who enters large bills to vendors, then pays them down periodically in partial payments. 

I have attempted to create this by customizing the Unpaid Bills Detail report by adding the needed columns, but the "Amount Paid" column always shows $0, even though there have been payments on these bills.  

Any help is appreciated. Screenshot of my failed report attached.