GL Account Summary across 2 databases

General Ledger

To use: Go to Properties > Cubes > SQL Query and replace 'SAMLTD' with your Company 1 database ID and 'ORCLTD' with your Company 2 database ID. There are 4 parts to the queries, linked by UNION ALL

Note: The cube now includes the Opening balance from GLAFS. You can't add multiple years on the Consolidated balance sheet view. 

This cube requires Info Explorer Full or Writeback licence.

GL Sample cube