Stonefield Query Reporting for Sage BusinessVision

Stonefield Query for Sage BusinessVision is a user-friendly report writing, query, and data mining tool designed specifically for Sage BusinessVision. 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. Stonefield Query for Sage BusinessVision can handle virtually all of your reporting needs.

To try Stonefield Query with your own Sage BusinessVision data, download a 30-day trial today!

The latest version of Stonefield Query for Sage BusinessVision is 3.2 (released May 9th 2008).

Sage BusinessVision Specific Features

Stonefield Query works with Sage BusinessVision versions 7.0 to 7.2.
Automatically converts dates, which BusinessVision stores as character values (for example, "20080304" for 03/04/2008), into true date values, which works better for display purposes and for date expressions.
Automatically converts time values, which BusinessVision stores as numeric values (for example, "113527" for 11:35:27), into nicely formatted time values.
Includes several pre-built calculations, such as Extended Price and Margin in SO Details.
Displays certain fields in the logical table rather than the actual table BusinessVision stores them in. For example, customer addresses are stored in an address table by the address type (bill-to, ship-to, etc.), making them difficult to report on. Stonefield Query shows those address fields as if they exist in the customers table, making them as easy to report on as any other customer field.
Purchases and sales are stored in separate current and history tables (for example, SO Headers for current sales orders and SO Headers History for historical sales orders). Creating a report that shows all purchases or orders is difficult in other reporting tools but Stonefield Query makes it easy: simply select from the "current + history" table (for example, SO Headers (Current + History), which combines current and historical sales into one table).
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.
Multi-Database Support: A single report can be run against each of your BusinessVision databases without making changes to the report. Furthermore, you also have the option to run a single report again multiple databases at the same time.
All table and field names have been captioned with user friendly titles.
All table relationships have been defined.

Other Stonefield Query Features

Choose from four different report types: Quick Reports (row and column layout), Cross-Tabulation Reports (like pivot tables, for analysis), Charts/Graphs (pie, bar, etc.) and Labels (mailing, barcode, etc).
Exclusion filters: this allows you to query on the absence of data, such as "give me a list of customers I didn't contact last year" or "give me a list of everyone who did not buy product X". Behind the scenes, Stonefield Query generates a NOT IN subquery, but from the end-user's perspective, it's just as easy as creating a normal filter.
Live Links: This allows you to create reports that drill down to other reports (for example, clicking on a customer name to show the sales for that customer) or automatically bring up someone's email address in your email program or Web site in your browser.
Output Options: Stonefield Query supports output to comma-delimited (CSV), Image Formats (.bmp, .gif, .jpeg, .png, .tiff), Microsoft Excel® (XLS), Microsoft Word® (DOC), Open Office (Calc & Writer), PDF, Rich Text Format (RTF), Table Format (DBF), Text (.txt), Web Page (HTML), XML, and XPS (.xps).
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.
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.
Allows user to control font, color, alignment, heading, and column width for each field with a mouse click.
Allows user to group and sort on any field with a mouse click.
Automatically adjust's a fields column width to match the widest amount of data in the column. No time lost adjusting and aligning fields.
Unlimited Reports: Create an unlimited number of reports.
Favorites: Save frequently used reports into your user-specific Favorites folder for quick access.
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.