We have some clients with account credits that were from overpayments. When we view all clients nothing shows on their balance that that client has a credit balance. It shows a nil.
We only found them by accident in the clients console.
How do we find any other clients who have a credit balance without going into every single client console which will take ages.