Stonefield Query supports reporting on data from the Orion Point of Sale (POS) system. Once you have done the necessary steps to allow Stonefield Query to find the Orion database (described below), you can then use Stonefield Query to report on both your Sage 300 main database and your Orion database at the same time.

Orion stores its data in a different database than Sage 300. Orion doesn't create an ODBC DSN automatically so you have to create one yourself. Stonefield Query expects that there is an ODBC DSN with the same name as the main Sage 300 company DSN but an "ORION" suffix. For example, if you have an Sage 300 DSN named "Sample Company," you need to have another DSN named "Sample CompanyORION" that points to the Orion database.

For details on how to set up ODBC DSN connections, please see the Managing Databases topic.