veeyeskay has provided some new SQL scripts designed to facilitate balancing Payables and Receivables subledgers to the GL.
GL Reconciliation SQL Script – Payables and Receivables
Payables & ReceivablesGeneral Ledger & FinancialsSQL & Data
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.