Multi-Company A/P Purchases by G/L Account

Accounts Payable

To use: 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.

Multi-Company AP Purchases