Sivakumar is on a roll with a new SQL View for Daily Payment Summary
SQL View for Daily Payment Summary | Interesting Findings & Knowledge Sharing
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.