MoneyWorks

Datacentre client update fix
1 Sept 2017

Apologies, but we have discovered that Datacentre 8.0.7 was delivering a beta Gold 8.0.8 client update for some users.

• Fixed Datacentre client updates

Also:

• Fixed chain reports crash when run on server
• Scripting: Extended the picture object to hold a PDF on Windows

see also: Changes in 8.0.7

Bug fixes and additional scripting functionality
Recommended for all users
30 Aug 2017

Notice for Datacentre clients: We’ve issued a Datacentre 8.0.8 update to address some problems with client updates that were present in Datacentre 8.0.7. If your server is running Datacentre 8.0.7, please ask your server administrator to update it to 8.0.8.

• Fixed Batch/Serial entry from the serial picker (broken in 8.0.6)
• Transaction type toolbar icon width is scaled properly o Windows HiDPI
• Optimised drawing of editable lists (in general, but partcularly helps when carat is being animated on Mac)
• Disable Customise List View in Product Inventory Location list because it is not customisable
• Additional validation of per-user preferences that may have been corrupted on upgrade
• MYOB AO export file modified to pick up the accountant codes for the departmentalised accounts
• Mac alerts will no longer risk a stale disconnect if the server stale client timeout is set to a minute—you shouldn’t do that anyway
• Fixed truncation of overlong unicode input
• Fixed Document Preferences glitch when the previously-set WIP account no longer exists
• Prevent changing or deleting an in-use default WIP account code
• Scripting: Approvedby1 and approvedby2 fields are now script-mutable
• Scripting: Scripts may now mutate UserNum, UserText, TaggedText, ApprovedBy1 and ApprovedBy2 in Posted transactions. Alos, setting values for these fields via WriteCurrentRecordForWindow in the Validate handler will force an After phase and saving of the record even if no other fields have been modified.
• Added serialTrackingEnabled global variable
• Added detailDateColumnEnabled global variable
• Scripting: User entry window overlay now properly sets the width of the window
• Scripting: User entry window now receives ItemHit messages
• Scripting: Fixed parsing of multiple safe paths in the preferences
• Scripting: GetFieldValue now returns the current URL from webview
• Scripting: Fixed an issue with programmatically filling in a serial number from an ExitedCell handler
• Scripting: UserLoggedIn handlers no longer called twice when opening a local document
• Improve login performance for MWNow servers
• Bill Job: job sheet items with zero sell price were not getting correct qty sign
• Transaction Search Box: Now supports detail full text (not just description)
• MWNow handles uploading of new files better when the filename contains punctuation characters
• Product list sell price was not rendering correctly on Datacentre for European number formats
• Fix posting crash with 31 character product codes
• Purging: Count of number of transactions not processed for GST no longer includes orders
• Forms Designer: Fixed wiping of font styles when adding sections
• Forms Designer: Can no longer delete every section in a form (which would crash)
• Replace command now works for Name.Colour
• Fixed stability problems with pasting accounts from clipboard
• Stocktake: When stocktake adjusts serialised stock to zero, the inventory records are now deleted. If you have serial or batch items showing with zero stock, just start and stop a stocktake to get rid of them.
• Scripting: Fixed crash associated with imported images in a picture object
• Transacton Entry: Long tax codes(> 3) are no longer truncated
• Fixed crash when shipping Sales order with locations
• Fixed a resource leak when serverside reporting aborts include unposted
• Can now convert v6 files directly
• Fixed random crashing after importing transactions via import map (8.0.4 bug)
• Deleting contact 1 and/or 2 now clears those contact fields in the Name record

Important bug fixes plus new scripting and analysis functionality
2 Aug 2017

• Critical fix for indexed wildcard searches that can fail in some rare circumstances. This was related to the change to searching that prevents wildcards in data from behaving as wildcards when searching
• Fixed crash when allocating a serial to a job sheet item
• Fixed problem with upload of plugins introduced in Datacentre 8.0.5
• Fix to serial number stocktake with no locations
• Fix conversion of per-user prefs from v7 that was introducing corruption to the new pref value
• Fixed a glitch with list scrolling on Windows when the scale factor is set to 300+%
• Security: Executing an elevated handler in a script: privilege was not getting dropped after exitting the handler
• Mac Window menu now displays all window names again (instead of blank menu items!)
• New scripting handler: URLCallback(window, webviewitemID, url) handler allows your script to examine links that are clicked or redirect urls that are provided by a server
• Overnight autosave time for continuously open databases is now randomly smeared between 23:00 and 23:30 so that busy servers don’t get hammered by simultaneous saves at 23:00
• CURLOPT_POST can now use a read callback (the read callback will be used if a POSTFIELDSIZE and a read handler is supplied but POSTFIELDS are not)
• Analysis reports can now access detail.location, detail.date, and detail.serial
• New long text fields now return the full text when accessed using symbolic name (from script, expression). They were only returning the first 255 characters.
• Scripting: CreateListWindow heading/column definition terminating newline is now optional
• Fixed a potential crash when installing a sleep notification fails (Mac)
• Other product record changes are no longer discarded when a product is being removed from the inventory system by unclicking We Stock It
• Fixed a potential crash when sending email via MAPI on Windows (email recipient list parser)
• Fixed a potential crash when using the escape key to close a window that has changes to be saved (Windows)
• Fixed a potential crash when the server fails to provide preference information to e client (blob loading)
• Fixed potential crash when the product entry window posts a locked.single user alert when opened
• Scripting: ExitedField handlers that invoke UI will no longer cause a recursive call to ExitedField on the same field
• Scripting: Fixed a potential crash when ValidateField handlers invoke UI
• Progress window no longer causes an ExitedField on the underlying window
• Added ExpectedLife field to AssetCat table
• Group field in AssetCat table is now 7 chars

Improvements to stock location system and lots of bug fixes
17 July 2017

• Fixed random resetting of some app preferences on Windows
• Stock by location: Product Inventory tab now displays quantities by location (including the default location)
   
  
• Inventory Batch Chooser now adjusts display batch SOH by the batch quantity already allocated on the sale to prevent accidental allocation of the same batch twice
• Stock By Location report added option to show values
• Fixed SOH display for current location for sales order on Datacentre
• Product entry screen now updates SOH live without having to reopen the product window
• Changes to support the lack of lexical ordering of directories in the upcoming new APFS file system in macOS High Sierra
• Improve Avoid Weekends behaviour for recurring transactions
• Fixed truncation of long Job customer order numbers
• Updated Statement of cash flow report
• Removed a spurious error log entry when control characters are cleaned from fields during transmogrification
• Product entry window resource leak fixed
• Product entry window BOM totals now displayed correctly
• Product entry window intermittent crash on open fixed
• Product entry now remebers preferred tab even if you close by cancelling or close box
• No longer try to print invoice when processing of order is cancelled
• Process Order dialog cosmetic fix (truncated text on Mac)
• Fixed CLI crash when opening a moneyworks://now URL that contains a document anme that does not exist on the server
• Fixed potential crash when a remote Save is requested while the current field requires validation against the database
• Fixed Preview window occasionally failing to display on Mac
• Fixed intermittent failure of some intrinsic functions (such as GetBalance) in serverside reports
• Cosmetic navigator fix (Windows)
• Cosmetic Job entry fix (visibility of “%” label next to Billing not always correct)
• Fixed crash when executing serverside transaction import involving an invoice “recall”
• Fixed cursor adjustment issues making mouse tracking flaky on some UI elements on Sierra
• Build Serialised Item: Journal now posts if one of the items is not inventoried
• Fix potential server crash when deleting all line items from an order
• Import() function with XML input was not returning an error properly when the import ran on the server
• Fixed server crash when attempting to delete a category
• Improvements to MWNow upload whitelist filtering
• Changed message for opening a new period when entering a transaction and max periods are open
• Fixed a buffer overflow crash in the Plain statement
• Duplicating a product with per-location stock no longer temporarily displays the source product location stock holdings
• Buffer overflow prevention on location store
• GetPersistent() function now provides sequence number and last modified time
• Fixed potential crash when atempting to access non-existent files (Mac)
• Edit Custom Validation for stock location no longer leaves a spurious edit field behind
• GetListHandle(): Restores the NULL-return behaviour when called for in unselected tab name in transaction entry window

22 June 2017

Performance improvements and bug fixes

CB/Express 8.0.4r1, Gold/Datacentre 8.0.4r2

• Fixed a problem introduced in 8.0.4 with (among other things) selecting invoices for payment on Windows
• Fixed a modality problem on Mac when a Form calls a time-consuming public script handler
• Implemented Check for Duplicates for Sales Orders

8.0.4

• Bank statement importing was not marking default (no rule applied) items as such
• Stock Reorder is now much faster (especially when running on a network, but also in single user) and is also stoppable
• Stocktake for batches now behaves properly when adding a new batch or serial in the stocktake
• Scripting: Fixed the specific handler name for the Serial/Batch column
• Stocktake commit is now transactioned again
• Serial/Batch Picker: No longer omits an already allocated batch number that is still available at another location. This does mean that (for now) the allocated batch quantity will also still be able for picking even if the quantity has been fully allocated on the current sale. We plan to address this in the next update.
• Made the Replace/Advanced Replace commands slightly faster when running over a network
• Fixed a resource leak in stocktake finalise
• Stocktake now runs progressively on the server, so it is much faster than v7, but it will not lock up a slow server either (which the original implementation in 8.0 could do)
• ABN is set to not be imported in the default transaction import map
• Added detail usernum/usertext to the std export format
• Allow import into detail usernum/usertext
• Scripted coach tips (using the Navigator function) are now instantiated asynchronously, so that if you display a lot of them, you won’t bog down the system window manager (excess ones will be discarded)
• AppendPopupItems function now supports "#PER" to automatically populate period a custom popup menu with names. You can get the actual period number the popup is set to by using GetFieldValue(w, item, true) i.e. optional third parameter requests period number decoding. You can set the value with SetFieldValue(w, item, PeriodName(pernum))
• Fixed an off-by-one affecting field length limiting for some fields on Windows
• Category field in the Login table now properly allows 31 characters (was truncating to 7 or 8)
• Reinstated the missing Sell column in the BOM editor
• Fixed a typo in the Committed Stock report that threw a spurious script error
• BOM editing was not forcing a save if you added an item but changed nothing else in the product
• Scripting: Cell event handlers now called with correct list specific name in Transaction overlays
• Replace with colour fields now works with “None”
• Auto allocations rules now allow several decimal places for percentage and amount splits
• Report Writer now warns about incorrect usage of TableGet function that would lead to severe performance degredation in a report
• Reports/Scripts: For-loop textfile reading line length limit improved
• Scripting: ImportImage() function was not working with a server
• Increased maximum number of recurring transactions that will be processed in one go
• COM ImportText/ImportFile no longer spuriously returning false. Now spuriously returns true again, for external scripts that care
• CVE-2017-9615 Verbose logging mode on the server no longer logs REST request passwords
• Zero contras on transfer journals are no longer omitted (this line is required to record the nominated contra account should it be needed)
• SSL Certificate expiry dates now displayed in ISO format to avoid ambiguity when the server is in a country with an illogical date format
• Fix a potential crash in the form printing list search optimiser
• Fix a potential crash activating Preview window on Mac
• Windows Datacentre installer adds firewall rules to allow server components to communicate with each other when Mordac has set the firewall to 11
• Tweaked some Cocoa for compatibility with upcoming macOS release (10.13)

1 June 2017

See the v8.0 release notes for new features in v8.

Performance enhancements and bug fixes

• Datacentre: Sum Selection on Sales Orders — fixed (GetTaxRate function was unavailable on the server—long story)
• Datacentre: Serverside reporting now works for users who have an @ in their username
• Mac: Reinstated filtering of illegal characters in tax code creation (* and + must not be used in tax codes).
• Datacentre: The Import() function now returns the last sequence number when the import runs on the server
• ReplaceField function return value now accurately reflects the number of records affected (so can be used to detect a replace failure due to record locking).
• Fixed the tab order of address fields in the Name entry window
• CLI: fixed the -r option (was not working on Mac)
• Drilling down to a product—a relookup of product pricing is no longer forced after merely changing the history view in the product window
• Express/Cashbook: Some icons were missing (e.g. the Printed icon in the transaction list)
• Since more and more Datacentre users are giving their accountant an Internet login, we’ve rewritten the MYOB AO accountant export format to run on the server to make it orders of magnitude faster
• Same for Caseware (Solution 6 not yet optimised—does anyone even use it any more?)
• External accountant export formats are now available for all localisations
• Scripting: AutoFillField() function can now be used for an editable list cell
• Scripting: CheckCodeField() and CheckAccDeptCodeField() functions can now be used for an editable list cell
• XML import: fixed stripping of returns from transaction mailing/delivery addresses and others
• Scripting: DoReport() to “text” on Windows client connected to Datacentre was inappropriately presenting a Save dialog for the resulting file instead of just writing it to a temp file
• Windows sticky notes now come up on top of modal windows (when the list window is maximised)
• FieldLabel() function now returns blank for a zero Payment Method

8.0.2r2 22 May 2017

See the v8.0 release notes for new features in v8.

bug fixes

• 8.0.2r2 Gold/DC: Fixed Accountant Export formats with Accountant’s Code (broken due to changed master export format)
• 8.0.2r1: Fixed Accountant Export formats (broken due to changed master export format)
• 8.0.2r1: Fixed display of certain integer fields when rendered on the server (e.g. Debtor Terms)
• 8.0.2r1: Fixed display of “This Payment” column on Windows (was crashing into the scroll bar)

---

• Prevent creation of an illegal account code (account codes must not contain hyphens—hyphens are for separating account codes from department codes).
• Custom validations for new transaction fields were getting mixed up with validations for existing fields – fixed
• Datacentre: Fixed failure when details records deleted while running a report
• Gold: Stock transfer journals now balance properly on entry (previously they were corrected at posting time).
• Scripting: Right-click on pictures in custom windows now works on Windows
• Scripting: New sequence number is now available to scripts for a Duplicate records as well as New records
• Scripting: Fixed crash on exit detail cell when a script opens a new window with a sticky note open
• Scripting: SeFieldvalue: Now works for icon buttons like Post and Print in transaction entry
• Datacentre: Running an Analysis report on the server for opening in Excel now works
• Forms printing: unicode characters such as Ø were causing adjacent character to be omitted
• Datacentre: Committing stocktake could time out on a slow server (fast stocktake commit will be re-enabled in a future update).
• Scripting: The USRTEXT fields in the transaction entry window is no longer superimposed on the other user fields
• Scripting: File_Move function now replaces existing destination rather than giving an error
• Datacentre: Eliminate some spurious logging from the Backup process
• Scripting: Fixed a potential crash in the Ask() function when given bad parameters
• Gold: Prevent invalid combination of Count/Stock settings.

See the v8.0 release notes for new features in v8.

As is tradition, the big upgrade gets the usual flurry of little fixes. This list includes bug fixes from 8.0r1-r4 as well as fresh and important fixes for 8.0.1.

Important bug fixes

• Fix loss of precision when storing and converting unit conversion multipliers for stock from v7
   
  If you buy and sell stock in different units, and converted your data file using 8.0 prior to 8.0.1, please check your Unit Conversion values. Some values may have introduced some rounding error (the unit conversion factor you enter to convert buy units to sell units is actually stored as a reciprocal, and the new database format was initially storing this with insufficient precision. From v8.0.1 more precision is used for this value)
• Fix exporting of very small and very large numbers to XML
• Fix issues with corruption of user settings on Datacentre
• Fix display of disabled Next/OK buttons on Windows
• Remember preferred stocktake control account on Datacentre
• Fix failure to syntax colour scripts in script editor
• Remove a spurious error code form being logged on conversion
• Enable Itemhit script handlers for entry windows
• Script Webviews: don’t try to open about:blank URLs externally
• Fix file conversion on Windows (not converting the infinity for A tax code) (r4)
• Fix Cashbook -192 error
• Fix Bank transfer crash with long reference fields
• Period Management: New button now remains enabled and advises when periods need to be closed
• Fix Cashbook and Express file conversion not recognising password after conversion
• Fix Item picture not refreshing on resize (Windows)
• Fix cosmetic glitch in Product Entry Window on Windows after resize
• Fix crash in receipt with writeoff on Windows
• Fix failure to represent infinities in the database. This would reset any “All” tax rates to 0%. Please use the Tax Rates command to correct your “All” tax rate if you have one.
• Windows Cashbook/Express installers: Set correct browser control compatibility version in registry to get standards-compliant rendering in manual viewer
• Add missing Location toolbar icon on Windows stocktake
• Fix and per se & issues on Windows File menu for the benfit of Windows 7
• Fix calculated stocktake columns not displaying properly on Datacentre; also fix formatting of snapshot column.
• Fixed setting initial count on newly created counted product.