Stonefield Query for Sage Accpac ERP Version 3.2 Build 3362

We posted an updated version of Stonefield Query for Sage Accpac ERP today with the following changes.

• A new Extended Amount Less Discount field in Order Entry Invoice Details, Credit Note Details, Combined Invoice & Credit Note Details, and Order Details shows the net amount of the transaction.
• There are now direct relationships between Accounts Receivable Documents and Order Entry Invoices, Credit Notes, and Combined Invoices & Credit Notes, so reporting on these tables works better.
• A bug that caused an error when reporting on both Invoices and Invoice Details in Order Entry was fixed.
• A bug that caused an error when reporting on Combined Invoices & Credit Notes and Combined Invoice & Credit Note Details tables in Order Entry was fixed.
• A bug that prevented exclusion filters from working under some unique circumstances was fixed.
• A bug that prevented GROUP BY and ORDER BY clauses from being handled properly in custom SQL statements was fixed.
• A bug that caused numeric values to appear without any decimals when the first value in the result set is null was fixed.
• A bug that caused an error when opening or closing the preview window under rare circumstances was fixed.

Stonefield Query Version 3.2 Build 3362

We posted an updated versions of the Stonefield Query SDK today with the following changes:

• The Test button for relationships in the Configuration Utility now respects the setting of the Include Joins in the WHERE Clause configuration setting.
• Stonefield Query user names and passwords, database connection information, and email information are no longer decrypted into variables in memory so they never exist in clear text anywhere, including memory dumps or error logs.
• The Configuration Utility now supports databases with a period in the name (for example, "My.Database").
• A bug that prevented exclusion filters from working under some unique circumstances was fixed.
• A bug that prevented GROUP BY and ORDER BY clauses from being handled properly in custom SQL statements was fixed.
• A bug that prevented enumerated fields that contain illegal characters (such as a dash) from working properly was fixed.
• A bug that caused numeric values to appear without any decimals when the first value in the result set is null was fixed.
• A bug that caused the SQL statement for a report to be truncated when one or more of the tables is a virtual table was fixed.
• Stonefield Query now properly handles custom SQL statements involving subtables.
• A bug that caused an error when opening or closing the preview window under rare circumstances was fixed.
• A bug that caused an error when adding a VFP database to the Configuration Utility was fixed.
• A bug that caused an error when running a report involving subtables in a VFP database was fixed.