tag:blogger.com,1999:blog-16059656047053202112024-03-13T22:27:05.383-06:00Stonefield Query - Business Intelligence & Database Reporting SoftwareTake the mystery out of Reporting! Stonefield Query is a user-friendly Business Intelligence and Database Reporting software tool. Perform data analysis and data mining. Create cross-tab reports, pivot tables, labels, charts, and graphs quickly and easily.Trevor Mansuyhttp://www.blogger.com/profile/04375507775212187835noreply@blogger.comBlogger311125tag:blogger.com,1999:blog-1605965604705320211.post-83063317282158170212023-12-08T12:15:00.001-06:002023-12-08T12:15:21.324-06:00Stonefield Query for Sage Pro ERP Version 8.3<p>Stonefield Software is pleased to announce the release of version 8.3 of Stonefield Query for Sage Pro ERP. There are several new features in this version.</p>
<ul>
<li><p>You can now specify additional files to attach to <a href="https://www.stonefieldsoftware.com/OnlineHelp/SagePro/_0380pfg2h.htm" >an email</a> in addition to the file for the report.</p>
</li>
<li><p><a href="https://www.stonefieldsoftware.com/OnlineHelp/SagePro/_11u0u5th3.htm" >Cross-tab reports</a> now support Highest and Lowest total types for date and datetime fields in the Data area.</p>
</li>
<li><p>You can now specify the horizontal orientation—left, right, or center, with center being the default—for <a href="https://www.stonefieldsoftware.com/OnlineHelp/SagePro/_23v0yafg4.htm" >a chart</a> included in a quick or cross-tab report.</p>
</li>
<li><p>If you add another data source using the <a href="https://www.stonefieldsoftware.com/OnlineHelp/SagePro/_5vo0uguqp.htm" >Other Data Sources dialog</a> and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.</p>
</li>
<li><p>You can now specify that a table added in the Other Data Sources dialog is non-reportable.</p>
</li>
<li><p>There are several <a href="https://www.stonefieldsoftware.com/OnlineHelp/SagePro/_67l0jbnao.htm" >DataGrid</a> enhancements:</p>
<ul>
<li>The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.</li>
<li>The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.</li>
<li>Logical (yes/no) fields now display as check boxes.</li>
</ul></li>
<li><p>You can now choose to not display a row field in a cross-tab report by setting its width to 0.</p>
</li>
<li><p>The recipient of an emailed report is now logged to the diagnostic file.</p>
</li>
<li><p>The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.</p>
</li>
</ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-55058056655967735352023-12-08T12:14:00.001-06:002023-12-08T12:14:04.540-06:00Stonefield Query for Sage 300 Version 8.3<p>Stonefield Software is pleased to announce the release of version 8.3 of Stonefield Query for Sage 300. There are several new features in this version.</p>
<ul>
<li><p>You can now specify additional files to attach to <a href="https://www.stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_0380pfg2h.htm" >an email</a> in addition to the file for the report.</p>
</li>
<li><p><a href="https://www.stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_11u0u5th3.htm" >Cross-tab reports</a> now support Highest and Lowest total types for date and datetime fields in the Data area.</p>
</li>
<li><p>You can now specify the horizontal orientation—left, right, or center, with center being the default—for <a href="https://www.stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_23v0yafg4.htm" >a chart</a> included in a quick or cross-tab report.</p>
</li>
<li><p>If you add another data source using the <a href="https://www.stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_5vo0uguqp.htm" >Other Data Sources dialog</a> and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.</p>
</li>
<li><p>You can now specify that a table added in the Other Data Sources dialog is non-reportable.</p>
</li>
<li><p>There are several <a href="https://www.stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_67l0jbnao.htm" >DataGrid</a> enhancements:</p>
<ul>
<li>The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.</li>
<li>The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.</li>
<li>Logical (yes/no) fields now display as check boxes.</li>
</ul></li>
<li><p>You can now choose to not display a row field in a cross-tab report by setting its width to 0.</p>
</li>
<li><p>The recipient of an emailed report is now logged to the diagnostic file.</p>
</li>
<li><p>The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.</p>
</li>
</ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-16611663100380572312023-12-08T12:12:00.003-06:002023-12-08T12:12:31.183-06:00Stonefield Query for GoldMine Version 8.3<p>Stonefield Software is pleased to announce the release of version 8.3 of Stonefield Query for GoldMine. <span>There are several new features in this version.</span></p>
<article class="content-pane"><div class="content-body"><ul>
<li><p>You can now specify additional files to attach to <a href="https://www.stonefieldsoftware.com/OnlineHelp/GoldMine/_0380pfg2h.htm">an email</a> in addition to the file for the report.</p>
</li>
<li><p><a href="https://www.stonefieldsoftware.com/OnlineHelp/GoldMine/_11u0u5th3.htm">Cross-tab reports</a> now support Highest and Lowest total types for date and datetime fields in the Data area.</p>
</li>
<li><p>You can now specify the horizontal orientation—left, right, or center, with center being the default—for <a href="https://www.stonefieldsoftware.com/OnlineHelp/GoldMine/_23v0yafg4.htm">a chart</a> included in a quick or cross-tab report.</p>
</li>
<li><p>If you add another data source using the <a href="https://www.stonefieldsoftware.com/OnlineHelp/GoldMine/_5vo0uguqp.htm">Other Data Sources dialog</a> and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.</p>
</li>
<li><p>You can now specify that a table added in the Other Data Sources dialog is non-reportable.</p>
</li>
<li><p>There are several <a href="https://www.stonefieldsoftware.com/OnlineHelp/GoldMine/_67l0jbnao.htm">DataGrid</a> enhancements:</p>
<ul>
<li>The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.</li>
<li>The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.</li>
<li>Logical (yes/no) fields now display as check boxes.</li>
</ul></li>
<li><p>You can now choose to not display a row field in a cross-tab report by setting its width to 0.</p>
</li>
<li><p>The recipient of an emailed report is now logged to the diagnostic file.</p>
</li>
<li><p>The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.</p></li>
</ul></div></article>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-53285123121937008802023-12-08T12:10:00.003-06:002023-12-08T12:10:33.884-06:00Stonefield Query for ALERE Version 8.3<p>Stonefield Software is pleased to announce the release of version 8.3 of Stonefield Query for ALERE. There are several new features in this version.</p>
<ul>
<li><p>You can now specify additional files to attach to <a href="https://www.stonefieldsoftware.com/OnlineHelp/ALERE/_0380pfg2h.htm" >an email</a> in addition to the file for the report.</p>
</li>
<li><p><a href="https://www.stonefieldsoftware.com/OnlineHelp/ALERE/_11u0u5th3.htm" >Cross-tab reports</a> now support Highest and Lowest total types for date and datetime fields in the Data area.</p>
</li>
<li><p>You can now specify the horizontal orientation—left, right, or center, with center being the default—for <a href="https://www.stonefieldsoftware.com/OnlineHelp/ALERE/_23v0yafg4.htm" >a chart</a> included in a quick or cross-tab report.</p>
</li>
<li><p>If you add another data source using the <a href="https://www.stonefieldsoftware.com/OnlineHelp/ALERE/_5vo0uguqp.htm" >Other Data Sources dialog</a> and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.</p>
</li>
<li><p>You can now specify that a table added in the Other Data Sources dialog is non-reportable.</p>
</li>
<li><p>There are several <a href="https://www.stonefieldsoftware.com/OnlineHelp/ALERE/_67l0jbnao.htm" >DataGrid</a> enhancements:</p>
<ul>
<li>The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.</li>
<li>The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.</li>
<li>Logical (yes/no) fields now display as check boxes.</li>
</ul></li>
<li><p>You can now choose to not display a row field in a cross-tab report by setting its width to 0.</p>
</li>
<li><p>The recipient of an emailed report is now logged to the diagnostic file.</p>
</li>
<li><p>The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.</p>
</li>
</ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-7787458182866464362023-12-08T12:08:00.003-06:002023-12-08T12:08:38.926-06:00Reporting4ACT! Version 8.3<div><br /></div><div><article class="content-pane" ><div class="content-body" ><p>Stonefield Software is pleased to announce the release of version 8.3 of Reporting4ACT! There are several new features in this version.</p>
<ul>
<li><p>You can now specify additional files to attach to <a href="https://www.stonefieldsoftware.com/OnlineHelp/ACT/_0380pfg2h.htm" >an email</a> in addition to the file for the report.</p>
</li>
<li><p><a href="https://www.stonefieldsoftware.com/OnlineHelp/ACT/_11u0u5th3.htm" >Cross-tab reports</a> now support Highest and Lowest total types for date and datetime fields in the Data area.</p>
</li>
<li><p>You can now specify the horizontal orientation—left, right, or center, with center being the default—for <a href="https://www.stonefieldsoftware.com/OnlineHelp/ACT/_23v0yafg4.htm" >a chart</a> included in a quick or cross-tab report.</p>
</li>
<li><p>If you add another data source using the <a href="https://www.stonefieldsoftware.com/OnlineHelp/ACT/_5vo0uguqp.htm" >Other Data Sources dialog</a> and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Reporting4Act! will still start up.</p>
</li>
<li><p>You can now specify that a table added in the Other Data Sources dialog is non-reportable.</p>
</li>
<li><p>There are several <a href="https://www.stonefieldsoftware.com/OnlineHelp/ACT/_67l0jbnao.htm" >DataGrid</a> enhancements:</p>
<ul>
<li>The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.</li>
<li>The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.</li>
<li>Logical (yes/no) fields now display as check boxes.</li>
</ul></li>
<li><p>You can now choose to not display a row field in a cross-tab report by setting its width to 0.</p>
</li>
<li><p>The recipient of an emailed report is now logged to the diagnostic file.</p>
</li>
<li><p>The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.</p>
</li>
<li><p>Act 25 (2023) is now supported.</p>
</li>
<li><p>The new CopyText function puts the specified value on the Windows Clipboard.</p>
</li>
<li><p>If Reporting4ACT cannot locate the ACT! installation folder for some reason, you can specify it using the ActFolder setting in the [Options] section of Data.ini.</p>
</li>
</ul></div></article></div>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-46679161682352922612023-12-08T12:05:00.006-06:002023-12-08T12:05:52.491-06:00Stonefield Query for AccountMate Version 8.3<p>Stonefield Software is pleased to announce the release of version 8.3 of Stonefield Query for AccountMate. There are several new features in this version.</p>
<ul>
<li><p>You can now specify additional files to attach to <a href="https://www.stonefieldsoftware.com/OnlineHelp/AccountMate/_0380pfg2h.htm" >an email</a> in addition to the file for the report.</p>
</li>
<li><p><a href="https://www.stonefieldsoftware.com/OnlineHelp/AccountMate/_11u0u5th3.htm" >Cross-tab reports</a> now support Highest and Lowest total types for date and datetime fields in the Data area.</p>
</li>
<li><p>You can now specify the horizontal orientation—left, right, or center, with center being the default—for <a href="https://www.stonefieldsoftware.com/OnlineHelp/AccountMate/_23v0yafg4.htm" >a chart</a> included in a quick or cross-tab report.</p>
</li>
<li><p>If you add another data source using the <a href="https://www.stonefieldsoftware.com/OnlineHelp/AccountMate/_5vo0uguqp.htm" >Other Data Sources dialog</a> and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.</p>
</li>
<li><p>You can now specify that a table added in the Other Data Sources dialog is non-reportable.</p>
</li>
<li><p>There are several <a href="https://www.stonefieldsoftware.com/OnlineHelp/AccountMate/_67l0jbnao.htm" >DataGrid</a> enhancements:</p>
<ul>
<li>The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.</li>
<li>The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.</li>
<li>Logical (yes/no) fields now display as check boxes.</li>
</ul></li>
<li><p>You can now choose to not display a row field in a cross-tab report by setting its width to 0.</p>
</li>
<li><p>The recipient of an emailed report is now logged to the diagnostic file.</p>
</li>
<li><p>The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.</p>
</li>
</ul>
Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-81953717819957650422023-11-23T16:29:00.003-06:002023-11-23T16:29:57.327-06:00Stonefield Query SDK Version 8.3<p>Stonefield Software is pleased to announce the release of version 8.3 of the Stonefield Query SDK. <span>There are several new features in this version.</span></p>
<h4 style="text-align: left;">Report Designer</h4>
<ul>
<li><p>You can now specify additional files to attach to <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_0380pfg2h.htm">an email</a> in addition to the file for the report.</p>
</li>
<li><p><a href="https://stonefieldquery.com/OnlineHelp/EndUser/_11u0u5th3.htm">Cross-tab reports</a> now support Highest and Lowest total types for date and datetime fields in the Data area.</p>
</li>
<li><p>You can now specify the horizontal orientation—left, right, or center, with center being the default—for <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_23v0yafg4.htm">a chart</a>.</p>
</li>
<li><p>If you add another data source using the <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_5vo0uguqp.htm">Other Data Sources dialog</a> and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.</p>
</li>
<li><p>You can now specify that a table added in the Other Data Sources dialog is non-reportable.</p>
</li>
<li><p>There are several <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_67l0jbnao.htm">DataGrid</a> enhancements:</p>
<ul>
<li>The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.</li>
<li>The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.</li>
<li>Logical (yes/no) fields now display as check boxes.</li>
</ul></li>
<li><p>You can now choose to not display a row field in a cross-tab report by setting its width to 0.</p>
</li>
<li><p>The recipient of an emailed report is now logged to the diagnostic file.</p>
</li>
<li><p>The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.</p>
</li>
</ul><h4 style="text-align: left;">Stonefield Query Studio</h4>
<article class="content-pane"><div class="content-body"><ul><li><p>A <a href="https://stonefieldquery.com/OnlineHelp/SDK/_3qw0nejqw.htm">DataEngine.GetObjectVersion</a> script can check which database the objects belongs to with the ObjectDatabase variable.</p>
</li>
<li><p>A new BeforeProcessTables event in SQConfig.sqs allows you to <a href="https://stonefieldquery.com/OnlineHelp/SDK/_0uy0vv48p.htm">execute custom code</a> before tables are processed when the data dictionary is created or updated from a data source.</p>
</li>
<li><p>The new <a href="https://stonefieldquery.com/OnlineHelp/SDK/_6rk0ppzi0.htm">Application.AfterLogin</a> script is called right after the user either successfully or unsuccessfully logs in.</p>
</li>
</ul></div></article>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-89530987061183177572022-12-16T16:48:00.001-06:002022-12-16T16:48:16.039-06:00Stonefield Query for Sage 300 Version 8.2.8385<p>We are pleased to annouce the release of version 8.2.8385 of Stonefield Query for Sage 300. This release supports Sage 300 2023.</p>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-91762652381210887662022-09-30T07:23:00.008-06:002022-09-30T07:23:58.332-06:00Reporting4ACT! Version 8.2<p>We are pleased to announce the release of version 8.2 of Reporting4ACT!. This is mainly a maintenance release but there are a few new features.</p><ul><li>Stonefield Query now supports <a href="https://stonefieldsoftware.com/OnlineHelp/ACT/_04a0xwfxe.htm">Modern Authentication</a> for email.</li><li>You can now indicate that a <a href="https://stonefieldsoftware.com/OnlineHelp/ACT/_0380pfg2e.htm">stored filter</a> is available for all reports or just the current report.</li><li>More <a href="https://stonefieldsoftware.com/OnlineHelp/ACT/_1q90n85l7.htm">Avery label types</a> are now supported.</li><li>Diagnostic files more than 30 days old are now automatically deleted.</li><li><a href="https://stonefieldsoftware.com/OnlineHelp/ACT/_0380pfg2h.htm">Spreadsheet output</a> was removed since it was almost never used and is superceded by new Microsoft Excel output formats.</li><li>Choosing the new Yes to All option when <a href="https://stonefieldsoftware.com/OnlineHelp/ACT/_2al0tjqhv.htm">importing multiple reports</a> means you won't be prompted for each one whether it should overwrite the existing report.</li></ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-60881863661547527262022-09-30T07:22:00.000-06:002022-09-30T07:22:03.364-06:00Stonefield Query for GoldMine Version 8.2<p>We are pleased to announce the release of version 8.2 of Stonefield Query for GoldMine. This is mainly a maintenance release but there are a few new features.</p><ul><li>Stonefield Query now supports <a href="https://stonefieldsoftware.com/OnlineHelp/GoldMine/_04a0xwfxe.htm">Modern Authentication</a> for email.</li><li>You can now indicate that a <a href="https://stonefieldsoftware.com/OnlineHelp/GoldMine/_0380pfg2e.htm">stored filter</a> is available for all reports or just the current report.</li><li>More <a href="https://stonefieldsoftware.com/OnlineHelp/GoldMine/_1q90n85l7.htm">Avery label types</a> are now supported.</li><li>Diagnostic files more than 30 days old are now automatically deleted.</li><li><a href="https://stonefieldsoftware.com/OnlineHelp/GoldMine/_0380pfg2h.htm">Spreadsheet output</a> was removed since it was almost never used and is superceded by new Microsoft Excel output formats.</li><li>Choosing the new Yes to All option when <a href="https://stonefieldsoftware.com/OnlineHelp/GoldMine/_2al0tjqhv.htm">importing multiple reports</a> means you won't be prompted for each one whether it should overwrite the existing report.</li></ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-33406132975565025692022-09-30T07:20:00.005-06:002022-09-30T07:20:41.319-06:00Stonefield Query for ALERE Version 8.2<p>We are pleased to announce the release of version 8.2 of Stonefield Query for ALERE. This is mainly a maintenance release but there are a few new features.</p><ul><li>Stonefield Query now supports <a href="https://stonefieldsoftware.com/OnlineHelp/ALERE/_04a0xwfxe.htm">Modern Authentication</a> for email.</li><li>You can now indicate that a <a href="https://stonefieldsoftware.com/OnlineHelp/ALERE/_0380pfg2e.htm">stored filter</a> is available for all reports or just the current report.</li><li>More <a href="https://stonefieldsoftware.com/OnlineHelp/ALERE/_1q90n85l7.htm">Avery label types</a> are now supported.</li><li>Diagnostic files more than 30 days old are now automatically deleted.</li><li><a href="https://stonefieldsoftware.com/OnlineHelp/ALERE/_0380pfg2h.htm">Spreadsheet output</a> was removed since it was almost never used and is superceded by new Microsoft Excel output formats.</li><li>Choosing the new Yes to All option when <a href="https://stonefieldsoftware.com/OnlineHelp/ALERE/_2al0tjqhv.htm">importing multiple reports</a> means you won't be prompted for each one whether it should overwrite the existing report.</li></ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-82946484674868614022022-09-30T07:19:00.002-06:002022-09-30T07:19:19.330-06:00Stonefield Query for AccountMate Version 8.2<p>We are pleased to announce the release of version 8.2 of Stonefield Query for AccountMate. This is mainly a maintenance release but there are a few new features.</p><ul><li>Stonefield Query now supports <a href="https://stonefieldsoftware.com/OnlineHelp/AccountMate/_04a0xwfxe.htm">Modern Authentication</a> for email.</li><li>You can now indicate that a <a href="https://stonefieldsoftware.com/OnlineHelp/AccountMate/_0380pfg2e.htm">stored filter</a> is available for all reports or just the current report.</li><li>More <a href="https://stonefieldsoftware.com/OnlineHelp/AccountMate/_1q90n85l7.htm">Avery label types</a> are now supported.</li><li>Diagnostic files more than 30 days old are now automatically deleted.</li><li><a href="https://stonefieldsoftware.com/OnlineHelp/AccountMate/_0380pfg2h.htm">Spreadsheet output</a> was removed since it was almost never used and is superceded by new Microsoft Excel output formats.</li><li>Choosing the new Yes to All option when <a href="https://stonefieldsoftware.com/OnlineHelp/AccountMate/_2al0tjqhv.htm">importing multiple reports</a> means you won't be prompted for each one whether it should overwrite the existing report.</li></ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-15686010663865369022022-09-30T07:17:00.002-06:002022-09-30T07:17:13.908-06:00Stonefield Query for Sage Pro ERP Version 8.2<p>We are pleased to announce the release of version 8.2 of Stonefield Query for Sage Pro ERP. This is mainly a maintenance release but there are a few new features.</p><ul><li>Stonefield Query now supports <a href="https://stonefieldsoftware.com/OnlineHelp/SagePro/_04a0xwfxe.htm">Modern Authentication</a> for email.</li><li>You can now indicate that a <a href="https://stonefieldsoftware.com/OnlineHelp/SagePro/_0380pfg2e.htm">stored filter</a> is available for all reports or just the current report.</li><li>More <a href="https://stonefieldsoftware.com/OnlineHelp/SagePro/_1q90n85l7.htm">Avery label types</a> are now supported.</li><li>Diagnostic files more than 30 days old are now automatically deleted.</li><li><a href="https://stonefieldsoftware.com/OnlineHelp/SagePro/_0380pfg2h.htm">Spreadsheet output</a> was removed since it was almost never used and is superceded by new Microsoft Excel output formats.</li><li>Choosing the new Yes to All option when <a href="https://stonefieldsoftware.com/OnlineHelp/SagePro/_2al0tjqhv.htm">importing multiple reports</a> means you won't be prompted for each one whether it should overwrite the existing report.</li></ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-47422193586531189322022-09-30T07:11:00.003-06:002022-09-30T07:11:33.578-06:00Stonefield Query for Sage 300 Version 8.2<p>We are pleased to announce the release of version 8.2 of Stonefield Query for Sage 300. This is mainly a maintenance release but there are a few new features.</p><ul><li>Stonefield Query now supports <a href="https://stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_04a0xwfxe.htm">Modern Authentication</a> for email.</li><li>You can now indicate that a <a href="https://stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_0380pfg2e.htm">stored filter</a> is available for all reports or just the current report.</li><li>More <a href="https://stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_1q90n85l7.htm">Avery label types</a> are now supported.</li><li>Diagnostic files more than 30 days old are now automatically deleted.</li><li><a href="https://stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_0380pfg2h.htm">Spreadsheet output</a> was removed since it was almost never used and is superceded by new Microsoft Excel output formats.</li><li>Choosing the new Yes to All option when <a href="https://stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_2al0tjqhv.htm">importing multiple reports</a> means you won't be prompted for each one whether it should overwrite the existing report.</li><li>Performance of reports using certain payroll fields was improved.</li></ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-13606290596930927722022-09-27T15:56:00.000-06:002022-09-27T15:56:14.569-06:00Stonefield Query SDK Version 8.2<p>We are pleased to announce the release of version 8.2 of the Stonefield Query SDK. This is mainly a maintenance release but there are a few new features.</p>
<ul><li>Stonefield Query now supports <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_04a0xwfxe.htm">Modern Authentication</a> for email.</li>
<li>You can now indicate that a <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_0380pfg2e.htm">stored filter</a> is available for all reports or just the current report.</li>
<li>More <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_1q90n85l7.htm">Avery label types</a> are now supported.</li>
<li>Diagnostic files more than 30 days old are now automatically deleted.</li>
<li><a href="https://stonefieldquery.com/OnlineHelp/EndUser/_0380pfg2h.htm">Spreadsheet output</a> was removed since it was almost never used and is superceded by new Microsoft Excel output formats.</li>
<li>Choosing the new Yes to All option when <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_2al0tjqhv.htm">importing multiple reports</a> means you won't be prompted for each one whether it should overwrite the existing report.</li>
</ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-25300690029505533992022-03-16T10:11:00.002-06:002022-03-16T10:11:32.439-06:00Stonefield Query Enterprise is now Horizon Reports<p>Stonefield Software Inc. is pleased to announce that effective immediately, Stonefield Query Enterprise (the web version of Stonefield Query) has been purchased by Horizon Reports, <a href="https://www.horizon-reports.com">https://www.horizon-reports.com</a>. Horizon Reports is owned and operated by Trevor Mansuy, former lead developer of Stonefield Query Enterprise, so the product is in great hands. All licenses and software maintenance have been transferred to Horizon Reports.</p><p>Please note that Stonefield Software still owns and will continue to develop, maintain, and support Stonefield Query (the desktop version). Licenses of that version remain with Stonefield Software and we will continue to provide support and new versions of that product.</p>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-39047242751613944892022-01-20T11:49:00.003-06:002022-01-20T11:49:38.679-06:00Reporting4ACT! Version 8.1<p>We are pleased to announce the release of version 8.1 of Reporting4ACT! <span >There are several new features in this version.</span></p>
<ul>
<li><p>The new <a href="https://www.stonefieldsoftware.com/OnlineHelp/ACT/_67l0jbnao.htm" >Data Grid</a> button in the ribbon and toolbar output a report to a data grid window.</p>
</li>
<li><p>Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).</p>
</li>
<li><p>You can now control what folder <a href="https://www.stonefieldsoftware.com/OnlineHelp/ACT/_10w10k6f0.htm" >scheduled tasks</a> are placed in rather than always being in the "root" folder in the Task Scheduler.</p>
</li>
<li><p>The Test Syntax button in the Customize SQL Statement step of the <a href="https://www.stonefieldsoftware.com/OnlineHelp/ACT/_0zq0rtwz7.htm" >Customize Report Wizard</a> now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Reporting4Act!.</p>
</li>
<li><p>If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the <a href="https://www.stonefieldsoftware.com/OnlineHelp/ACT/_1ts0y2ijn.htm" >Displayed Logged in Users</a> dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.</p>
</li>
</ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-34605246686451535482022-01-14T14:24:00.003-06:002022-01-14T14:24:12.679-06:00Stonefield Query for ALERE Version 8.1<p><span >We are pleased to announce the release of version 8.1 of Stonefield Query for ALERE. </span><span >There are several new features in this version.</span></p>
<ul>
<li><p>The new <a href="https://www.stonefieldsoftware.com/OnlineHelp/ALERE/_67l0jbnao.htm" >Data Grid</a> button in the ribbon and toolbar output a report to a data grid window.</p>
</li>
<li><p>Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).</p>
</li>
<li><p>You can now control what folder <a href="https://www.stonefieldsoftware.com/OnlineHelp/ALERE/_10w10k6f0.htm" >scheduled tasks</a> are placed in rather than always being in the "root" folder in the Task Scheduler.</p>
</li>
<li><p>The Test Syntax button in the Customize SQL Statement step of the <a href="https://www.stonefieldsoftware.com/OnlineHelp/ALERE/_0zq0rtwz7.htm" >Customize Report Wizard</a> now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.</p>
</li>
<li><p>If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the <a href="https://www.stonefieldsoftware.com/OnlineHelp/ALERE/_1ts0y2ijn.htm" >Displayed Logged in Users</a> dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.</p>
</li>
</ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-81276331651238636922022-01-14T14:17:00.004-06:002022-01-14T14:17:39.455-06:00Stonefield Query for GoldMine Version 8.1<p>We are pleased to announce the release of version 8.1 of Stonefield Query for GoldMine. <span >There are several new features in this version.</span></p>
<ul>
<li><p>The new <a href="https://www.stonefieldsoftware.com/OnlineHelp/GoldMine/_67l0jbnao.htm" >Data Grid</a> button in the ribbon and toolbar output a report to a data grid window.</p>
</li>
<li><p>Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).</p>
</li>
<li><p>You can now control what folder <a href="https://www.stonefieldsoftware.com/OnlineHelp/GoldMine/_10w10k6f0.htm" >scheduled tasks</a> are placed in rather than always being in the "root" folder in the Task Scheduler.</p>
</li>
<li><p>The Test Syntax button in the Customize SQL Statement step of the <a href="https://www.stonefieldsoftware.com/OnlineHelp/GoldMine/_0zq0rtwz7.htm" >Customize Report Wizard</a> now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.</p>
</li>
<li><p>If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the <a href="https://www.stonefieldsoftware.com/OnlineHelp/GoldMine/_1ts0y2ijn.htm" >Displayed Logged in Users</a> dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.</p>
</li>
</ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-73125899567044083452022-01-13T15:55:00.003-06:002022-01-13T15:55:29.210-06:00Stonefield Query for AccountMate Version 8.1<p>We are pleased to announce the release of version 8.1 of Stonefield Query for AccountMate. There are several new features in this release.</p>
<ul>
<li><p>The new <a href="https://www.stonefieldsoftware.com/OnlineHelp/AccountMate/_67l0jbnao.htm" >Data Grid</a> button in the ribbon and toolbar output a report to a data grid window.</p>
</li>
<li><p>Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).</p>
</li>
<li><p>You can now control what folder <a href="https://www.stonefieldsoftware.com/OnlineHelp/AccountMate/_10w10k6f0.htm" >scheduled tasks</a> are placed in rather than always being in the "root" folder in the Task Scheduler.</p>
</li>
<li><p>The Test Syntax button in the Customize SQL Statement step of the <a href="https://www.stonefieldsoftware.com/OnlineHelp/AccountMate/_0zq0rtwz7.htm" >Customize Report Wizard</a> now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.</p>
</li>
<li><p>If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the <a href="https://www.stonefieldsoftware.com/OnlineHelp/AccountMate/_1ts0y2ijn.htm" >Displayed Logged in Users</a> dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.</p>
</li>
</ul>
Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-35753042743496186332022-01-12T10:36:00.006-06:002022-01-12T10:36:44.292-06:00Stonefield Query for Sage Pro ERP Version 8.1<p> We are pleased to announce the release of version 8.1 of Stonefield Query for Sage Pro ERP. <span >There are several new features in this version.</span></p>
<ul>
<li><p>The new <a href="https://www.stonefieldsoftware.com/OnlineHelp/SagePro/_67l0jbnao.htm" >Data Grid</a> button in the ribbon and toolbar output a report to a data grid window.</p>
</li>
<li><p>Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).</p>
</li>
<li><p>You can now control what folder <a href="https://www.stonefieldsoftware.com/OnlineHelp/SagePro/_10w10k6f0.htm" >scheduled tasks</a> are placed in rather than always being in the "root" folder in the Task Scheduler.</p>
</li>
<li><p>The Test Syntax button in the Customize SQL Statement step of the <a href="https://www.stonefieldsoftware.com/OnlineHelp/SagePro/_0zq0rtwz7.htm" >Customize Report Wizard</a> now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.</p>
</li>
<li><p>If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the <a href="https://www.stonefieldsoftware.com/OnlineHelp/SagePro/_1ts0y2ijn.htm" >Displayed Logged in Users</a> dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.</p>
</li>
<li><p>The performance of "Current + History" tables has been improved.</p>
</li>
</ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-50788569349578734562022-01-12T10:34:00.002-06:002022-01-12T10:34:31.235-06:00Stonefield Query for Sage 300 Version 8.1<div >We are please to announce the release of version 8.1 of Stonefield Query for Sage 300. <span >There are several new features in this version.</span></div><ul>
<li><p>Stonefield Query now works with Sage 300 2022 (version 6.9).</p>
</li>
<li><p>The new <a href="https://www.stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_67l0jbnao.htm" >Data Grid</a> button in the ribbon and toolbar output a report to a data grid window.</p>
</li>
<li><p>Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).</p>
</li>
<li><p>You can now control what folder <a href="https://www.stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_10w10k6f0.htm" >scheduled tasks</a> are placed in rather than always being in the "root" folder in the Task Scheduler.</p>
</li>
<li><p>The Test Syntax button in the Customize SQL Statement step of the <a href="https://www.stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_0zq0rtwz7.htm" >Customize Report Wizard</a> now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.</p>
</li>
<li><p>If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the <a href="https://www.stonefieldsoftware.com/OnlineHelp/SageAccpacERP/_1ts0y2ijn.htm" >Displayed Logged in Users</a> dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.</p>
</li>
<li><p>Database passwords up to 40 characters are now supported.</p>
</li>
</ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-5248201365019171402022-01-06T13:24:00.000-06:002022-01-06T13:24:17.459-06:00Stonefield Query SDK Version 8.1<p> We are pleased to announce the release of version 8.1 of the Stonefield Query SDK. Here are the new features.</p><p><strong>Report Designer</strong></p><ul><li><p>The new <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_67l0jbnao.htm">Data Grid</a> button in the ribbon and toolbar output a report to a data grid window.</p></li><li><p>Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).</p></li><li><p>You can now control what folder <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_10w10k6f0.htm">scheduled tasks</a> are placed in rather than always being in the "root" folder in the Task Scheduler.</p></li><li><p>The Test Syntax button in the Customize SQL Statement step of the <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_0zq0rtwz7.htm">Customize Report Wizard</a> now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.</p></li><li><p>If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the <a href="https://stonefieldquery.com/OnlineHelp/EndUser/_1ts0y2ijn.htm">Displayed Logged in Users</a> dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.</p></li></ul><p><strong>Stonefield Query Studio</strong></p><ul><li><p>The <a href="https://stonefieldquery.com/OnlineHelp/SDK/_1o90zm4d9.htm">View Table Contents</a> and View Field Contents windows now have search, filter, and export to Microsoft Excel functionality.</p></li><li><p>Project encryption is no longer supported.</p></li><li><p>VFP9R.dll, VFP9RENU.dll, and ISXDL.dll are no longer installed since they are no longer required.</p></li><li><p>The <a href="https://stonefieldquery.com/OnlineHelp/SDK/_0u00tiyhb.htm">Generate Setup</a> function now requires Inno Setup version 6.1 or later.</p></li><li><p>The installer has a more modern icon and appearance.</p></li></ul>Doug Hennighttp://www.blogger.com/profile/00208525487680844022noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-83171831022755003882021-10-28T22:58:00.000-06:002021-10-28T22:58:22.298-06:00Stonefield Query for GoldMine Version 8.0.7947<p><span style="font-family: inherit;">We are pleased to announce the release of version 8.0.7947 of Stonefield Query for GoldMine. The main purpose of this release is for compatibility with the new GoldMine 2021.2. The new features in this version are:</span></p><ul id="pragma-line-4" style="background-color: white; box-sizing: border-box; color: #555555; margin-bottom: 1.2em; margin-top: 1em;"><li id="pragma-line-4" style="box-sizing: border-box; margin-bottom: 0.5em;"><p id="pragma-line-4" style="box-sizing: border-box; margin: 0px 0px 10px;"><span style="font-family: inherit;">Stonefield Query is compatible with GoldMine 2021.2.</span></p></li><li id="pragma-line-6" style="box-sizing: border-box; margin-bottom: 0.5em;"><p id="pragma-line-6" style="box-sizing: border-box; margin: 0px 0px 10px;"><span style="font-family: inherit;">An issue causing some report output layouts to be distorted was resolved.</span></p></li></ul>
<p><span style="font-family: inherit;">All new features and improvements from earlier version 8.0 releases are also included in 8.0.7947.</span></p>Rob Eislerhttp://www.blogger.com/profile/13741492339993364076noreply@blogger.com0tag:blogger.com,1999:blog-1605965604705320211.post-18857077527946268392021-10-22T23:24:00.003-06:002021-10-22T23:24:41.491-06:00Reporting4Act! Version 8.0.7947<p><span style="font-family: inherit;">We are pleased to announce the release of version 8.0.7947 of Reporting4Act!. The main purpose of this release is to add compatibility with the new Act! v24. The new features in this version are:</span></p><ul id="pragma-line-4" style="background-color: white; box-sizing: border-box; color: #555555; margin-bottom: 1.2em; margin-top: 1em;"><li id="pragma-line-4" style="box-sizing: border-box; margin-bottom: 0.5em;"><p id="pragma-line-4" style="box-sizing: border-box; margin: 0px 0px 10px;"><span style="font-family: inherit;">Reporting4Act! is now compatible with Act! v24.</span></p></li><li id="pragma-line-6" style="box-sizing: border-box; margin-bottom: 0.5em;"><p id="pragma-line-6" style="box-sizing: border-box; margin: 0px 0px 10px;"><span style="font-family: inherit;">An issue causing some report output layouts to be distorted was resolved.</span></p></li></ul>
<p><span style="font-family: inherit;">All new features and improvements from the initial version 8.0 release are also included in 8.0.7947.</span></p>Rob Eislerhttp://www.blogger.com/profile/13741492339993364076noreply@blogger.com0