Stonefield Query for Sage Pro ERP is quite simply the most powerful, easy-to-use reporting product on the market for your Sage Pro data. And now it's available in three different tiers to fit every budget.
Stonefield Query provides a step-by-step method to create professional business reports from information stored in Sage Pro ERP. Anyone can create detailed reports, high level overview, drill-down, charts/graphs, pivot tables, and more in minutes rather than hours.
Stonefield Query knows the Sage Pro ERP database structure, and has been delivering industry-leading reporting solutions for years. With three new tiers to fit everyone's budget, it has the following special features:
Get started immediately with our sample reports! Stonefield Query comes with numerous sample reports that can be run or used as a starting point for report design, and used with our Basic viewer program in runtime.
Reporting Made Simple
Stonefield Query walks you through the reporting process in 6 easy-to-follow steps so you can build professional reports in minutes, not days.
Displays Dates Properly
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.
Import Report Writer Reports
Provides an Import Report Writer function to import reports from the Report Writer module available in earlier versions of Sage Pro.
Easily Report on Both Current and History Records
Many tables have separate current and history versions (for example, Current Invoice Master File for current Accounts Receivable invoices and YTD Invoice Master File History 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).
Handles Code Fields
Displays the expected value for many code fields rather than the actual values as Sage Pro stores them so you don't have to figure out what those numeric values mean.
Displays Segment Descriptions
Displays the description for General Ledger account and Inventory Control segments.
Only allows querying on modules that are activated and that the user has access to.
Schedule and Automatically Deliver Reports
Automatically deliver reports via e-mail, file, or printer. Schedule them to run anytime you need them to, and never miss a reporting commitment to your peers, customers, or vendors (requires Ultimate).
Charts, Graphs, and Dashboards
Create bar, line, area, and pie charts as well as series charts. Dashboards combine multiple charts into one consolidated view of your data. Zoom in and out on the dashboard, update individual reports manually, and output the dashboard to file.
Microsoft Excel PivotTable Reporting
Extend your data analysis with Microsoft Excel PivotTables.
Create Your Own Custom Formulas
Define your own custom calculations to use in any report. Use any of the hundreds of built-in functions or create your own.
Filters and Exclusions
Filters allow you to narrow down your results without programming, such as product sales by customer for this year, month, or week. Exclusions allow you to report on things not recorded in Sage Pro, such as all companies that bought something last year but not this year.
Multiple Database Support
You can run reports on more than one Sage Pro database. You can even consolidate records from multiple companies into one report (requires Ultimate). For example, you could show all outstanding invoices from all companies on the same report, including showing which company each one came from.
|Run any type of report||X||X||X||X|
|Includes built-in reports||X||X||X||X|
|Import reports created by others||X||X||X||X|
|Prompt for filter values ("ask at runtime")||X||X||X||X|
|Output reports to file (PDF, Excel, etc.)||X||X||X||X|
|Support multiple databases||X||X||X||X|
|Drill down from summary to detail reports||X||X||X||X|
|Supports all Sage Pro versions||X||X||X||X|
|Create/edit row and column ("quick") reports||X||X||X|
|Create/edit cross-tabulation reports||X||X||X|
|Create/edit batch reports||X||X||X|
|Create drilldown reports||X||X||X|
|Add charts to quick and cross-tab reports||X||X|
|Edit report layout ("Advanced Report Designer")||X||X|
|Report on multiple databases in same report||X|
|Number of free support tickets per year||1||2||4||10|
All prices are in U.S. dollars.
"Basic" viewer licenses are available by subscription only and require software maintenance be kept current
Products can be upgraded
Scheduled reports are not available in Citrix environments