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 Accpac ERP and earlier.
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.
Automatically deliver reports via e-mail, file, or printer.
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.
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
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