MoneyWorks

20 Sept 2022

additional fixes for 9.1r2 supplementary update at end

• Date Picker

By popular request, date fields now feature a pop-up calendar date picker. This allows dates to be typed normally (and the calendar will reflect what you type), or you can click a date to enter it into the field. Note: You can enable or disable the date picker in the MoneyWorks Preferences → General tab.

Mac		Windows

• On Windows, there is now an option in the Window menu to “Always open windows on main screen”, which is on by default. If you want modal and floating window positions on different monitors to be remembered, you will need to turn this option off
• Tax numbers for different locales can now be specified in the setup part of the respective Guide form
• VAT Guide UK: Fixed to correctly include EU/Northern Ireland Purchases
• Tax by Currency report now checks for missing tax numbers
• Build Product now supports BOMs that use serial- or batch-tracked parts and/or create serial- or batch-tracked built products. The BOM is expanded to allow all serial numbers to be specified prior to creating the build journal
• Serial-tracked parts can’t be added to a BOM for an auto-built product. Turn off auto-build to add serial-tracked parts
• Tax by Currency report now handles overpayment refunds
• Customer payment method is now available for non-Debtors
• MacOS Ventura compatibility for speech output
• Account list was incorrectly showing the tax code column when initially displayed for documents where GST/VAT processing was turned off
• Entering a date as only m/d when the system date format is middle-endian-with-alpha-month-names now works as (presumably) expected
• Fixed a problem with drag & drop recognising .qbo files on Mac
• Fixed a rounding issue with 50/50 split rules in bank statement import
• Changing the Name code on a cash transaction imported from a bank statement will preserve the gross value of the transaction if the tax code changes as a result
• Fixed multi-user concurrency issue with modifying the same filter rule simultaneously
• Fixed high CPU usage in background when a coachtip or tooltip is scheduled to appear
• Fixed memory leak when traversing APFS folders
• Removed some spurious diagnostic log messages
• Asset Report: Highlighted Only option now works correctly
• Asset Register Report: Show correct bookvalue for asset purchased on last day of period
• Asset Register Report: Fix acquisition quantity
• Bank Balance report: Reinstated grand total
• Added diagnostic mode to the SMTP preferences. Hold down the shift key when clicking Test to get a full log of the SMTP test session
• Fixed address book import and email autocomplete on macOS versions later than High Sierra
• Fixed SMTP emailing to multiple addresses for a role
• Fixed incorrect cursor for certain drag operations
• Fixed pinch zoom direction in Preview (Windows)
• Enabled pinch zoom in Forms Designer
• The Exclude Zero Qty Lines option in Product History no longer erroneously applies to Pending view
• Fixed update issues in Analysis editor
• Timesheet Location field is now reliably validated
• Detailed Stock Report: Add Highlighted Only option
• In future, Software Update on Mac will quit other instances of MoneyWorks for you. This is to prevent mysterious file system errors that can be experienced by a process whose executable has been replaced with a new version
• Trial Balance Report: Option to show closing balances only
• Stock History Report: Currency conversion issue with negative creditor invoices
• Add Path button in the Scripting Preferences to select a folder to add
• Fixed incorrect Accounts List toolbar when GST processing is turned off in document
• Fix to Cash Projection report
• Updated calendar holidays
• Asset Register: Allow revaluation of Non Disposable Assets

Server

• Addressed restart/recovery race condition on server
• Ventura compatibility: Updating Datacentre on macOS Ventura and later launches the GUI installer app to complete the update install
• Mac Datacentre Console no longer auto-installs/updates MoneyWorks Gold on the server. If Gold is installed on the server, just connect to the server to update it
• Datacentre Console now gathers Mac crash logs when necessary
• Fixed Datacentre installation failure on virgin Monterey OS (not upgraded from previous OS version)
• Fixed potential server deadlock after certain SSL connection failures
• Other stability fixes
• Remove excessive logging for syntax errors in users’ custom column expressions
• Updated paths for jpegoptim and ghostscript for serverside image recompression

Scripting and Automation

• Adopt WKWebView for embedded web views on Mac; this provides script-based webviews with access to latest WebKit and Nitro Javascript. See New web views in MoneyWorks 9.1 and later for more information
• Adopt WebView2 for embedded web views on Windows (where installed); this provides script-based webviews with access to the Chromium/Edge browser engine instead of the IE11 browser offered by IWebBrowser2. See New web views in MoneyWorks 9.1 and later
• Using the new web views, you can now call out to MWScript from Javascript in a web view’s content. You can also inject javascript into a Web view’s content from MWScript. See Communicating with Javascript in a Web View
• Fixed assignment to window bounds properties
• Fixed crash with extremely long array keys
• Fixed potential crash when SetFieldValue is used in bulk and results in a progress dialog
• Improved REST error reporting
• Added Regex_SearchStr returns the first matched substring or empty string if no match
• Added Regex_GetMatches returns an array of tokens matched by parenthesised subexpressions in the regular expression
• Improved regex error reporting
• Reduced threshold of regex_complexity error on Windows
• HexDecode no longer enforces output being valid utf-8. This is to facilitate re-encoding binary data such as the output of HMAC as Base64
• GetWindowProperty now returns NULL if the property is not found, rather than throwing a runtime error
• LoadPicture now displays “PDF” on Window when a PDF was loaded from the server (Windows cannot display PDFs)
• Timestamp() added TSF_Unix, TSF_Unix_ms, and TSF_Unix_us formats for Unix epoch decimal timestamps
• Timestamp() format parameter may now be a strftime format string
• DateToText() format parameter may now be a strftime format string
• Added ModalTransactionWindow function to invoke a standard transaction entry window modally
• Added CreateFolder to create a folder
• Added AddSafePath function to invoke the preferences for user to add a safe path
• Implementing the same handler name twice (where the first implementation has a non-empty handler body) is now flagged as an error when you do an explicit compile in the Script Editor. In order to not break existing scripts that might have this issue, this error does not prevent existing scripts from compiling at load time. The script will need to be fixed (by removing the earlier extraneous handler definition) when it is modified in the Script Editor
• Fixed potential crash when SetFieldValue is used in bulk and results in a progress dialog
• Built_In:__SendSMTPMail now has the option to add multiple attachments by passing an array of paths instead of a single path string

9.1r2 — 4 Oct 2022

General

• Fixed randomly auto-cancelled Print command on Windows
• Increased network timeout for Open New Period to better accommodate very very very very large charts of accounts

Scripting

• Fixed and intermittent crash when closing custom script windows

9.1r1 — 30 Sept 2022

General

• Fixed a Daylight Saving glitch in the Mac date picker affecting timezones more than 12 hours ahead of UTC
• Fixed crash when attempting to output a report or form on Windows when there are no printer devices available
• Navigator panel will now reload if you drill down to overdue debtor or creditor invoices
• Fixed a resource leak in the Edit Filters command

Scripting

• Fixed crash when putting up a print spool dialog from a PostedTransactions handler on Windows (although doing this kind of thing from a PostedTransactions handler is absolutely not recommended)
• Fixed the “open links in external browser” option for WebViews on Windows
• DoForm() function with non-existent form no longer produces an empty PDF file. The output path will now begin with “[ERROR]”. You should test for this rather than assuming that the path identifies a valid PDF output file
• The Mail() function will fail with an alert if the attachment path begins with the text “[ERROR]”

27 June 2022

9.0.9r2

• Fixed failure to import small XML files on high-latency network connection
• F5 Report: Was incorrectly calculating Box 3 (Singapore)
• Detailed Stock Listing Report
• Fixed crash with open(1) with a moneyworks:// scheme url identifying a server folder (Mac)
• Bank Balance Report: Resolved rounding issue with large Forex balances
• Fixed initial Account list column format when GST/VAT processing is disabled for the document
• Print setup dialogs are scriptable

9.0.9r1

• Fixed a problem in the search optimiser in 9.0.9 that broke some date searches in reports
• Fixed a 9.0.9 crash in the MWScript Ask() function

• Import with update product/name control accounts was broken in 9.0.8
• Stocktake list report
• Bill of Materials Costing Report: Sometimes used buy price instead of average unit value
• Asset Register: Fixed depreciation of assets in period of purchase if purchased on last day of period
• Asset Register: Fixed issue with departmentalised asset disposal account
• Parsing of Yodlee data is much faster
• Fixed opening PDF files (manual/tutorial) on Monterey 12.3
• Importing transactions: Transaction.promptPaymentDisc % field is now set as a side effect of setting promptPaymentAmt via work-it-out
• Option to autobuild out-of-stock BOM products when requisitioning for a job (see the Job Costing Preferences panel to turn on this option)
• Fixed Windows save file dialog sometimes not showing the locations sidebar
• Simultaneous Process+Print of SO by two different users could result in both invoices being printed by one of the users
• MoneyWorks for Windows is now built against the Windows SDK v143 from Microsoft. This SDK does not support Windows 8.0 (it does support Windows 7). If for some reason you are still running Windows 8.0, please update to the Microsoft-supported “Windows 8.1 Update”, or, preferably, Windows 10
• Fixed Stock Enquiry Sum Selection for Pending Purchase Orders incorrect results
• Fixed crash with Aged Debtors invoked from 64-bit Gold client on Windows when connected to a server
• Addressed modal and floating window positioning issues on Windows with multiple monitors
• Detail.Account work-it-out when importing a purchase of a stock item for a job, will now insert the expense account instead of the stock account for the item (the same as you get when manually entering such a purchase)
• Plugin zipping will no longer add ._ files from Mac file shares on Windows
• Fixed a potential crash in the Lookup() function
• Added sign setting for CSV statement importing
• Improve traversal of “notwork security” packet inspection proxies for software updates and web services on Windows

• REST read-only polling when file is not otherwise in use could result in the latest backup being removed
• Fixed potential deadlock during dropped-connection recovery
• Windows Console software update browser now supports modern CSS
• IP blocklist facility to drop unwanted connections by IP range
• Default blocking of egregious portscanners
• Fixed incorrectly formed Recent Items link after logging into a non-ASP Datacentre with an email address as a username
• Small data imports (<2K) will no longer run on the server (prevent extreme server load from iBodyShop)
• Searching for timestamps now works reliably when the server’s service locale does not use d/m/y date format

• New JSON parser (500x faster)
• JSON_Parse correctly interprets \uXXXX where XXXX is non-ASCII UTF16 (9.0.8 only fixed this on Mac; Now works on Windows)
• Fixed formatting of very large integers (such as JSON numeric IDs)
• Leaked object handles are now logged when a script is unloaded
• UpdateOrderLines allows linking to unposted invoice
• UpdateOrderLines now clears the order’s ShipQty in invSeq linking mode
• SetProgressMessage is now per-script
• foreach loop bounds range may now be larger (64 bit long long int instead of 32 bit)
• foreach loop bounds generates an error when out of long long range
• spurious “overriding intrinsic” warning is no longer given for ‘uses’ statements
• Runtime errors no longer auto-unload the offending script (9.0.8 change). As well as a potential circumvention of business rules, this was causing additional instability even after recompiling the script—in particular window handles would not be passed as parameters
• CURLOPT_CERTINFO/CURLINFO_CERTINFO to capture and retrieve full certificate dump from a TLS connection
• Loading external script packages with LoadScriptFile is now logged
• ItemHit handlers for editable list cells may now have more detailed specific naming (down to the column name of the active cell) and will receive additional parameters (namely the list handle, the current row number, and the current column number). e.g. on ItemHit:F_TRANS:L_LIST:DI:Location(winRef, listId, listHdl, rownum, colnum) for an ItemHit handler that responds only to kepresses in the location column of Debtor Invoices. Note that for the transaction entry form, you must supply the type specifier. Note also that due to backwards compatibility, the list is identified by its underlying identifier L_LIST rather than a tab name like By_Item. This does have the benefit that you can respond to, eg, the job column in either the By_Item or By_Account tabs using the same specific handler
• Fixed display of popup idents in the UI editor
• Fixed the ModalListWindow() function on Windows which incorrectly instantiated an MDI window instead of a top level window, resulting in UI lockup
• The Alert function now recognises an empty string button name as “no button” on Windows for the second and third buttons. You can also use NULL if you need to pass all button parameters to specify the timeout parameter
• Curl_Exec on Windows will add CURLSSLOPT_REVOKE_BEST_EFFORT | CURLSSLOPT_AUTO_CLIENT_CERT options to curl requests by default. Without these, packet inspection proxies will typically not be traversed. If you do not want this security downgrade on your client, you can set the strictRevocationCheckinginCURL registry key in the MoneyWorks Preferences to 1

22 Mar 2022

• Fixed issues with 9.0.7 BAS Guide (spurious zeroes on box G11, box G1 not including GST Free Sales)
• Support for mapping tax codes to foreign tax guide codes. See Paying GST/VAT in Multiple Countries
• Available Shopify support
• Available BigCommerce support
• Available WooCommerce support
• Product Sales Enquiry: Fixed various cosmetic issues
• Product Sales Enquiry: Fixed various cosmetic issues
• Product History: option to exclude zero qty lines
• Customer Sales Enquiry: unposted setting is respected in movements list
• Product Sales Enquiry: support include unposted on network
• Email subject lines can now be pinned and stored for re-use
• Save a Copy as Clone: Now includes asset categories
• Pre-installed holidays now work on APFS and Windows
• Stock transfer journals now auto-split lines to streamline entering serial numbers for created stock
• Credit notes now respect quantity price breaks
• Age by Due Date Report now omits cancellations
• Autocomplete email addresses is now less aggressive
• Prepayment deposit lines no longer omit tax codes when the deposit control account includes a department
• Importing Job Sheet items – the type (IN/EX) may now be explicitly specified instead of relying solely on the sign
• A negative stock purchase (return) with a discount no longer generates a spurious stock/cogs adjustment
• When updating MoneyWorks, the std scripts are now replaced rather than merged. Don’t keep your own scripts in the std scripts folder
• Fixed potential double & in Asset Category code popup on Windows
• MoneyWorks will now post warning messages when document size approaches the maximum size (4GB)
• Fixed a random crash on startup related to progress dialogs and software update check
• Period numbers can be shown in the Period Maintenance dialog (hold down the Shift key)
• Name.WebURL was allowing too many characters to be entered (field size is 63 chars)
• Fixed some pixel alignment issues in budget spreadsheet window
• Unposted cash transaction stock movements now show in Stock Enquiry with Include Unposted
• Product importing no longer spuriously sets multiple price flag when updating existing products
• More informative progress messages on clients when retrieving data from the server
• Bank feeds: Yodlee Fastlink 4 — Localised default banks for New Zealand
• Fixed software update download progress display when downloading manual
• Fixed software update temp files being left behind
• Statement importing: Coding a transaction to the same bank the statement is for is now flagged as an error

• Allow scripts to use intrinsic function/global names as handler/local var names. In this case the local identifier will hide the global one. The declaration will be coloured purple by the syntax colouriser
• RemoveLeading and RemoveTrailing functions to truncate the beginning or end of a string
• GetFieldValue on a period popup: pass true as third parameter to decode to period number
• UI editor: popup control idents and z-order now redraw properly
• UI editor: fix crash on Monterey when showing idents
• Script editor: autocomplete window was not wide enough on Monterey
• UI editor: prevent resizing objects to a negative dimension
• UI editor: tab control selection frame+resize handle now show on Windows
• UI editor: popup control selection frame+resize handle now shows properly on Mac
• Installing scripts from .mwxml: better progress logging
• Navigator() function may now be used from PostedTransactions handler (it executes asynchronously)
• Fixed double & in popup menu controls on Windows
• Removed unintended 32K length limit on concat and syslog functions
• AppendPopupItems now interprets ( item prefix as disable this item (per documentation)
• Fixed Mac script editor not deactivating when in background
• Fixed potential crash if a script is called from a custom list column
• JSON_Parse now correctly interprets \uXXXX where XXXX is non-ASCII UTF16 (update: this only got fixed on Mac; Windows fix coming in 9.0.9)

• In ASP mode, the server now logs any folder login attempt
• enableReconnections was not being maintained properly in the conf file
• HTTP GET on the DC port now gives a 418 error
• Console now flushes folder settings on exit field (in addition to changing list selection)
• Correct reporting of certain REST request errors as 4xx or 5xx as appropriate
• Changed the config variable name for verbose logging so that it gets turned off when updating. Do not turn it on verbose logging unless Cognito support asks you to

Performance enhancements and bug fixes

16 Dec

• Fix SMTP on Windows (the built-in SMTP MWScript was not being loaded due to being installed with an incorrect file extension)
• Importing payments on invoices: performance improvement
• Importing payments on invoices: fixed potential crash with unbalanced payments
• Export XML performance improvement
• Import progress window was not displaying progress on Mac
• Canada GST report no longer showing for all locales
• Datacentre/Console now times out if a database server becomes unresponsive
• Budget importing now tolerates blank lines in the input
• Fixed manpage installation on Mac

Mostly bug fixes

7 Dec

• Print from Preview (Mac) was being vertically offset on the page. This has been fixed, but if you normally Print from Preview, you may have adjusted your forms to account for this vertical offset. If so, you may need to adjust them back.
• Fixed a number of issues introduced by the switch to the new Scintilla text editing framework on Mac…
• Script Editor (Mac) performance issue syntax colouring XML fixed
• Script Editor (Mac) high CPU usage fixed
• Script Editor (Mac) fixed MWScript syntax colouring missing the final token after using html/xml/json syntax colouring lexer
• Script Editor (Mac) for Report custom control was not active
• Fixed Report-to-Excel only working half the time (Mac)
• Bank Reconciliation Status Report: performance optimisation
• Datacentre: Stale-disconnect time may no longer be less than 5 minutes
• Datacentre: Rate-limit for reconnect attempts to give more time for the network to come back up if it has gone down
• Fixed Yodlee account linking error when there are not yet any linked accounts
• Fixed a stack overflow crash in the in-field expression evaluation when the expression is very long
• Stock History report: corrected handling of revaluations and negative stock
• Copy Records as XML command is now in the contextual menu (Gold)
• Correct handling of UK VAT Flat Rate scheme submissions using MTD

Previously included in 9.0.5r1 DC

• Fixed Tax rates dialog being read-only on a server in 9.0.5
• Fixed high CPU usage in the import dialog (Mac)
• Cosmetic fix to edit list column resize on Mac
• Scripted clipboard access (GetClipboardText and PutClipboardText)
• Fixed potential crash on server shutdown (mainly on Windows)