Stonefield Query for Sage 300 Version 5.2.5868

We are please to announce the release of version 5.2.5868 of Stonefield Query for Sage 300. There are several new features in this release.

• Stonefield Query now supports Sage 300 2016 (version 6.3).

• A new type of output is available: Microsoft Word Mail Merge. This allows you to perform a mail merge from a report to create form letters.

• The Maintain Databases dialog now shows a checkmark in front of data sources used with Stonefield Query in the data source list so you can tell at a glance which ones are used.

• A formula can now use an expression that doesn't retrieve data from the database, such as " ", which allows you to add a blank column to a report.

• The SQLookup function can now return an expression instead of just a field. The expression must be one the database engine can understand rather than a Stonefield Query expression.

• The GetConditionValue function now accepts a parameter indicating which value for "is between" and "is one of" conditions is returned.

• You can now turn off usage reporting by adding Usage=N to the [Options] section of Data.ini.

• If none of your data fields contain null values, you can make processing slightly faster by adding HandleNull=N to the [Options] section of Data.INI.

• Grouping formulas can now be used as data fields in a cross-tab report.

• Cross-tab reports now use the text for the Summary Total Template field in the template if it exists; this allows you to customize the text displayed for the totals line by changing the text in the template used by the report.

• Help now displays correctly even when running from a server without having to install the help file on the workstation.

• The Calculate Value at Group Level setting in the Formula Editor is now disabled if the field is a grouping formula since a formula can't be both.

• The GetConditionValue, GetValueForField, GetValueForParameter, GoMonthDay, SQLookup, STOD, and RunSQL functions now appear in the Built-in Functions list in the Expression Builder.

• The Print button in the Preview window is now disabled for a label report using a Dymo label size since it works better to print those labels directly rather than previewing first.

• You can now specify "login" on the command line to prompt the user to log in when running a dashboard from a shortcut. Also, theDashboard Wizard now has a "Require login" setting in step 2.