Features - Stonefield Query

Stonefield Query has the following features:

Powerful query and reporting tool designed with the end-user in mind. Design reports in minutes, not hours or days.
Simple wizard-based interface. After selecting a report from the list of available reports, you can select the sort order, enter filter conditions, and specify where the output goes (printer, spreadsheet, PDF file, screen preview, etc.).
Descriptive names for all fields and tables rather than cryptic names and symbols. Descriptive operators such as "equals" and "greater than" instead of "=" and ">."
Handles complex joins between tables automatically.
When you create a report, you can specify whether other users can change the filter conditions or the way it's sorted. You can even define reports that are only accessible to specific users.
Create great-looking charts and gauges, either by themselves or included in other reports.
Display dynamic dashboards of important information you need to run your business.
The Formula Editor allows you to define your own custom calculations to use in any report.
Templates give your reports a common appearance, such as following corporate style guidelines.
Easily create labels, including mailing labels, product labels, or barcode labels, without worrying about field positioning or label dimensions. All the common Avery label sizes are built-in.
Drill down from a report to see details.
Click the Values button to get a list of all possible values for any field.
Control font, color, alignment, heading, and column width for each field. Group on any field with a mouse click.
Automatically adjusts column widths to match the data in the column.
The Advanced Report Designer allows you to lay out the report exactly as you want, including company logos, lines, boxes, etc.
Output to Microsoft Excel, PDF, HTML, Microsoft Word, comma-delimited, or other types of files. You can also email reports.
Knows your data. You don't have to know how your data is stored or how tables are joined (you don't even have to know what a "join" is).
Schedule reports to run at any time you need.
Import reports so you can use report layouts designed by other users or consultants.
Export reports so you can share report layouts with other users.
Display "real" table and field names so it's easier to locate the table or field you want if you're familiar with these names.
Add new data sources, such as Microsoft Excel or Access, and connect them to your existing database with a few mouse clicks.

In addition to these features, Stonefield Query for Sage 300 has the following special features:

Stonefield Query works with Sage 300 and Sage Accpac versions 2021 and earlier, and can report on Unisales Sales Analysis and Orion Point of Sale (POS) data as well.
Displays optional fields in the table they are associated with rather than in the table Sage 300 internally stores them in, making it much easier to query on optional fields. For example, suppose you've created an optional field for Accounts Receivable customers that stores the date they signed a contract. Although it appears in the customer screen, Sage 300 actually stores this field in a different table (named ARCUSO) than it stores customers (the ARCUS table). Using another reporting tool to access this optional field means knowing how to set up a join between the ARCUS and ARCUSO tables, filtering ARCUSO so it only shows the contract date optional field, and converting the value for the field, which is actually stored as a character string, to a date value. Whew! Good thing Stonefield Query makes it easy: the contract date field appears in the same list of fields as the other customer fields do, and Stonefield Query takes care of all of the work behind the scenes.
Contains user-definable calculations in payroll tables that make creating payroll summary reports much easier.
Displays the expected value for many code fields rather than the actual values as Sage 300 stores them. For example, the Document Type field in the Accounts Payable Invoices table is actually stored as a numeric value (1, 2, 3, or 4) rather than the value you expect. Stonefield Query displays the expected values (Invoice, Debit Note, Credit Note, or Interest) so you don't have to figure out what those numeric values mean.
Automatically converts dates, which Sage 300 stores as numeric values (for example, "20080304" for 03/04/2008), into true date values, which works better for display purposes and for date expressions.
Displays the company name rather than the database name in the Reports Explorer status bar, the Open Database dialog, and optionally the header of reports.
Only allows querying on modules that are activated and that the user has access to.
Allows you to consolidate records from multiple companies into one report. For example, you could show all outstanding invoices from all companies on the same report, including showing which company each one came from.
Only displays those tables and fields actually available in the version of Sage 300 you use.
Displays the description for General Ledger account and Inventory Control segments.