In this video, I use a custom T-SQL script to exact both summaries from my Microsoft Dynamics GP General Ledger account numbers and my Budgets. Feel free to download the script and create your own view; or simply use the script within Microsoft Excel Query Editor, as I did. See the blog post for the script.
The blog was in response to a question posed to me. I hope it helps!