If you’ve missed previous posts on this, Mohammad R. Daoud is pumping out a ton of great SQL code related to reporting in his Dynamics GP Reporting Series set of posts. Make sure to take a look.
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP