Home >> GoldMine
Add-ons >> Stonefield Query
Stonefield Query for AccountMate ® is a user-friendly data mining, query, and report writing tool designed specifically for AccountMate. You no longer need to call an IT specialist every time you need a report. Now your accounting clerks, administrative staff, and management can create their own reports in minutes after only an hour of free training. Stonefield Query for AccountMate can handle virtually all of your reporting needs.
The latest version of Stonefield Query for AccountMate is 3.05, released January 8, 2007.
- Supports LAN, SQL, and MSDE versions.
- 16 pre-defined reports and labels to get you started.
- All table and field names have been captioned with user friendly titles. There are more than 10,000 table and field captions defined for you.
- All table relationships have been defined. Currently there are more than 600 relationships defined for you.
- All tables have been logically organized into modules.
- For example, all tables related to Accounts Receivable are in the Accounts Receivable module.
- Existing modules include: Accounts Payable, Accounts Receivable, Bank Reconciliation, Contact Manager, General Ledger, Inventory Control, Manufacturer’s Inventory, Payroll, Purchase Order, Return Merchandise Authorization, Return to Vendor Authorization, Sales Order, and Utility.
- Multi-Company Support: A single report can be run against each of your AccountMate companies without making changes to the report. Furthermore, you also have the option to run a single report again multiple companies at the same time.
- Current and history tables have been combined for simpler reporting. You no longer have to run two reports and combine the results.
- Calculated Fields: Use calculated fields like "Invoice Total" and "City/State/Zip" without the need to know or understand how to format the data. Build your own calculated fields with the Stonefield Query SDK.
- Supports your custom AccountMate Tables and Fields: Use the Stonefield Query SDK to add in your custom tables and fields.
- Report Types: Choose from three different report types: Quick Reports (row and column layout), Cross-Tabulation Reports (like pivot tables, for analysis), and Labels (mailing, barcode, etc).
- Report Templates: Choose from one of the supplied templates or use the Template Editor to build your own.
- Report Sample: See a snapshot of what the report looked like the last time you ran it.
- Report Scheduler: Automate reports that need to go out on a regular basis.
- Report Preview: See what the report will look like at each step of the report building process. There's no need to save and exit before viewing.
- Role-based Security: Control access to a single report, group of reports, and/or specific modules by assigning users to groups. This allows you to restrict access to sensitive data.
- Unlimited Reports: Create an unlimited number of reports.
- Favorites: Save frequently used reports into your user-specific Favorites folder for quick access.
- Output Types: Stonefield Query supports output to comma-delimited (CSV), Microsoft Excel® (XLS), Microsoft Word® (DOC), PDF, Rich Text Format (RTF), Table Format (DBF), Web Page (HTML), and XML.
- Email Reports: Use a SMTP or MAPI email client to quickly email reports through Stonefield Query.
- Label Wizard: Select any data in your system and choose from 87 different Avery label formats.
- Advanced Report Designer: Customize the report layout beyond the report wizard settings using the Advanced Report Designer for complete report control.
- Customize SQL Select: Stonefield Query automatically generates a SQL Select statement for the report once fields have been selected. Advanced users can customize the statement if desired.
- Detailed Help File: Read through our detailed online help or our 240+ page PDF reference manual. Topics include Tutorials, Using Stonefield Query, Menu Functions, How To, and Frequently Asked Questions.
|
![spacer](../../images/spacer.gif"){kind=small}
