This can only be done through account movements (Accounting > Accounting outputs > Account movements), most commonly account 314001, by matching the positive and negative entries against each other.
Unreconciled Advances on Received Invoices
How to find outstanding advance payments on received invoices?
Written by Petr Pech