Multi-Company A/P Purchases by G/L Account (Sage 300)

To use with Sage 300: Go to Properties > Cubes > SQL Query and replace 'ORCIN2' with your Company 2 database ID. There are 4 parts to the query, linked by UNION ALL.  The first two uses the cube connection details, the last two need the 2nd database name in the query. 

This cube requires Info Explorer Full or Writeback licence.