Multi-Company - GL Account Summary across 2 databases (Sage 300)

Sage 300
General Ledger

To use with Sage 300: 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