Stonefield Query BI Reporting for Sage Accpac ERP

Stonefield Query for Sage Accpac ERP® is a user-friendly database report writing, query, and data mining tool designed specifically for Sage 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 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 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 Accpac ERP Specific Features

Stonefield Query works with Sage Accpac ERP version 5.6 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

Stonefield Query Advantage

When you use the award-winning Stonefield Query BI reporting tool for Sage Accpac ERP, you provide your staff with an easy-to-use solution from an industry leader. You can:

Increase productivity throughout your organization.
Reduce your support costs
Uncover opportunities in your Sage Accpac ERP system

Ease of Use

Unlike generic report writers, Stonefield Query has been customized specifically for Sage Accpac ERP. You don't have to tell Stonefield Query how to get the data; you simply tell it what you want and it will figure out how to get it. Everyone in the organization from the President to the receptionist can use Stonefield Query for Sage Accpac ERP. Stonefield Query saves technical staff time and alleviates the burden of creating every query and report an end-user could ever think of.

Productivity

With generic report writers you are responsible for laying out fields, adjusting sizes and headings manually. Stonefield Query automatically places fields and headings on the report and sizes them appropriately. You can create a report in Stonefield Query in just seconds with only a few mouse clicks. Grouping, sorting, totaling fields, and filtering are as simple as selecting the desired option from a list.

Performance

Stonefield Query uses SQL SELECT statements to retrieve records from the database, so only those records that match the filter are accessed. This can have an enormous impact on the performance of the query. For example, one Stonefield Query user told us that a report they created in Crystal Reports takes over 25 minutes to run, but the same report in Stonefield Query takes just 15 seconds. That's 100 times faster.

Security

Stonefield Query supports role-based security at the field, table and report level. This means you can control access to any information stored in your Sage Accpac ERP system. Restrict access to custom fields and other sensitive information in a few mouse clicks.

Value

Stonefield Query fulfills a valuable need every organization has: the access to information. More importantly, it allows the people who need the information the most, the ability to get it themselves. In most cases, the cost of a single Crystal report is more expensive than Stonefield Query. Stonefield Query delivers a fast return on investment.