MoneyWorks

May 2014 — bug fixes and performance improvements

• Much faster opening of orders on network
• Restored 32-bit support to Mac Datacentre
• Windows pasting xml records from clipboard no longer throwing a spurious “malformed xml” error
• Fixed a glitch in script editor syntax colouring that could change the selection while typing
• Now run on Windows 2003 server (was erroneously being flagged as unsupported unpatched XP version)
• Script Editor on Mac no longer changes the editor font after cutting/deleting the entire script text
• Script Editor auto-backup now goes into std plugins not custom
• MWScript loop control variables can now be used as sub-loop range params
• Validation settings: “reapply” checkbox now works
• Fixed errors thrown by some reports running on Cashbook/Express (Cashbook and Express can now use all possible default joins when running reports)
• No longer erroneously request nameless password resource from keychain on Mac when connecting (could cause system keychain unlock request if system keychain contained an unnamed password resource)
• Removed Build fields from Product advanced search nametable (caused crash in syntax check if used)
• Fixed nonfunctional/crashing SortListByColumn() intrinsic function
• View department dispatch code for navigator
• Fixed a resource leak in choices windows
• Fix custom controls whose names end with a colon (broken by the new custom control validation syntax in 7.1)
• MoneyWorks Now: access granting username/email check more robust
• MoneyWorks Now: save the newly set Require Password setting before uploading document to cloud server
• MoneyWorks Now: enable Login button after password change warning for autocreated account
• Disable email address changing while MWNow access is granted (ungrant to change email)
• Fixed crash if attempt to create MWNow account while uploading a file to MWNow
• Fixed a rare startup crash when looking for navigator extras
• DC Console usage report generation: display alert if user has no write perm to create report (happens if user is not in staff group on Mac)
• Set Run On Server option for Executive Summary in Dashboard Reports
• Fixed unreliability of report library scripts when running on server
• Better Add Part icon on BOM entry screen
• Fixed fatal error that could happen when deleting an invalid part code line from BOM

May 2014

• Helper.scpt applescripts that implemented UserLoggedIn with no return value were aborting login
• UserLoggedIn not being sent to MWScript scripts as documented
• Applescript error messages containing “{}” were getting mangled
• Fixed a potentially crashing buffer overflow in the report generator
• Fixed a potential crash in script editor/compiler when dot notation used on for loop control variable for a textfile
• MWNow shortcuts no longer try to autologin if the password is not in the keychain
• Multilaunch was not working on 7.1 Windows
• Copy/Paste records on Windows was not working for non-ASCII data
• Transaction.DeliveryAddress was not mapping to own address for purchases

Known bugs:

• The Ledger Report is not working in Cashbook and Express 7.1/7.1.1. Will be fixed in 7.1.2
• Will not run on Windows 2003 Server (erroneously flagged as unsupported XP version)

May 2014

Please note: Windows XP SP2 and earlier are not supported in MoneyWorks 7. If you are running XP, please ensure you have Service Pack 3 installed. MoneyWorks 7.1 will not run on XP SP2 or earlier.

New features and performance enhancements

• MoneyWorks Now distributed cloud login support (and moneyworks://now/username url scheme extension).
• Datacentre: Encrypted connection option. This can be enabled by supplying an appropriate SSL certificate for the datacentre service.
• Extension to moneyworks URL scheme: moneyworks://ssl/ will connect with SSL.
• Datacentre: Upload local file to server feature (includes the full custom plugins folder with images for the document (it will be merged with any existing custom plugins in the destination server folder, rather than replacing it).
• Datacentre: saving a backup to client is now cancellable and supports larger backup files.
• SetReportColumnWidth function can now be used within a report (within reason) (see Details report).
• Windows Vault password storage—optionally store your server/document passwords in Vault and have them entered automatically.
• Datacentre: “Send logs to support” option for server troubleshooting.
• External(“helper”, …) function allows calling out to external helper programs from MWScript. For security, these must be installed in the Standard plugins/Scripts folder in App Support. Helper executables will not be loaded from Custom plugins.
• Improved the caching performance for loading transactions (and eliminated a spurious log message).
• SetPersistent() function can now be used to delete records by omitting the (last) data parameter.
• Payments History is now considerably faster when used over a high latency network connection.
• Some privilege names (used with the Allowed() function) have changed to make them unique.
• The scripting privilege name changed from “Execute External Scripts” to “Scripting”. Since v7, no privilege is required to execute external scripts; rather external scripts are generally subject to the same privileges as the logged-in user. The “Scripting” privilege controls access to the script editor for writing, activating and deactivating scripts, and also the ability to interrupt a running script or disable script loading at login.
• Statement generation performance has been improved by about 30% when run on a high-latency network connection. Note that statement list search functions should no longer prefix transactions fields by the table name—just use the field name. Using the “transaction.” prefix will suppress the performance optimisations.
• Automatically suppress overly expensive column calculations on high latency connections
• Navigator “exec” code to call mwscript public function
• Added an alert on Windows when printer names are not sufficiently unique (they must be unique in the first 31 characters to be reliably differentiated).
• Datacentre: Recurring transaction creation is now always done on server for improved period-opening performance
• Import via COM now supports xml data
• Job: Replace command now allows replacement of job.ordernum
• Empty moneyworks:// url with no server may now be used to start a new instance without throwing up a “server not found” error.
• Imporintg Jobs. Work-it-out is now supported for xml import of new job code
• Navigator: It is now possible to append panels to the standard navigator by placing them in a “Navigator Extras” folder within the custom plugins folder.
• Singapore GST: New tax code
• Datacentre Console ASP mode usage reporting
• Datacentre Console now allows a start port to be specified for database servers
• Mac 7.1 now built with Clang instead of GCC
• Gold client will now detect “machine is about to sleep” and disconnect from server if possible
• MWXML files are now passed to the first instance of MoneyWorks even multilaunch is on (Windows)
• Scripts can force a refresh of the Navigator using Navigator(“refr”)
• Script access to column names containing symbols now possible (use _ for % in Disc % column)
• Plugin download from server now displays a progress bar (in case connection to server is slow)
• Returning zero from a UserLoggedIn script handler will now reject the user login. This makes it possible to implement script-based access control for users (e.g. time-of-day access control etc).
• Can now import budget job sheet entries
• Datacentre backups of files in subfolders now incorporate the subfolder path in the backup file name to prevent collisions
• Custom text fields may now have autofill/code validation by appending a colon and the table name to validate against to the text label
• Added Malaysia tax rates

Fixes

• Sales Enquiry movements list no longer shows payments on invoices for the customer; just sales.
• Datacentre: searching by colour now uses colour names from preferences.
• Transaction Details report now includes totals by transaction type again.
• Fixed a long standing problem that caused DNS/SD (Bonjour) records to lose some information (this would manifest as enabled user/password fields for servers which did not require them).
• Fixed a crash that could happen in rare cases when adding a new record to a list sorted by a non-indexed field.
• Fixed an “illegal lock extension” error that could happen in Payments History in some circumstances.
• Fixed a cosmetic glitch when turning on/off the Show Typing option for password fields on Mac.
• Disable the Refresh option for report Previews after a network connection is closed.
• Datacentre: ignore control characters in REST requests.
• Fixed crash in SetReportColumnWidth when Use Standard Report Width is turned off
• Fixed privilege testing in number of standard reports
• Search optimiser could choke on public script function calls
• Fixed parsing of adjacent mail merge fields in form text boxes
• Fixed error when adding an item to a build recipe and changing the recipe order
• Fixed Express/Cashbook error in on-the-fly account creation from product entry window
• Fix spurious error when copy/pasting accounts on Windows
• Show log file toolbar command could sometimes crash after a script error in a transaction entry handler
• Fixed overdue creditor invoices warning display Navigator
• Importing a product build now works if the product did no already have “we build it” set (it sets it for you)
• Fixed an issue with custom plugins being downloaded from server too often
• Hitting ‘9’ key in navigator no longer selects the first folder
• PDF generation with non-PDF-std fonts no longer fails if Windows is not installed on C: drive
• Added page break in Cash Forecast
• Fixed a problem with disconnecting idle clients from Datacentre introduced with v7.0
• Mac Datacentre Console ownership/permissions check now more reliable
• Importing new job with work-it-out code now respects Job/Quote/Invoice syncing
• Fixed problems with launching certain external executables on Windows with paths containing spaces
• Product BuyPrice default format if added to list view is now more sensible
• Plain Statement fixed
• Script editor syntax colouring improved when pasting and when comments contain unicode characters
• Importing (unicode) text copied from Excel on Windows now works reliably
• Usage text in Windows CLI
• Datacentre install on Windows now quotes the service executable path
• Fixed Cashbook Windows crash on Find Related Trans -> Name
• Detail report not printing account description (fixed now)
• EC Sales report (UK) showing incorrect country code (fixed now)
• GST report run on server with output = Print was crashing
• Std Balance Sheet report no longer defaults to Include Unposted
• Speech now reliably enabled on Windows
• CLI login with folder and doc password no longer fails where doc password is blank
• Custom transaction format now working again
• Ledger report, description field now word wrapped
• Stock receipt journal was bad if stock received is zero
• Fixed a potential race condition with opening documents on Datacentre
• Importing General Journal transaction no longer evaluates work-it-out for tax
• OrderTotal now updating more reliably when order freight code changed
• Compatibility with flaky MKAbel font that has a visible return character glyph (Mac)
• Fixed a security issue with external scripts
• Enabled validation functionality on Name.Salesperson field
• Transaction.MailingAddress now loads reliably in invoice forms

Bug fixes — January 2014

• Fixed a potential crash when using Analysis reports with long file names
• Fix crash on stocktake list when entering the search box from an active stock count field
• Fix TLS SMTP email on Mavericks
• Fix UK Prompt Payment Discount calculation when there are non-discountable items on an Order
• Fix error when cancelling a transaction from the Bank Reconciliation on a network
• Fix a crash on Windows when turning on Heading Only checkbox for some account types
• Fix a problem with posting the necessary adjustment when a stock item with Append Salesperson on the Cost of Sales passes from negative to positive stock on hand (and also for the write off journal when stock was received ahead of the invoice). For both of these cases, the last department code in the relevant group will be used. If you encounter the situation with any regularity, you may wish to add a department specifically for these adjustments so that they don’t go against a salesperson. Use a code that is alphabetically/lexically the last in the group.

December 2013

• Aged Receivables/Payables: Speed improvement and fixed omit-zero-balances for retrospective case
• Fixed a crash when statement importing window is left empty
• Fixed an accounts setup crash with the Malaysia locale on Cashbook
• Datacentre Console windows are now centred
• Datacentre Console will now check for unrestored session files before allowing an update
• Datacentre REST server SSL mode fixed
• Datacentre log file rotation on Windows now working
• Fixed Caseware export
• Fixed Calculator launching on Windows
• Job Detailed report no longer shows processed PO in the unprocessed list
• Canada Purchase Sales Tax drill down arrows were not drawing on Mac
• Fixed crash in Save a Clone when transaction list open
• Fixed a subtle problem with Backorders: PO processing failed to drop backordered lines if Sales Order option “Include Backordered” is turned on
• Cosmetic fix to news feed on Windows

November 2013

• Critical fix for Datacentre GST/VAT finalisation: repairs mis-finalised GST/VAT on earlier v7 releases
• Aged Receivables/Payables fixes and restored missing functionality
  Sort order fixes (note: to retain list sort order, use the Highlighted Only option)
  Drill down to transactions from aged totals
  Retrospective report for highlighted selection
  Fixed error with manual aging when there are overpayments
• Multi-line text objects in forms on Windows were sometimes clipping final line
• Find by field now preserves a “does not start with” search when invoked again
• Bank Rec Summary list of unposted transactions was not printing correctly
• Software update setup was unstable with extremely verbose long date formats
• Calculation dialog box syntax check error alert Edit button now works correctly
• Calculation dialog box syntax check error alert could crash for very long unknown idents
• Cashflow Report: updated
• Corrections to Datacentre Admin Guide
• Time Sheet Entry: By Resource: Was not including first line in Qty total
• Fix crash on Mac if user disallows access to address book after choosing Import Address Book
• Fixed a problem with printing “posted movements by period” report from Account Enquiry for range
• Fixed Hold checkbox clicking when Transaction window is very small
• News feed in navigator sidebar now showing properly
• Fixed occasional crash on startup during background software update check (Windows)
• Updated Job Detailed report

Stability improvements

• Fixed an issue with taking an unposted transaction off hold in the Bank Reconciliation
• Fixed a problem with the Replace command in the tax rates list (no replaceable fields)
• Selecting currencies with long names had a buffer overflow
• Reports now switch to running on server dynamically as the connection latency varies
• GST report settings are now passed correctly to the server
• Fixed a potential crash when optimising certain images in forms on Windows
• COM/OLE script error reporting now more reliable
• Bank accounts with long account names: buffer overflow in transaction entry
• Fixed rare random crash exiting taxcode column in item transaction on Windows
• Transaction Entry: Copying a product code field on Mac was behaving as if the code had been changed
• Ledger Report: now shows to/from
• Ledger Report settings highlighting tweak
• Better handling of overpaid deposit for non-credit customer orders
• Fixed Mac installer window titles for Express and Cashbook
• Account Enquiry movements printing reinstated as for v6
• Passwords were not working on the 7.0.5 build of Exp/CB

October 2013
As well as an assortment of regressions, this update fixes stability problems being experienced by users on Windows XP that appear to have resulted from our switch to a new development environment on Windows for v7. Our thanks to the affected customers for their help in tracking down these issues.

• Fixed a potential crash on Windows XP when opening certain windows such as Batch Receipts
• Fixed a potential crash on Windows XP when saving records to the databse (this could lock the database for other users)
• Fixed a very rare potential crash on Windows when closing some windows
• No longer re-lookup prices on a transaction line when exiting item field by pressing return (Mac)
• Datacentre: Connections by a full Gold licence will no longer be counted towards the total concurrent connections (regression in v7)
• Datacentre remote save now requires confirmation
• Mac: clicking Help button in alert (where present) could cause a crash
• Fixed a crash on Windows caused by clicking window close box while tracking a popup menu
• Changed icon highlighting strategy on Windows to avoid having the OS make resource pages writeable via an exception
• Added quality assurance feedback facility (This means crash reports are now sent to us, instead of to Microsoft/Apple).
• Serverside reports no longer fail on Mac when the DHCP server provides a bogus non-resolvable hostname such as blah.fritz.box
• Fixed a Mac DC crash when restarting server while database is locked by an incomplete database transaction
• Fixed log rotation
• Fixed a text encoding error in the Contra dialog
• Backorder summary by Product updated
• Backorder Report by Product now supports a selection when running on server
• Aged Receivables updated: shows more overpayment detail and retains sort order when running for highlighted selection (provided that subtotal and by currency options are not being used—those require a new sort order to be imposed)
• Windows: Open Names list is no longer inappropriately activated when a debtor receipt is entered
• Cash Flow report updated: Now supports date range
• Changed the alert presented when about to autobuild a product whose parts are out of stock.
• Restored ability to print details from Batch Creditor Payments.
• Update the Job Detailed report
• Open PDFs in default PDF reader rather than requiring Adobe Reader (Windows)
• Cosmetic fixes to toolbar and search box
• Fix for extraneous lines (actually recurring record definitions) appearing in the messages list
• Running historic GST report on server no longer prevents running current report for the session
• Find-by-field Contains search and Detail search now works properly again
• Fixed reporting of filesystem error after a save
• Clear filter cache when disconnecting from a database
• Don’t show non-message records in messages list after deletion
• Windows now uses default PDF reader to view PDFs instead of Adobe Reader
• Lists now re-execute any current find after deleting a record
• ExchangeListRows() function fixed for long detail lines
• Updated Stock Valuation Report to use base currency for replacement cost
• Context-sensitive help invoked with highlighted text in the script editor, or with a highlighted function in the formula editor will now look up the documentation on the developer page.

30 September 2013

• [critical] Adding new department to a group was still not always creating all the required ledger records
• Fixed a rare random crash on startup (Windows)
• Include unposted in account enquiry could crash
• Importing payments via Applescript was crashing
• Some forms were crashing when opened or printed on Windows
• PDFs generated on Windows with embedded fonts could cause problems with some printers
• Clarified wording on prompt payment discount setting for UK