Multi-Company (Sage 300) - Order Entry Sales by Customer and Item

Sage 300
Order Entry

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

This cube requires Info Explorer Full or Writeback licence.

Multi-Company Order Entry