Stonefield Query for
|
A user-friendly database report writing, query, and data mining tool designed specifically for Sage Pro ERP®
Now you can put Business Intelligence reporting in the hands of the end-user where it belongs.
Stonefield Query has been customized specifically for Sage Pro ERP® giving you an intuitive, easy-to-use BI reporting solution that you will love!
Stonefield Query has all of the built-in features you expect in an enterprise reporting solution including a Report Scheduler, Role-based Security, Report Templates, Drill Downs, Exclusion/Inclusion Filters, Emailed Reports, Customizable SQL Select, Advanced Report Designer and Multiple Output Options.
Now your sales people, administrative staff, and management can take advantage of the wealth of information stored in your Sage Pro ERP® system when they need it.
You can create elegant and persuasive Quick Reports, Charts/Graphs, Cross-Tabulation Reports and Labels (mailing, barcode, etc) in minutes with little or no technical knowledge.
No more waiting for the already overburdened IT or report developers to build reports on their timetable.
|
|
Sage Pro ERP® Specific Features
-
Stonefield Query works with Sage Pro ERP version 7.7 (2011) and earlier, with any of the database engines Sage Pro supports
-
Combines records from 'Current', and 'History' tables into 1 table for ease of use. Also, Stonefield Query automatically hides records from the 'Current' table that also exist in the 'History' table
-
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
-
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
-
Allows you to consolidate records from multiple companies into one report |
|
|
|
