Victoria Yudin has updated her SQL view to show all GL distributions for AP transactions. Even better, I needed a script just like this. Thanks Victoria!
Updates to SQL view to show all GL distributions for AP transactions
SQL & DataGeneral Ledger & FinancialsPayables & Receivables
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.