Multi-Company - Order Entry Sales by Customer and Item

Order Entry

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