Getting Balance of Advance Payment


How can we obtain the balance that a customer has from their advance payment. Either in the form of report or sql query.

Currently that can be viewed in the Accounts Receivables Summary under the Total Paid Amount or in Journal Entry (Report Builder) However, its showing all the transactions. Is it possible to obtain the balance for the existing list of customers/party

Thanks & Regards