Thursday, November 27, 2014

Stonefield Query for HEAT Version 5.0

Stonefield Software Inc. is pleased to announce the release of version 5.0 of Stonefield Query for HEAT. This release has numerous new features.

  • Stonefield Query has a new report type: gauge report. This allows you to create a gauge showing the current value of something compared to a target or goal value.
  • You can now create a "grouping" formula. A grouping formula is a powerful tool that allows you to create filtered summary values. For example, suppose you want columns in a report that show the sales for last year and the current year-to-date for each customer. Those aren't single values retrieved from the database. Instead, for the first column, use a grouping formula that sums up the sales records for each customer for last year, and use a similar one but for the current year for the second column.
  • The Inventory Control Location Item Details table now also appears in the Purchase Orders module.
  • The Inventory Items table now has a Total Quantity on Hand field that contains the total quantity on hand from all locations.
  • The Inventory Shipments related tables no longer appear in the Order Entry or Purchase Orders modules to avoid confusion with the shipments tables already in those modules.
  • You can now password protect the file created when a report is output to file or email.
  • You can now print to Dymo LabelWriter labels.
  • The Schedule Report function is now available only to advanced users.
  • A new output type is now available: Microsoft Excel - Full Format (*.xlsx), which creates Excel 2007 or later files. The former Microsoft Excel (*.xls) output type was renamed to Microsoft Excel 97-2003 - Full Format (*.xls) so you can tell them apart. The new type does not require Microsoft Excel to be installed to create the file.
  • The "red" error dialog that appears when something goes wrong now has a Help button that brings up the help with information about that dialog.
  • The Locations page in the Options dialog is now available only to administrative users.
  • The Subscription Expired dialog, which appears when you have subscription licenses and your subscription has expired, now has a "Don't remind me again" option; turn that option on to prevent the dialog from appearing again. Also, those licenses are now deactivated rather than being deleted, so if you renew your subscription, they are reactivated.

Stonefield Query for ALERE Version 5.0

Stonefield Software Inc. is pleased to announce the release of version 5.0 of Stonefield Query for ALERE. This release has numerous new features.

  • Stonefield Query has a new report type: gauge report. This allows you to create a gauge showing the current value of something compared to a target or goal value.
  • You can now create a "grouping" formula. A grouping formula is a powerful tool that allows you to create filtered summary values. For example, suppose you want columns in a report that show the sales for last year and the current year-to-date for each customer. Those aren't single values retrieved from the database. Instead, for the first column, use a grouping formula that sums up the sales records for each customer for last year, and use a similar one but for the current year for the second column.
  • The Inventory Control Location Item Details table now also appears in the Purchase Orders module.
  • The Inventory Items table now has a Total Quantity on Hand field that contains the total quantity on hand from all locations.
  • The Inventory Shipments related tables no longer appear in the Order Entry or Purchase Orders modules to avoid confusion with the shipments tables already in those modules.
  • You can now password protect the file created when a report is output to file or email.
  • You can now print to Dymo LabelWriter labels.
  • The Schedule Report function is now available only to advanced users.
  • A new output type is now available: Microsoft Excel - Full Format (*.xlsx), which creates Excel 2007 or later files. The former Microsoft Excel (*.xls) output type was renamed to Microsoft Excel 97-2003 - Full Format (*.xls) so you can tell them apart. The new type does not require Microsoft Excel to be installed to create the file.
  • The "red" error dialog that appears when something goes wrong now has a Help button that brings up the help with information about that dialog.
  • The Locations page in the Options dialog is now available only to administrative users.
  • The Subscription Expired dialog, which appears when you have subscription licenses and your subscription has expired, now has a "Don't remind me again" option; turn that option on to prevent the dialog from appearing again. Also, those licenses are now deactivated rather than being deleted, so if you renew your subscription, they are reactivated.

Stonefield Query for AccountMate Version 5.0

Stonefield Software Inc. is pleased to announce the release of version 5.0 of Stonefield Query for AccountMate. This release has numerous new features.
  • AccountMate Version 9.2 is now supported.
  • Stonefield Query has a new report type: gauge report. This allows you to create a gauge showing the current value of something compared to a target or goal value.
  • You can now create a "grouping" formula. A grouping formula is a powerful tool that allows you to create filtered summary values. For example, suppose you want columns in a report that show the sales for last year and the current year-to-date for each customer. Those aren't single values retrieved from the database. Instead, for the first column, use a grouping formula that sums up the sales records for each customer for last year, and use a similar one but for the current year for the second column.
  • The Inventory Control Location Item Details table now also appears in the Purchase Orders module.
  • The Inventory Items table now has a Total Quantity on Hand field that contains the total quantity on hand from all locations.
  • The Inventory Shipments related tables no longer appear in the Order Entry or Purchase Orders modules to avoid confusion with the shipments tables already in those modules.
  • You can now password protect the file created when a report is output to file or email.
  • You can now print to Dymo LabelWriter labels.
  • The Schedule Report function is now available only to advanced users.
  • A new output type is now available: Microsoft Excel - Full Format (*.xlsx), which creates Excel 2007 or later files. The former Microsoft Excel (*.xls) output type was renamed to Microsoft Excel 97-2003 - Full Format (*.xls) so you can tell them apart. The new type does not require Microsoft Excel to be installed to create the file.
  • The "red" error dialog that appears when something goes wrong now has a Help button that brings up the help with information about that dialog.
  • The Locations page in the Options dialog is now available only to administrative users.
  • The Subscription Expired dialog, which appears when you have subscription licenses and your subscription has expired, now has a "Don't remind me again" option; turn that option on to prevent the dialog from appearing again. Also, those licenses are now deactivated rather than being deleted, so if you renew your subscription, they are reactivated.

Monday, November 17, 2014

Stonefield Query for Sage Pro ERP Version 5.0

Stonefield Software Inc. is pleased to announce the release of version 5.0 of Stonefield Query for Sage Pro ERP. This release has numerous new features.

  • Stonefield Query has a new report type: gauge report. This allows you to create a gauge showing the current value of something compared to a target or goal value.
  • You can now create a "grouping" formula. A grouping formula is a powerful tool that allows you to create filtered summary values. For example, suppose you want columns in a report that show the sales for last year and the current year-to-date for each customer. Those aren't single values retrieved from the database. Instead, for the first column, use a grouping formula that sums up the sales records for each customer for last year, and use a similar one but for the current year for the second column.
  • You can now password protect the file created when a report is output to file or email.
  • You can now print to Dymo LabelWriter labels.
  • The Schedule Report function is now available only to advanced users.
  • A new output type is now available: Microsoft Excel - Full Format (*.xlsx), which creates Excel 2007 or later files. The former Microsoft Excel (*.xls) output type was renamed to Microsoft Excel 97-2003 - Full Format (*.xls) so you can tell them apart. The new type does not require Microsoft Excel to be installed to create the file.
  • The "red" error dialog that appears when something goes wrong now has a Help button that brings up the help with information about that dialog.
  • The Locations page in the Options dialog is now available only to administrative users.
  • The Subscription Expired dialog, which appears when you have subscription licenses and your subscription has expired, now has a "Don't remind me again" option; turn that option on to prevent the dialog from appearing again. Also, those licenses are now deactivated rather than being deleted, so if you renew your subscription, they are reactivated.

Stonefield Query for Sage 300 ERP Version 5.0

Stonefield Software Inc. is pleased to announce the release of version 5.0 of Stonefield Query for Sage 300 ERP. This release has numerous new features.

  • Stonefield Query has a new report type: gauge report. This allows you to create a gauge showing the current value of something compared to a target or goal value.
  • You can now create a "grouping" formula. A grouping formula is a powerful tool that allows you to create filtered summary values. For example, suppose you want columns in a report that show the sales for last year and the current year-to-date for each customer. Those aren't single values retrieved from the database. Instead, for the first column, use a grouping formula that sums up the sales records for each customer for last year, and use a similar one but for the current year for the second column.
  • The Inventory Control Location Item Details table now also appears in the Purchase Orders module.
  • The Inventory Items table now has a Total Quantity on Hand field that contains the total quantity on hand from all locations.
  • The Inventory Shipments related tables no longer appear in the Order Entry or Purchase Orders modules to avoid confusion with the shipments tables already in those modules.
  • You can now password protect the file created when a report is output to file or email.
  • You can now print to Dymo LabelWriter labels.
  • The Schedule Report function is now available only to advanced users.
  • A new output type is now available: Microsoft Excel - Full Format (*.xlsx), which creates Excel 2007 or later files. The former Microsoft Excel (*.xls) output type was renamed to Microsoft Excel 97-2003 - Full Format (*.xls) so you can tell them apart. The new type does not require Microsoft Excel to be installed to create the file.
  • The "red" error dialog that appears when something goes wrong now has a Help button that brings up the help with information about that dialog.
  • The Locations page in the Options dialog is now available only to administrative users.
  • The Subscription Expired dialog, which appears when you have subscription licenses and your subscription has expired, now has a "Don't remind me again" option; turn that option on to prevent the dialog from appearing again. Also, those licenses are now deactivated rather than being deleted, so if you renew your subscription, they are reactivated.

Thursday, November 13, 2014

Stonefield Query for Act! Version 5.0

Stonefield Software Inc. is pleased to announce the release of version 5.0 of Stonefield Query for Act!. This release has numerous new features.

  • Stonefield Query is compatible with the new Act! v17 (2015) and Act! 2014 Service Pack 1 (16.1).
  • Stonefield Query has a new report type: gauge report. This allows you to create a gauge showing the current value of something compared to a target or goal value.
  • You can now create a "grouping" formula. A grouping formula is a powerful tool that allows you to create filtered summary values. For example, suppose you want columns in a report that show the sales for last year and the current year-to-date for each customer. Those aren't single values retrieved from the database. Instead, for the first column, use a grouping formula that sums up the sales records for each customer for last year, and use a similar one but for the current year for the second column.
  • You can now password protect the file created when a report is output to file or email.
  • You can now print to Dymo LabelWriter labels.
  • The Schedule Report function is now available only to advanced users.
  • A new output type is now available: Microsoft Excel - Full Format (*.xlsx), which creates Excel 2007 or later files. The former Microsoft Excel (*.xls) output type was renamed to Microsoft Excel 97-2003 - Full Format (*.xls) so you can tell them apart. The new type does not require Microsoft Excel to be installed to create the file.
  • The "red" error dialog that appears when something goes wrong now has a Help button that brings up the help with information about that dialog.
  • The Locations page in the Options dialog is now available only to administrative users.
  • The Subscription Expired dialog, which appears when you have subscription licenses and your subscription has expired, now has a "Don't remind me again" option; turn that option on to prevent the dialog from appearing again. Also, those licenses are now deactivated rather than being deleted, so if you renew your subscription, they are reactivated.

Stonefield Query for GoldMine Version 5.0

Stonefield Software Inc. is pleased to announce the release of version 5.0 of Stonefield Query for GoldMine. This release has numerous new features.

  • Stonefield Query has a new report type: gauge report. This allows you to create a gauge showing the current value of something compared to a target or goal value.
  • You can now create a "grouping" formula. A grouping formula is a powerful tool that allows you to create filtered summary values. For example, suppose you want columns in a report that show the sales for last year and the current year-to-date for each customer. Those aren't single values retrieved from the database. Instead, for the first column, use a grouping formula that sums up the sales records for each customer for last year, and use a similar one but for the current year for the second column.
  • You can now password protect the file created when a report is output to file or email.
  • You can now print to Dymo LabelWriter labels.
  • The Schedule Report function is now available only to advanced users.
  • A new output type is now available: Microsoft Excel - Full Format (*.xlsx), which creates Excel 2007 or later files. The former Microsoft Excel (*.xls) output type was renamed to Microsoft Excel 97-2003 - Full Format (*.xls) so you can tell them apart. The new type does not require Microsoft Excel to be installed to create the file.
  • The "red" error dialog that appears when something goes wrong now has a Help button that brings up the help with information about that dialog.
  • The Locations page in the Options dialog is now available only to administrative users.
  • The Subscription Expired dialog, which appears when you have subscription licenses and your subscription has expired, now has a "Don't remind me again" option; turn that option on to prevent the dialog from appearing again. Also, those licenses are now deactivated rather than being deleted, so if you renew your subscription, they are reactivated.

Thursday, October 30, 2014

Stonefield Query SDK Version 5.0

Stonefield Software Inc. is pleased to announce the release of version 5.0 of the Stonefield Query SDK. This release has numerous new features.

Report Designer

  • Stonefield Query has a new report type: gauge report. This allows you to create a gauge showing the current value of something compared to a target or goal value.
  • You can now create a "grouping" formula. A grouping formula is a powerful tool that allows you to create filtered summary values. For example, suppose you want columns in a report that show the sales for last year and the current year-to-date for each customer. Those aren't single values retrieved from the database. Instead, for the first column, use a grouping formula that sums up the sales records for each customer for last year, and use a similar one but for the current year for the second column.
  • You can now password protect the file created when a report is output to file or email.
  • You can now print to Dymo LabelWriter labels.
  • The Schedule Report function is now available only to advanced users.
  • A new output type is now available: Microsoft Excel - Full Format (*.xlsx), which creates Excel 2007 or later files. The former Microsoft Excel (*.xls) output type was renamed to Microsoft Excel 97-2003 - Full Format (*.xls) so you can tell them apart. The new type does not require Microsoft Excel to be installed to create the file.
  • The "red" error dialog that appears when something goes wrong now has a Help button that brings up the help with information about that dialog.
  • The Locations page in the Options dialog is now available only to administrative users.
  • The Subscription Expired dialog, which appears when you have subscription licenses and your subscription has expired, now has a "Don't remind me again" option; turn that option on to prevent the dialog from appearing again. Also, those licenses are now deactivated rather than being deleted, so if you renew your subscription, they are reactivated.

SDK

There’s only one major new feature in Stonefield Query Studio: the new Find Possible Relations function makes it easier to create relationships between tables: it examines all tables, looking for field names in common as possible relationships.

Thursday, May 29, 2014

Stonefield Query for Goldmine Version 4.3.5242

There are numerous new features in this release.
  • Stonefield Query is compatible with Goldmine 2014.
  • A new chart type is now available: Donut, which is similar to Pie but with a hole in the middle.
  • The default settings for a new chart give it a more modern appearance, such as flat rather than 3-D and better colors.
  • You can now define a chart with a second values field; this field is charted as a second series against the right axis.
  • The Output each group as a separate file and Output each group as a separate email options now support charts on quick reports. In that case, each file has its own chart related to the group the file is for.
  • The Filter Condition dialog now uses a more modern date picker control.
  • The Add timestamp to file name setting is now available even when Erase file after email sent setting is turned on in the Output page of the Reports Explorer.
  • A new output type is now available: Microsoft Word (*.docx), which creates Word 2007 or later files. The former Microsoft Word (*.doc) output type was renamed to Microsoft Word 97-2003 (*.doc) so you can tell them apart. The docx format is preferred as it's more accurate.
  • The Check for Updates function in the Help menu is now only available if you are logged into Stonefield Query as an administrator.
  • You can now change settings in the Format page of the Field Properties dialog for numeric fields in columns of cross-tab reports.
  • The prompts in the Email page of the Options dialog have been changed to reflect the fact that SMTP is the preferred setting since MAPI can be unreliable, especially when emailing a scheduled report.

Wednesday, May 28, 2014

Stonefield Query for Act! Version 4.3.5242

There are numerous new features in this release.
  • Stonefield Query is compatible with the new Act! 2014 Service Pack 1 (16.1).
  • A new chart type is now available: Donut, which is similar to Pie but with a hole in the middle.
  • The default settings for a new chart give it a more modern appearance, such as flat rather than 3-D and better colors.
  • You can now define a chart with a second values field; this field is charted as a second series against the right axis.
  • The Output each group as a separate file and Output each group as a separate email options now support charts on quick reports. In that case, each file has its own chart related to the group the file is for.
  • The Filter Condition dialog now uses a more modern date picker control.
  • The Add timestamp to file name setting is now available even when Erase file after email sent setting is turned on in the Output page of the Reports Explorer.
  • A new output type is now available: Microsoft Word (*.docx), which creates Word 2007 or later files. The former Microsoft Word (*.doc) output type was renamed to Microsoft Word 97-2003 (*.doc) so you can tell them apart. The docx format is preferred as it's more accurate.
  • New "Attendees (All)", "Attendees (Contacts)", and "Attendees (Users)" fields have been added to the Company Activity, Contact Activity, Group Activity, and Opportunity Activity tables in the Act! 2010+ data provider.
  • New fields "Activity User ID", "Activity User Name", and "Is Organizer Record" have been added to the Company Activity, Contact Activity, Group Activity, and Opportunity Activity tables in the Act! 2010+ data provider.
  • In the Act! 2010+ data provider activity tables, "Organizer" fields now appear as "Scheduled For" to match the Act! UI.
  • The Contact Related Contacts table now shows data for both contacts in the relationship, rather than only for the parent contact.
  • The Check for Updates function in the Help menu is now only available if you are logged into Stonefield Query as an administrator.
  • You can now change settings in the Format page of the Field Properties dialog for numeric fields in columns of cross-tab reports.
  • The prompts in the Email page of the Options dialog have been changed to reflect the fact that SMTP is the preferred setting since MAPI can be unreliable, especially when emailing a scheduled report.