Victoria Yudin has a new SQL view to show monthly totals for Dynamics GP Vendors
SQL view to show monthly totals for Dynamics GP Vendors | Victoria Yudin
SQL & DataPayables & Receivables
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.