Victoria offers up a SQL view for Dynamics GP open year GL trial balance with month end balances
SQL view for Dynamics GP open year GL trial balance with month end balances | Victoria Yudin
SQL & DataGeneral Ledger & Financials
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.