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.
Dynamics GP Reporting Series
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.