Tuesday, March 21, 2017

Stonefield Query Enterprise Web Version 3.5 Released

Stonefield Software is pleased to announce the release of version 3.5 of Stonefield Query Enterprise Web. There are dozens of new features in this release, with several major ones listed below. See the online help for both Stonefield Query and Stonefield Query Studio for a complete list of new features.

Stonefield Query
  • A new report type, Batch Report, is now available. A batch report allows you to combine multiple reports in to a single output file in CSV, TXT, PDF, or XLSX formats.

  • Another new report type, SQL Passthrough, is also available for advanced users. A SQL Passthrough report allows you to build a report by entering a SQL Statement, then executing that SQL Statement against your database. The resulting report will have a report field that corresponds to each column in the data set retrieved from the database.

Stonefield Query Studio
  • Meta data discovery now works with any database with a .NET provider and can handle tables with more than 255 fields. After discovery is complete, a dialog may appear if there were issues that need to be addressed.

Wednesday, March 15, 2017

Stonefield Query for Act! Version 6.0.6250

We are pleased to announce the release of version 6.0.6250 of Stonefield Query for Act!. The changes in this release are:
  • Stonefield Query is now compatible with Act! v19.1 (2017.1).
  • Stonefield Query for Act! now includes a Convert Report to New Provider function, available on the Tools menu. This function will attempt to convert a report written with the older provider into one using the new provider.

Monday, January 23, 2017

Stonefield Query for Act! Version 6.0.6201

We are pleased to announce the release of version 6.0.6201 of Stonefield Query for Act!. The major purpose of this release is to add compatibility for the new Act! v19. The changes in this release are:
  • Stonefield Query is now compatible with Act! v19 (2017).
  • New fields "Field Changed Field", "Field Changed From Value", and "Field Changed To Value" were added to the Company History, Contact History, Group History, and Opportunity History tables in the Act! 2010+ data provider. For "Field Changed" history records, these new fields parse out their information from the details text. For other history records, these new fields simply show a blank value.
  • The SwiftPage sample reports were updated to use the newer Act! 2010+ data provider.

Thursday, November 17, 2016

Stonefield Query for GoldMine Version 6.0

We are pleased to announce the release of version 6.0 of Stonefield Query for Act!. There are lots of new features in this release; the major ones are:
  • You can now add subreports to quick reports.
  • A new type of formatting is available for date fields: Fiscal Year. For example, if the Year Starts In setting in the Options dialog is set to November, a date of 12/06/2016 displays 2017 (since it's in the 2017 fiscal year) when the date is formatted as Fiscal Year.
  • You can now include reports that have ask-at-runtime filter conditions in a batch report. When you run the batch report, it now prompts you for all unique conditions for all reports at the start of the run and uses those values for the conditions in all reports. That way, you aren't asked more than once for the same value.
See What’s New in This Version for a complete list.

Tuesday, November 8, 2016

Stonefield Query for Act! Version 6.0

We are pleased to announce the release of version 6.0 of Stonefield Query for Act!. There are lots of new features in this release; the major ones are:
  • You can now add subreports to quick reports.
  • A new type of formatting is available for date fields: Fiscal Year. For example, if the Year Starts In setting in the Options dialog is set to November, a date of 12/06/2016 displays 2017 (since it's in the 2017 fiscal year) when the date is formatted as Fiscal Year.
  • You can now include reports that have ask-at-runtime filter conditions in a batch report. When you run the batch report, it now prompts you for all unique conditions for all reports at the start of the run and uses those values for the conditions in all reports. That way, you aren't asked more than once for the same value.
See What’s New in This Version for a complete list.

Friday, October 28, 2016

Stonefield Query for HEAT Version 6.0

We are pleased to announce the release of version 6.0 of Stonefield Query for HEAT. There are lots of new features in this release; the major ones are:

  • You can now add subreports to quick reports.

  • A new type of formatting is available for date fields: Fiscal Year. For example, if the Year Starts In setting in the Options dialog is set to November, a date of 12/06/2016 displays 2017 (since it's in the 2017 fiscal year) when the date is formatted as Fiscal Year.

  • You can now include reports that have ask-at-runtime filter conditions in a batch report. When you run the batch report, it now prompts you for all unique conditions for all reports at the start of the run and uses those values for the conditions in all reports. That way, you aren't asked more than once for the same value.

See What’s New in This Version for a complete list.

Thursday, October 27, 2016

Stonefield Query for ALERE Version 6.0

We are pleased to announce the release of version 6.0 of Stonefield Query for ALERE. There are lots of new features in this release; the major ones are:

  • You can now add subreports to quick reports.

  • A new type of formatting is available for date fields: Fiscal Year. For example, if the Year Starts In setting in the Options dialog is set to November, a date of 12/06/2016 displays 2017 (since it's in the 2017 fiscal year) when the date is formatted as Fiscal Year.

  • You can now include reports that have ask-at-runtime filter conditions in a batch report. When you run the batch report, it now prompts you for all unique conditions for all reports at the start of the run and uses those values for the conditions in all reports. That way, you aren't asked more than once for the same value.

See What’s New in This Version for a complete list.

Thursday, October 20, 2016

Stonefield Query for AccountMate Version 6.0

We are pleased to announce the release of version 6.0 of Stonefield Query for AccountMate. There are lots of new features in this release; the major ones are:

  • You can now add subreports to quick reports.

  • A new type of formatting is available for date fields: Fiscal Year. For example, if the Year Starts In setting in the Options dialog is set to November, a date of 12/06/2016 displays 2017 (since it's in the 2017 fiscal year) when the date is formatted as Fiscal Year.

  • You can now include reports that have ask-at-runtime filter conditions in a batch report. When you run the batch report, it now prompts you for all unique conditions for all reports at the start of the run and uses those values for the conditions in all reports. That way, you aren't asked more than once for the same value.

See What’s New in This Version for a complete list.

Thursday, October 13, 2016

Stonefield Query for Sage Pro Version 6.0

We are pleased to announce the release of version 6.0 of Stonefield Query for Sage Pro. There are lots of new features in this release; the major ones are:

  • You can now add subreports to quick reports.

  • A new type of formatting is available for date fields: Fiscal Year. For example, if the Year Starts In setting in the Options dialog is set to November, a date of 12/06/2016 displays 2017 (since it's in the 2017 fiscal year) when the date is formatted as Fiscal Year.

  • You can now include reports that have ask-at-runtime filter conditions in a batch report. When you run the batch report, it now prompts you for all unique conditions for all reports at the start of the run and uses those values for the conditions in all reports. That way, you aren't asked more than once for the same value.

See What’s New in This Version for a complete list.

Stonefield Query for Sage 300 Version 6.0

We are pleased to announce the release of version 6.0 of Stonefield Query for Sage 300. There are lots of new features in this release; the major ones are:

  • Sage 300 2017 is now supported.

  • You can now add subreports to quick reports.

  • A new type of formatting is available for date fields: Fiscal Year. For example, if the Year Starts In setting in the Options dialog is set to November, a date of 12/06/2016 displays 2017 (since it's in the 2017 fiscal year) when the date is formatted as Fiscal Year.

  • You can now include reports that have ask-at-runtime filter conditions in a batch report. When you run the batch report, it now prompts you for all unique conditions for all reports at the start of the run and uses those values for the conditions in all reports. That way, you aren't asked more than once for the same value.

See What’s New in This Version for a complete list.