Stonefield Query for Sage 300

Stonefield Query for Sage 300 provides a step-by-step method to create professional reports from Sage 300. Anyone can create detailed reports, high level overview, drill-down, charts/graphs, pivot tables, and more in minutes not hours.

Stonefield Query for Sage 300 has been customized for Sage 300 so you can start creating reports and works with the latest version of Sage 300 and Sage 300 versions 6.0 and earlier.

To view an video overview of the product click here

Generate Business Reports When You Need Them

Use Stonefield Query for Sage 300 to create reports efficiently. The reporting process is adding the information for the report, narrowing down the information through filters/exclusions, sorting, and defining who has access to the report.

Application and Database View

Application View shows information the way Sage 300 does in its various dialogs and screens.

Database View displays the data organized by modules, tables, and fields as listed in the database.

Schedule Reports

Automatically deliver reports via e-mail, file, or printer.

Sample Reports

Comes with 82+ reports that can be run or used as a starting point for report design.

Numeric Date Fields

Automatically converts dates from numeric values as stored in the Sage database (for example, “20080304? for 03/04/2008) into date values.

Module Reporting

Limit users reporting to only modules they have access to and have been activated in Sage 300.

Filters and Exclusions

Filter parameters allow you to narrow down your results without programming and more in depth than Sage 300’s advanced queries. A filter example would be product sales by customer in the last year, month, or week. Exclusions allow you to report on things that are not recorded in Sage 300. An example would be all companies that were not invoiced last Year.

Multiple Database/Company Support

Consolidate information from multiple companies in one report

Quick Reports

Create detailed reports and know what is happening with prospects and clients. Analyze opportunities and learn why they closed or were lost. Scan through the call list and read the details quickly to determine how to prioritize calls and more.

Excel Pivot Table Reporting

Extended data analysis in Excel Pivot Tables

Charts, Graphs and Dashboards

Create bar, graph, line, area, and pie charts as well as series charts and graphs. 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.

Values versus Codes

Displays the expected value for many code fields rather than the actual values as Sage 300 (Accpac) stores them