Have you tried Sage Intelligence report templates?

Sage Intelligence comes with several financial and operational templates that can be accessed using one of the 5 free Report Manager licenses for Sage ERP 500.  For more information on how to a get started with Sage Intelligence follow this link: http://www.alchemex.org/FTPBICommunity/121127_Sage-500-74-Business-Intelligence-Getting-Started-Guide.pdf

Have you tried the Free Report Templates group at the Sage Intelligence Community site? http://www.sageintelligencecommunity.com/page/free-report-templates-sage-500-erp-intelligence-reporting The templates are provided by other Sage Intelligence gurus free for you to use.  Check them out.