veeyeskay gives us one more SQL Script, this one for Checkbook Balance
SQL Script for Checkbook Balance
Payables & ReceivablesSQL & DataDevelopment & Integration
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.