Stonefield Query for Sage 300
Stonefield Query for Sage 300 provides a step-by-step method to create professional business reports from information
stored in Sage 300. Anyone can create detailed reports, high level overview, drill-down, charts/graphs, pivot tables,
and more in minutes rather than hours.
Stonefield Query for Sage 300 works with Sage 300 2018 and earlier versions.
Stonefield Knows Sage 300
Stonefield Query knows the Sage 300 database structure. It has the following special features:
- Can report on Unisales Sales Analysis and Orion Point of Sale (POS) data as well as Sage 300 tables.
- Displays optional fields in the table they are associated with rather than in the table Sage 300 internally
stores them in, making it much easier to query on optional fields. For example, suppose you've created an
optional field for Accounts Receivable customers that stores the date they signed a contract. Although it
appears in the customer screen, Sage 300 actually stores this field in a different table (named ARCUSO)
than it stores customers (the ARCUS table). Using another reporting tool to access this optional field
means knowing how to set up a join between the ARCUS and ARCUSO tables, filtering ARCUSO so it only shows
the contract date optional field, and converting the value for the field, which is actually stored as a
character string, to a date value.
Whew! Good thing Stonefield Query makes it easy: the contract date field appears in the same list of fields
as the other customer fields do, and Stonefield Query takes care of all of the work behind the scenes.
- Contains user-definable calculations in payroll tables that make creating payroll summary report much easier.
- Displays the expected value for many code fields rather than the actual values as Sage 300 stores them.
For example, the Document Type field in the Accounts Payable Invoices table is actually stored as a numeric
value (1, 2, 3, or 4) rather than the value you expect. Stonefield Query displays the expected values
(Invoice, Debit Note, Credit Note, or Interest) so you don't have to figure out what those numeric values mean.
- Automatically converts dates, which Sage 300 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.
- Displays the company name rather than the database name in the Reports Explorer status bar, the Open Database dialog,
and optionally the header of reports.
- Allows you to consolidate records from multiple companies into one report. For example, you could show all
outstanding invoices from all companies on the same report, including showing which company each one came from.
- Only displays those tables and fields actually available in the version of Sage 300 you use.
- Displays the description for General Ledger account and Inventory Control segments.
Schedule and Automatically Deliver Reports
Automatically deliver reports via e-mail, file, or printer. Schedule them to run anytime you need them to.
Comes with 82+ sample reports that can be run or used as a starting point for report design.
Limit users reporting to only modules they have access to and have been activated in Sage 300.
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 300, such as
all companies that bought something last year but not this year.
Microsoft Excel PivotTable Reporting
Extended data analysis in Excel PivotTables.
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.
Stonefield Query for Sage 300 is $2,000 plus 25% software maintenance for a total of $2,500.
That includes one Report Designer license and five Report Viewer Subscription licenses
(a subscription license cannot be used if the software maintenance for the Report Designer license lapses but the
Report Designer license can still be used).
- Any version of Microsoft Windows released after 2001: Windows XP, Windows Vista, Windows 7, Windows 8,
Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows Terminal Server,
Windows Small Business Server, Windows Essentials Business Server (also works in Citrix environments)
- 512 MB minimum memory (more is better)
- 50 MB free hard disk space
View our online documentation to learn more.