Stonefield Query for ALERE 3.3 Build 3792

We released an update to Stonefield Query for ALERE version 3.3 today. This new release adds support for ALERE version 6.6 databases. For a list of other new features in this version please see our Online Help File.

Article on Sage Software

Software Advice has an article discussing the features of some of Sage’s ERP offerings in the manufacturing and distribution software industries, specifically MAS, X3, Pro, and PFW. Although they missed discussing Accpac, it’s still a good overview of the products it does cover.

Stonefield Query for Sage Accpac ERP Version 3.3 Build 3756

We released an update to Stonefield Query for Sage Accpac ERP version 3.3 today. It has the following new features:

• The performance of optional fields containing character values was dramatically improved. For example, a report that used optional fields extensively used to take 2.5 hours to run but now takes 2.5 seconds!
• You can now report on the Inventory Control Units of Measure table.
• The relationships for the Order Entry Comments/Instructions tables (for example, Invoice Comments/Instructions) were changed so records from the other table appear regardless of whether there are Comments/Instructions records or not (in technical terms, they now use an outer join). Also, there's now a relationship between Cred. Note Comments/Instructions and Combined Invoice & Credit Note Details.
• A relationship was added between Order Entry Posting Journals - Details and Sales History Details.
• UniSales budget fields are handled better.
• The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
• Fields with drop-down lists in the Filter Condition dialog now have a blank value as an option. This allows you to blank previously entered values.

Stonefield Query for SageCRM Version 3.3 Build 3713

We released an update to Stonefield Query for SageCRM version 3.3 today. This update adds support for SageCRM version 7.0.

Stonefield Query for Sage Accpac ERP Version 3.3 Build 3713

We released an update to Stonefield Query for Sage Accpac ERP version 3.3 today. It has the following new features:

• There are now relationships between the Order Entry Sales History Details table and the Credit/Debit Notes, Invoices, and Combined Invoices & Credit Notes tables, and the Accounts Receivable Document Details table and Item Pricing table.
• There are a couple of new fields available in the Accounts Receivable Documents table: Document Amt (Functional) and Document Amt (Customer). These fields contains the document amount with taxes removed and retainage (if any) included.
• There are three new fields available in the Accounts Receivable Document Details table: Extended Amt (Customer), Amt / Tax Base (Customer), and Amt / Tax Base (Functional). The latter two contain the detail line amount not including any taxes, and is also the amount the tax amounts are based on.
• There are a couple of new fields available in the Accounts Payable Documents table: Document Amt (Functional) and Document Amt (Vendor). These fields contains the document amount with taxes removed and retainage (if any) included.
• There are a couple of new fields available in the Accounts Payable Document Details table: Amt / Tax Base (Vendor), and Amt / Tax Base (Functional). These fields contain the detail line amount not including any taxes, and is also the amount the tax amounts are based on.

The Stonefield Query Alternative

Stonefield Query is discussed as an alternative to Crystal Reports and SQL Server Reporting Services in this article on the Software for Enterprise site.

Stonefield Query for Sage Pro ERP Version 3.3 Build 3667

We released an update to Stonefield Query for Sage Pro ERP version 3.3 today. It has the following new features:

• Sage Pro 2010 is now supported.
• Relationships were created between the PO Transaction File and the Inventory Transaction, Item at Location, and Purchase Order Master Files.
• There's a new Quantity Open field (which is Qty Ordered - Qty Received) in the Order Entry Transactions File.
• There are new On Order PO and Allocated SO fields in the Inventory Master File.
• You can configure Stonefield Query to use the Sage Pro DSN directly instead of going through the Sage Pro COM component when accessing SQL Server. To do this, add the following to DATA.INI:
  
  UseDSN=Y
  
  
• In the Field Properties dialog, the Summary option has a new choice: Count Distinct. The difference between Count and Count Distinct is that Count counts the number of records while Count Distinct counts the number of records having unique values on this field. For example, if there are 100 order records but all orders were placed this week, using Count on the Order Date field would display 100 but Count Distinct would display 7 (assuming at least one order was placed every day this week). Also, the Summary option is now available for all field types, not just numeric fields.
• The Display date as option in the Field Properties dialog has a new choice: Hour, which displays the hour portion of the datetime value.
• If you use a date or datetime field in the X-axis, missing values are automatically added to the chart, and the range of those values respects any date filter you use. For example, in the following chart, the only dates that had orders were 07/04, 07/05, and 07/08, but the filter condition was Order Date is between 07/01/1996 and 07/08/1996, so all days between those dates appear whether they had any orders or not:
• The Chart Type page in Step 4 of the Chart Wizard has a new Summary report option, which is turned on by default. Turn this option off if, instead of displaying summarized values, you want individual values charted.
• The Formula Editor has a new Send formula to database engine option that allows you to specify whether the database engine evaluates the formula or whether Stonefield Query requests any fields used in the formula from the database engine and then evaluates the formula itself.
• If you use an existing formula in a new formula, the existing formula is no longer expanded to show its definition in the new formula; instead, just its name appears, as it did when you created the new formula. For example, suppose a formula called Total Price is Unit Price * Quantity. If you create another formula called Commission, which is Total Price * 0.05, the formula displays as Total Price * 0.05 rather than Unit Price * Quantity * 0.05 as it used to in previous versions.
• Cross-tab reports have a new "Show percentage of total" option.
• Blank column headings now appear as "(None)" in cross-tab reports.
• In a multiple database report, if the query for one database fails for a reason other than a connection problem, the report continues to run if the Continue multi-database report if cannot connect to one database setting in the Options dialog is turned on.

Stonefield Query SDK Version 3.3 Build 3667

We released an update to the Stonefield Query SDK version 3.3 today. It has the following new features:

Report Designer

• In the Field Properties dialog, the Summary option has a new choice: Count Distinct. The difference between Count and Count Distinct is that Count counts the number of records while Count Distinct counts the number of records having unique values on this field. For example, if there are 100 order records but all orders were placed this week, using Count on the Order Date field would display 100 but Count Distinct would display 7 (assuming at least one order was placed every day this week). Also, the Summary option is now available for all field types, not just numeric fields.
• The Display date as option in the Field Properties dialog has a new choice: Hour, which displays the hour portion of the datetime value.
• If you use a date or datetime field in the X-axis, missing values are automatically added to the chart, and the range of those values respects any date filter you use. For example, in the following chart, the only dates that had orders were 07/04, 07/05, and 07/08, but the filter condition was Order Date is between 07/01/1996 and 07/08/1996, so all days between those dates appear whether they had any orders or not:
• The Chart Type page in Step 4 of the Chart Wizard has a new Summary report option, which is turned on by default. Turn this option off if, instead of displaying summarized values, you want individual values charted.
• The Formula Editor has a new Send formula to database engine option that allows you to specify whether the database engine evaluates the formula or whether Stonefield Query requests any fields used in the formula from the database engine and then evaluates the formula itself.
• If you use an existing formula in a new formula, the existing formula is no longer expanded to show its definition in the new formula; instead, just its name appears, as it did when you created the new formula. For example, suppose a formula called Total Price is Unit Price * Quantity. If you create another formula called Commission, which is Total Price * 0.05, the formula displays as Total Price * 0.05 rather than Unit Price * Quantity * 0.05 as it used to in previous versions.
• Cross-tab reports have a new "Show percentage of total" option.
• Blank column headings now appear as "(None)" in cross-tab reports.
• In a multiple database report, if the query for one database fails for a reason other than a connection problem, the report continues to run if the Continue multi-database report if cannot connect to one database setting in the Options dialog is turned on.

SDK

• Stonefield Query now supports the syntax for outer joins used by older versions of Oracle, such as SELECT SomeFields FROM SomeTable, SomeOtherTable WHERE SomeTable.SomeField = SomeOtherTable.SomeField (+).
• You can now specify that a database login dialog should appear when the Configuration Utility connects to the database by adding DispLogins=2 to a [Settings] section in SFQEDITOR.INI (if that file doesn't exist, create it).

Stonefield Query for Sage Accpac ERP Version 3.3 Build 3667

We released an update to Stonefield Query for Sage Accpac ERP version 3.3 today. It has the following new features:

• Stonefield Query now supports optional fields in the Return Material Authorizations and Return Material Authorization Details tables.
• There is now a relationship between the AR Ship-To Locations and OE Invoices, Credit/Debit Notes, and Combined Invoices & Credit Notes tables.
• Each Uni Sales Analysis budget now appears as its own table named "Budget" followed by the budget name, and these tables are linked to the Sales Analysis Details table so you can include both budget and actual amounts on the same report.
• In the Field Properties dialog, the Summary option has a new choice: Count Distinct. The difference between Count and Count Distinct is that Count counts the number of records while Count Distinct counts the number of records having unique values on this field. For example, if there are 100 order records but all orders were placed this week, using Count on the Order Date field would display 100 but Count Distinct would display 7 (assuming at least one order was placed every day this week). Also, the Summary option is now available for all field types, not just numeric fields.
• The Display date as option in the Field Properties dialog has a new choice: Hour, which displays the hour portion of the datetime value.
• If you use a date or datetime field in the X-axis, missing values are automatically added to the chart, and the range of those values respects any date filter you use. For example, in the following chart, the only dates that had orders were 07/04, 07/05, and 07/08, but the filter condition was Order Date is between 07/01/1996 and 07/08/1996, so all days between those dates appear whether they had any orders or not:
• The Chart Type page in Step 4 of the Chart Wizard has a new Summary report option, which is turned on by default. Turn this option off if, instead of displaying summarized values, you want individual values charted.
• The Formula Editor has a new Send formula to database engine option that allows you to specify whether the database engine evaluates the formula or whether Stonefield Query requests any fields used in the formula from the database engine and then evaluates the formula itself.
• If you use an existing formula in a new formula, the existing formula is no longer expanded to show its definition in the new formula; instead, just its name appears, as it did when you created the new formula. For example, suppose a formula called Total Price is Unit Price * Quantity. If you create another formula called Commission, which is Total Price * 0.05, the formula displays as Total Price * 0.05 rather than Unit Price * Quantity * 0.05 as it used to in previous versions.
• Cross-tab reports have a new "Show percentage of total" option.
• Blank column headings now appear as "(None)" in cross-tab reports.
• In a multiple database report, if the query for one database fails for a reason other than a connection problem, the report continues to run if the Continue multi-database report if cannot connect to one database setting in the Options dialog is turned on.

AccountMate 7.6 Now Supported

A small update of Stonefield Query for AccountMate SQL is now available that supports the new versions that were recently released by AccountMate. This includes AccountMate 7.6 for SQL and AccountMate 7.6 for Express.