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" interface. After selecting a report from the list of available reports, you can select the sort order, enter filter conditions, and select where the output goes (printer, text file, spreadsheet, screen preview, etc.).
- Full English descriptions for all field and table captions rather than cryptic names and symbols. English operators such as "equals" and "greater than" instead of "=" and ">" are used.
- Handles complex join conditions 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 graphs, either by themselves or included in other reports.
- 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.
- Drilldown 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 schedule 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.
In addition to these features, Stonefield Query for Sage Pro ERP has the following special features:
- Stonefield Query works with Sage Pro ERP version 7.4 and earlier, with any of the database engines Sage Pro supports.
- Displays the expected value for many code fields rather than the actual values as Sage Pro stores them. For example, the Type of Invoice field in the Accounts Receivable invoice master table is actually stored as a single-letter code (blank, C, R, T, or F) rather than the value you expect. Stonefield Query displays the expected values (Normal Invoice, Credit Memo, Open Receipt Record, Tax Only Credit Memo, or Finance Charge Only) so you don't have to figure out what those code values mean.
- Many tables have separate current and history versions (for example, Current Invoice Master Filer for current Accounts Receivable invoices and YTD Invoice Master FileHistory for historical invoices). Creating a report that shows all current and historical records is difficult in other reporting tools but Stonefield Query makes it easy: simply select from the "current + history" table (for example, Invoice Master File (Current + History), which combines current and historical invoices into one table). Also, Stonefield Query automatically hides records from the current table that also exist in the history table.
- 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.
- Automatically handles fields which Sage Software renamed from one version of Sage Pro to another, so there's no need to modify reports when you upgrade from older versions of Sage Pro as you'd have to with other reporting tools.
- Automatically handles custom field sizes and data formats.
- Provides an Import Report Writer function to import reports from the Report Writer module available in earlier versions of Sage Pro.
- Automatically displays blanks for dates that you haven't filled in a value for rather than 01/01/1900, which is what Sage Pro actually stores for those dates in the SQL Server version.
- 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.
- Only displays those tables and fields actually available in the version of Accpac you use.