How to consolidate the GL Accounts ?

Hi,

I need to know if there is a tool in SAP B1 2005 A to consolidate the GL Acounts.

My guess would be to create a new Database, then to write an SQL query that will take the data from all the required companies and merge it into the new DB. But maybe there is a real tool that do that for me ?