Leslie Vail give us a T-SQL View to create Dynamics GP GL Summary Trial Balance
Dynamics Confessions Blogspot: T-SQL View to create Dynamics GP GL Summary Trial Balance
SQL & DataGeneral Ledger & Financials
Archived post from 2017. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.