Thursday, September 21, 2017

Stonefield Query for Sage 300 Version 6.1.6467.

This version adds compatibility with Sage 300 2018 and is also a maintenance release. It has the following new features:

  • The performance of outputting a report with a large number of records (tens of thousands) to Microsoft Excel Data-Only (Fast) was greatly improved (90% faster).
  • The Order Entry Sales History (OESHHD) and Sales History Details (OESHDT) tables now have Net Amount (Functional) and Net Amount (Source) fields (FNETAMT and SNETAMT, respectively), which are sales amount less returns amount.
  • There's now a relationship between the GL Posted Transactions table (GLPOST) and the AP Posting Journal Entries table (APPJH) so you can drilldown from a GL entry to the matching AP entry.