Stonefield Query for
|
A user-friendly database report writing, query, and data mining tool designed specifically for Sage 300/Accpac 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 300/Accpac 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 300/Accpac 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 300/Accpac ERP® Specific Features
- Stonefield Query for Sage 300 ERP, formerly known as Stonefield Query for Sage Accpac ERP has been renamed due to Sage renaming Sage Accpac ERP to Sage 300 ERP. Please note that regardless of the name change, Stonefield Query still works with Sage 300 ERP and Sage Accpac ERP versions 6.0 and earlier.
-
Support for Database View versus Application View in Report Wizards. The difference between the two is that Database View displays a database-centric view of the data in your application--that is, organized the way the tables and fields are in the database--while Application View shows fields the way Sage Accpac does in its various dialogs
-
Displays optional fields in the table they are associated with rather than in the table Accpac internally stores them in, making it much easier to query on optional fields
-
Displays the expected value for many code fields rather than the actual values as Accpac stores them
-
Automatically converts dates, which Accpac stores as numeric values (for example, "20080304" for 03/04/2008), into true date values, which works better for display purposes and for date expressions
-
Only allows querying on modules that are activated and that the user has access to
-
Allows you to consolidate records from multiple companies into one report
-
Only displays those tables and fields actually available in the version of Accpac you use
-
Displays the description for General Ledger account and Inventory Control segments
-
Supports reporting on the Uni Sales Analysis (UniSA) module |
|
This video is a product overview of Stonefield Query for Sage 300/Accpac ERP.
It shows you the basics of creating a Quick Report, Labels, Charts, and Cross Tab Reports.
It also shows you how to use features such as the Report Scheduler, and Advanced Report Designer. |
|
|
