MoneyWorks Gold Changelog

What's new in MoneyWorks Gold 8.0.3

Jun 8, 2017

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

New in MoneyWorks Gold 7.3.4r1 (Nov 30, 2015)

New in MoneyWorks Gold 7.3.4 (Nov 30, 2015)

Server logging now logs client connections and disconnections even when verbose logging is off.
Fixed crash in report interpreter accessing a malformed table (with fewer header columns than data columns—prepending a truncated header row to a table may now result iin the table data also being truncated).
Script for-loop reading a text file now automatically transcodes MacRoman/WinLatin input to UTF-8.
Datacentre nightly save will now do a backup if no backup has been done within 2 hours.
A datacentre database server will now stay alive if it is getting constant connections and disconnections at a frequency higher than its idle close interval. This should result in better service for very active REST clients overnight.
Post an informative alert for users who attempt to use a version 5 or 6 serial number in a version 7 product.
Updating double precision floating point fields using single pass import (inc XML import) now works.
Fixed potential crash in xmldump export through network client.
Added Log10(), Log2(), and LogN() functions: for Sarah.
Fixed crash in Composite Tax rate entry (introduced with 7.3.3).
Bank Rec: Load Old — Finalised Date formatting.
Fixed crash loading corrupted form documents.
Fixed unlikely but potential crash when closing windows.
Fixed line height of session restore list on Hi-DPI Windows displays.
Can now change the Regional number format while MoneyWorks is running and the new format will be picked up.
MWScript Close message is less fragile (no longer sent with torn down window).
Added 4 static text fields to transaction entry window for use by user scripts (T_USRTEXT1 – T_USRTEXT4).
Datacentre console is now lipo’d by installer on Snow Leopard.
Bill of Materials: Allow more than four decimal places for components.
Mouse tracking in a list when a software update dialog pops up is no longer fatal.
Corrected enabling of some forms editor commands when a text item is active (Cocoa).
Fixed DisplaySelection function view selection flakiness.
Added correct help text to Standard Commission Report.
Bank Reconciliaiton finalisation on Cocoa was unreliable.
Server-side include unposted and payments history now work properly when server locale has comma decimal separator.
Fixed arrow key crash in Welcome screen when recents hidden.
Non-journal reversing recurring transaction had wrong sign for TaxAmount field.
Fixed a crasher when editing multiple custom forms simultaneously on Windows with more than one list item active.

New in MoneyWorks Gold 7.3.3 (Nov 11, 2015)

Changes to font selection on Mac — The font selection dialog box now lists all font variations rather than just font family names. The font names used may differ slightly from the legacy Quickdraw family names. In general, forms using the old font names will continue to work. Some font names selected with the new system may not work in older versions of MoneyWorks that expect Quickdraw names. Also, due to the need to support both old and new font names, it is no long feasible to post a warning when fonts used in a form are not installed (MoneyWorks will rely on the OS to perform font substitution in most cases).
Workaround for antivirus software causing permission error on open.
Fixed crash after selecting long report path names in Window menu. (Cocoa)
Improve network idle timeout alert behaviour.
Fixed potential crash instantiating a list window with a bad sort column.
Fixed potential crash mousing over preview windows on Windows
Import Maps: Dragging fields in Cocoa version now swaps fields as expected.
Cut/Copy/Paste menu items now enabled in Cocoa Save dialog.
Fixed potential crash in Forms designer when drawing object handles.
MWScript Arrays now support more than 32767 members.
Fix potential crash when deleting detail line from contextual menu.
Changing SMTP “Use Authentication” setting now recognised when “Test” button used immediately afterwards.
Fixed potential crash when closing document or connection due to sleep/network idle (Cocoa).
Fixed crash when importing xml with update=’true’ and record is open.
Fix excessive leading in wordwrapped form text boxes on Mac with fonts that include leading in the font metrics.
Fix cut/copy/paste in logo dialog on Mac (PNG and JPEG clipboard formats now supported, as well as PDF).
Improved Windows error reporting.
Fixed incorrect menu enabling in Forms Designer on Cocoa version.
Corrected formatting of time fields in Gold server.
Fix activation of detail line code field after changing custom validation.
Make margins visible when tax is turned off in Preferences.
Properly disable transaction type popup when modifying an existing transaction.
Hide Tax drilldown arrow when tax is turned off (North America).
Fix custom transaction formats in Analysis reports.
Fixed default file name for saving reports/forms on Mac, and full paths in Window menu.
Fix premature loss of connection on Mac when alert is left up.
Clear dock icon badge when decline to re-login after Revert.
Fix naming of Datacentre backups made after 11pm.
Transaction address fields needed one more vertical pixel on Mac for 10.11.
Keep detail line field active after cancelling Custom Validation dialog.
Fixed buffer overflow in lexical analyser when parsing overly long field names.
Fixed heap corruption in TableAccumulate when called with fewer column values than the table dimension.
Getting and Setting future budgets by date was off by one period if date is last day of month.
Use monospaced digits for system font on El Capitan in text entry fields.
Fixed issues with file extension when exporting electronic payments files.
Fixed extrananeous NUL character on Windows printing to clipboard and Electronic Payment export via report.
Fixed Finalise dialog activation when previewing GST report (Cocoa).
Fixed toolbar activation when previewing report from report edito.
Allow a greater range of leading adjustment in the forms designer.
Malaysian GST-03 Guide: tweak for terminology issue.

New in MoneyWorks Gold 7.3.2 (Oct 28, 2015)

Fixed potential Windows Gold server crash when multiple network clients are doing full text search.
Detail line right click menus now have proper options.
Report writer toolbar now reponds properly after a Save As.
Escape key no longer cancels a report on Windows when MoneyWorks is in the background.
Fixed font selection on Mac which failed for certain font names with various knock-on problems.
Abbrev Date format now enabled in Forms Designer (Mac).
Navigator: Tweak to Daily Summary.
Force monospaced digits in El Capitan system font.
Fixed crash with incorrect MWScript construct: Foreach x in X where CreateSelection(“Y”…
Report output to Clipboard had incorrect text encoding.
GetUIField() function was AWOL from 7.3
Fixed issues with image importing by right click.
Mac Cashbook should not have Export Selection menu command.
Option Paste to import on Mac Cashbook was broken
Fixed “bad process mode” if hit ⌘-K in a Quote.
Fixed crash when changing transaction type after selecting an order processing mode.
Tax breakdown drilldown icon for sales taxes was missing (Cocoa).
Key remapping now working (Cocoa).
Auto client shutdown on Sleep should now be more reliable.
Restored extra App Preferences menu item in Edit menu on Express and Cashbook (Cocoa).
Fixed potential crash and printing weirdness in Preview (Cocoa).
List handle for “Payment on Invoice” is now usable.
Fixed spurious 7.3.1 Currency error when importing products.
Start at Label dialog: cross and tick icons were missing on Cocoa.
Some tab names were not correct on 64 bit version (especially for Cashbook, Express, and VAT countries).
Better wait cursor spin for long operations (Mac).
The Replace() function now works for strings longer than 32k.
Fixed potential crash in text box when database contains some non-unicode text (Cocoa).
Better error handling in Navigator.
Mac Gold/DC installer now cleans up old man pages.
Fix drawing of reconcile checkbox on Mac (Cocoa).
Fix cursor tracking in edit lists. (Cocoa).
Wider date column on Trial Balance movements.
Fixed crash when COM client tries to force a close while an alert is up.

New in MoneyWorks Gold 7.3.1 (Oct 15, 2015)

New in MoneyWorks Gold 7.3 (Oct 15, 2015)

The internal user-interface framework has been ported from the classic Mac/Carbon APIs to use the Cocoa framework.
64-bit means access to more memory for better performance with very large data files (>2GB).
Cocoa Text system for data entry fields fully supports text transformations, speech, dictation, multi-level undo/redo, etc.
Core Text output for higher quality and slightly faster text rendering.
Faster initial launch and lower memory overhead on systems with no other 32-bit apps, due to not having to drag in 32-bit system libraries.
Resize windows from any edge (finally).
Smooth scrolling.
Retina display support—sharp text on Macs with Retina displays.
64-bit operation is supported on Lion and later. MoneyWorks 7.3 will continue to execute in 32 bit mode with the Carbon framework on Snow Leopard. Snow Leopard users please note: MoneyWorks 7.3 will crash on the very first launch on Snow Leopard (Snow Leopard is erroneously trying to launch the 64 bit version which the installer has just removed). Just start the app again and you’ll be in the 32 bit version.
El Capitan compatibility for Datacentre:
You must update to version 7.3 before installing OS X 10.11 El Capitan on your Mac server (The El Capitan installer has a bug that will damage your Datacentre installation and prevent the normal software update from working; 7.3 has repair measures to autoatically fix problems caused by the El Capitan installer).
Unrelated to the El Capitan installer bug, versions of Datacentre prior to 7.3 are not compatible with the “rootless mode” of Mac OS X 10.11. In 7.3 the symbolic link to MoneyWorks Gold has moved from /usr/bin/ to /usr/local/bin/. This link is used internally by the server to start MoneyWorks CLI worker processes for serverside reporting, REST request processing, and various other tasks. If you have scripts that use the old symbolic link path, they will need to be updated.
Cloud/Internet performance improvements:
Statements can now run on the server for orders of magnitude speed increase when running over an Internet connection. The caveat is that the fonts used on the statement form must be installed on the server. If your statement form uses special fonts only installed on your client, you will need to continue to have statements rendered by your client, otherwise statements will suffer font substitution.
To enable server-side statement generation, you must set the “Run on server if possible” checkbox in the Form Options for the statement form.
Payments History optimised; now orders of magnitude faster when running over Internet connection.
Enquiry on a P&L account is now much much faster.
Purging is much faster, and may be interrupted by clicking Stop.
Sped up transaction entry window a bit more, especially with foreign currency transactions.
Script Editor improvements:
64-bit Mac version gets Scintilla-based script editor (as for Windows version):
Block indent/outdent (tab/shift-tab for selection)
Line numbers.
Unlimited script size.
Multi-level Undo/Redo.
Handler popup for easier navigation of large scripts.
Script control for reports now has syntax highlighting.
Added Copy Script as Styled HTML command to Scintilla script editor.
Increased some size limits:
Report editor now supports reports with up to 30,000 parts.
Budget editor now supports unlimited number of ledger records without having to select a subset.
Up to 10,000 detail lines in a transaction.
Additional optimisations to improve performance with large data files.
Other improvements:
New Privilege: Stocktake. Stocktakes were not previously protected by a privilege. Since this new prvilege will be off by default for existing users, it will need to be added for users who need it. Go to Sharing and Users and open each user who needs the Stocktake privilege and click the Stocktake checkbox under the Products heading.
Recurring transaction setup now picks up the date of the template transaction and syncs the start date to the day-of-month or day-of-week automtically. To have a start date that does not conform to the repetition rule, change the start date after changing the day of month/week. Recurring transactions and messages will now sync themselves to the intended day number if they were initially set up with a non-matching start date.
PDF output for forms now preserves the compression of images on Windows—when you email invoices and statements containing PNG or JPEG images, these images will retain their compression (resulting in a smaller PDF), provided that the images have 100% opacity. Additionally, on both Mac and Windows, form output with the same image repeated will result in smaller PDFs because the image will be stored only once in the PDF and referenced thereafter (this optimisation only happens for direct save to PDF, not from the Preview window).
Start menu items have been cleaned up: MoneyWorks is now just one icon link rather than a folder.
Improved scroll-wheel responsiveness on Windows, and we now respect the scroll speed preference in Control Panel.
Script runtime errors: now show line numbers in message and selects error line more reliably in editor.
New: GetLastErrorMessage() function returns last import error.
New: TableAccumulateColumn() function.
CreateTable() can now take an optional parameter to dimension the table.
Improved performance of Find Related ➝ Highlight with a large number of records to highlight.
ChooseFromList() fn: Window is now resizable.
Mac Shift-⌘-H for Payments History conflicted with key equiv for Hold in transactions, so has been changed to opt-shift-⌘-H.
Drag scrolling of lists is accelerated according to distance mouse is outside list bounds.
Navigator Extras folder is now in Signing list to facilitate signing of custom navigator panels.
Stock Journals: Stockcode field made bigger.
Script editor log display now autoreloads (Windows).
Improved file compression performance slightly.
Script mail() function may now be used with no attachment.
DisplaySelection() function now has an optional 3rd parameter: pass 1 to highlight results rather than making found set.
Removed conflicting keyboard equivalent on Contra command.
Report generation is more responsive to cancel button.
Currency conversions now use the rate for today’s date (in case periods have been opened in advance).
Improved alignment for parenthesis-negative integer values in reports.
Windows Script Editor now implements Find/Find Selected.
ReplaceField() function no longer clears the highlighted selection of associated list.
Searching long text fields (e.g. description) now always searches the entire text.
Export Script as XML: Now exports the current text even if the script has not yet been compiled and activated.
CLI no longer treats blank line input as “unknown command”.
Email attachments are cleaned up immediately, and backups downloaded from server no longer accumulate files on the server.
Balance Sheet view in Accounts list now includes Shareholders’ funds accounts.
Drilling down to a related record for a code (e.g. from the Customer code in a transaction) now only does a relookup of the customer information if you click OK for the customer record while the code field is still the active field in the transaction (likewise from products, accounts, jobs). Since drill down became modeless in v6, a relookup was always being forced regardless of any changes having been made. If you change the colour of the related record, that will be reflected immediately in the drill down arrow before you even tab out of the field.
Gain/loss adjustment journals against bank delta are now purgeable.
Change Password is disabled for MoneyWorks Now logins (document passwords should not be changeable for MoneyWorks Now users).
Faster list opening when sorted by extremely compute-intensive calculated column.
SetBudget(), SuggestNameCode(), and SyncTransactionImage() now available in MWScript.
Updated Stock History report.
Updated Malaysia GST report.
Updated Executive Summary report.
Statement of Cash Flows report: Required for Malaysia.
UK VAT Report: Amended for Flat Rate Scheme.
Sorting by a calculated column where the calculation is very time consuming (such as a SumSelection) will now time-out after 5 seconds, rather than locking up the server. If you absolutely need such a sort, consider using Advanced Replace or ReplaceField() to store the values in a user/custom field and then sort that.
Upgraded security of SSL connections
TLS is now enabled (previous versions were forcing SSLv3)
There is now an option to disable SSLv3 and use only TLS, but this may only be used if connecting clients have already updated to v7.3 or later.
Now using openssl 1.0.2d on both Mac and Windows.
Bugs fixed:
Windows PDF now supports proper decimal alignment.
Fixed occasional double execution of script Load handlers on startup.
Improper use of IntersectSelection() et al in a search expression is now flagged as an error rather than crashing or hanging.
Find by Formula in budget and balance editor no longer limits search to a previous search result.
Text output is no longer inappropriately scaled due to display resolution setting (Windows).
Optimised and corrected some issues with date calculations and DayOfWeek() function on 64-bit Mac server.
Forms designer: Fixed cosmetic issues with editing a zoomed out list object.
Windows colour picker Hue label displays correctly.
Gold server reliability improved when multiple network clients are doing progressive searches.
Double-clicking title bar to zoom window in 32 bit version on Mavericks and later now properly resizes window content.
Fixed incorrect heading on gst finalise dialog.
Fixed highlighting of underpaid invoices in receipting dialog.
Fixed error when using Shift-enter in modify transaction selection.
Chart by month no longer outputs bad xml if month name is non-ASCII.
Windows PDF generation from preview no longer loses euro symbols and treats intra-field linefeeds properly.
Fixed misaligned syntax colouring on Scintilla when there are multibyte chars in the script.
Single quote ( ‘ ) in recipient’s name no longer breaks emailing.
Single quote ( ‘ ) in file name no longer breaks server-side backup.
Payments History now clears notes window when you change Name code
Fixed some memory leaks.
Fixed some code signing issues on Mac DC.
Prompt Payment Discount calculation no longer goes wonky when there are no discountable accounts on the transaction.
A failed XML transaction import with posting is now cleaned up properly, and database is unlocked immediately after success.
Receipt/Pay this Invoice now displays local currency equivalent.
Receipt/Pay this Invoice: fixed potential crash.
Reports: Custom Number controls no longer get rounded to 2 decimal places.
Posting foreign currency transactions with loss/gain in local file no longer loses progress display.
Foreign currency gain/loss adjustments due to rate fluctuations should no longer get “currency delta” errors.
Ctrl-shift Esc (for task manager on Windows) no longer passes through the Esc to MoneyWorks, which could cancel the current operation (such as a report being generated).
Improved cache sizing to prevent memory errors with large files when running in 32-bit mode.
Fixed Bonjour incorrect advertising for Web apps on Windows Datacentre.
Windows Datacentre Console now quits reliably via Taskbar ➝ Close Window.
Option to restart Datacentre service at midnight (only via manual config file edit).
Option to oberride SSL cipher selection (only via manual config file edit).
Fixed missing “View” toolbar icon when in read-only mode.
Mad Mac email autofill from address book more reliable.
AddStatementTransaction fixed sign of splait allocation.
MWScript fixed potential crash in foreach in textfile with empty name.
Fixed potential crash when adding custom calculated column.
Removed:
Mac 64-bit: Applescript terminology used by Helper scripts no longer supported. Use MWScript scripts to customise and extend application functionality. The core scripting API (open/import/export/evaluate/doreport) is still supported by Applescript as well as CLI and COM. If you need Applescript Helper support, it is currently still available when running in 32-bit mode, although the dictionary has been removed so developing new scripts is not possible.

New in MoneyWorks Gold 7.2 (Mar 18, 2015)

New in MoneyWorks Gold 6.1.3 (Nov 30, 2012)

New in MoneyWorks Gold 6.1.2 (Aug 24, 2012)

Gatekeeper-friendly code signature and installers - Security note: Mac versions are now signed with an Apple-issued Developer ID certificate. Since this differs from the previous code signing certificate, Mac OS X will ask you to confirm that the updated application should be allowed to access any MoneyWorks passwords in your Keychain. This should only happen once.
Bug fixes:
Cash Basis reporting was sometimes still being invoked after being turned off
Fixed issue with running footers in reports sometimes not appearing on last page
CreateSelection/IntersectSelection functions were crashing on Windows
Document Preference: When altering an item master record pref is now global, not per-user
ADJ tax rate and tweak to BAS Guide (Aus)
Added page numbers and a couple of critical backslashes to the uninstall instructions in Datacentre Admin guide
Removed spurious small floating window that sometimes appeared on Windows
Fixed potential heap corruption on transaction entry with no (or invalid) detail lines
XML Transaction Import: Fixed problem importing multiple transactions with heavy use of work-it-out fields
Importing Transactions: Fixed spurious "Negative prices are not allowed" message for DI
Stocktake journal no longer mangles std cost for non unity conversion factor
When assigning an existing list to a field, right clicking on the list of lists no longer has a spurious Replace cmd
Fixed a potential heap corruption when double-clicking item in Open Recent list in Welcoe screen
IRAS report update (Singapore)
Fixed Commission Report failure in locales with non-period decimal separator
Fixed intermittent crash when updating std plugins (Mac)
Fixed issue with deleting Unbanked account
Fixed a rare random crash on startup (Mac) when looking for local custom plugins folder
Increased the maximum number of recurring transactions from 500 to 5000
Fixed issue with unused reference numbers being lost when discarding a transaction using the window close box
Aged Creditors now ignores filter on Names list when reconciling to ledger
DC Console was not getting Admin privs when launched as non-admin user (Win 7 64)
Aged Receivables report settings was sometimes showing a spurious date field
Autofill from history was being randomly disabled on Datacentre
Update Time web app to v1.0.1
REST reporting 500 instead of 404 for no image found
REST: GET image/transaction now works
Fixed crashes when zero data in report graph
Fixed CLI export crash on windows when filtering by privilege
Windows DC Console: Apply Changes now restarts server
Documents on Datacentre login list now shows enclosing folders on Mac
Stock Creation Journal: std cost was incorrectly calculated for unit-converted items
Increased maximimum PPD Discount Days (was max 127)
Import: Fixed broken User file importing on Windows
Fixed issue with Sticky notes not displaying sometimes (Windows)
Fixed MW Express freeze attempting to print jobs list
Fixed issue with Stickies not showing when stepping through selection (Mac)
Buffr overflow in Aged Receivable Report (long theirref field) was causing report to exit early
REST: Windows server now recognises / directory separator (as well as \)
REST server now cleans up worker threads where client failed to read the output
Export to Excel no longer includes style sheet (which caused Excel to mangle fonts)
Fixed problem with Find function in calculated column breaking sort optimisation for other columns
Fixed glitch with PO numbering after entering a journal and switching transaciton type on entry screen
Fixed CLI crash when parameters are not valid utf8
Express/Cashbook product entry buy/sell checkbox behaviour was sometimes flaky

New in MoneyWorks Gold 6.1 (May 4, 2012)

Technical changes:
File size limit increased from 2GB to 4GB
Mac Datacentre server is now 64-bit. This allows it to access more memory (previously database caches were limited to 1GB due to 32 bit address space constraints). Supported architectures are PowerPC 32-bit, x86 32-bit and x86_64 64-bit. Minimum system version is 10.5.8
Mac Datacentre server now runs with reduced privileges (as user moneyworks_server instead of root). The update installer will migrate existing installations. This change does require that data files be owned by the server user (or at least be staff group writeable). The Datacentre Console will check and update ownership and permissions of the data folder and its contents for you.
New features:
REST API (Datacentre):
Provides an HTTP/HTTPS-accessible application programming interface making integration with other networked systems much easier, as well as platform neutral
Includes mobile reporting web app. Run Datacentre reports from your smartphone
Includes mobile invoicing web app. Enter invoices from your smartphone
Add your own web/javascript applications that interact directly with MoneyWorks databases
Added printable copies of the dashboard charts to the reports menu
GST Report now breaks down by currency (Gold)
XML importing and exporting (Gold, Datacentre)
Other changes:
Enquiry product code entry fields now more spacious to accommodate long product codes
Mac versions now always add file extensions to files you save.
Mac versions now hide file extensions of filename in window titles and menus
Window behaviour on very small screens on Windows (e.g. 800x600 netbook screens) is now greatly improved. Although note that the official system requirements call for a 1024x768 minimum screen size
Cashbook now asks to replace a report of the same name when installing by double-clicking
Navigator now updates GST status after running a GST report
CLI doreport now takes size param to specify font size
XML exporting now preserves whitespace as CDATA
Evened up margins of Balance Sheet report, and improved behaviour of Currency popup when there are no currencies
We no longer query the Windows address book for auto-filling email addresses (Windows address book dll(s) just too unreliable)
Prompt Payment Discounts now applied to invoices generated from sales orders
Open/close period command now persistently redisplays message about single user requirement for the benefit of people who ignore the initial one
Name.Hold field is now available in Replace/Advanced Replace
Save a Clone As now clears budgets
Import data string via AppleEvent had an 80,000 character limit on the string. This limit has been removed (actually changed to a megabyte)
Tweaked NZ GST Guide: The Mode menu has been replaced by a "Show Documentation" check box, which if checked displays the documentation on the first page and the actual report thereafter. So you will always get a result regardless of the Documentation setting (a source of some confusion).
Report writing and calculations:
New intrinsic functions CreateSelection() and IntersectSelection() plus new For Each loop variant in report writer that iterates over the result of these functions
Functions that take a search expression as text now have access to the enclosing scope's identifiers when the expression is evaluated
Val() function. Takes a text string containing an expression. Returns the result of the expression. This provides a way of deferring the evaluation of expensive calculations on either side of an If function.
Import() function now returns the sequence number of the last record imported (for tables where this is supported). -1 is returned if the import failed. Note that using this function to import into tables other than USER is very strongly discouraged.
Report writer Find Ledger part: A relational search expression may now include variable identifiers from the report
Intrinsic functions that take a search expression parameter now have access to identifiers from the enclosing scope
Cashflow report setup dialog box now makes it clear that All banks mode operates only on base currency bank accounts
Duplicate Product now keeps Manufacture and AutoBuild settings
Sales order process to cash sale now captures payment method/details
Datacentre-specific:
Opening a new period with very large chart of accounts is now much faster on Datacentre due to being executed entirely on the server.
Serverside reports now use the locale of the user who installs the software (Mac)
Console UI now responds to arrow keys
Console seems to leave zombies of chmod and dcproxy
Fixed Console control visibility when deathenticating (Mac)
Datacentre console now only runs a single instance, since it makes no sense to ever run a second instance (Windows)
Console warns against using mapped network drive letters in paths, since these are not accessible to server (Windows)
Console now verifies that Gold installation matches server version (Mac)
Log rotation. Several logs are now kept in rotation
Bug fixes:
Critical: Prevent posting of transactions that are open elsewhere for modification (it has been possible to open the same transaction twice).
Budget editor better handles pasting data containing blank cells
Fix deletion of validation lists (could unexpectedly delete all validations lists)
Fix sorting by Ledger.Concat field in report writer for-loops
Navigator Show Item List now shows all, not just inventoried items
Cosmetic fix to list sidebar resize drag area on windows
Budget editor Distribute command properly refreshes selected cell on Windows
Email via SMTP can now handle contact names containing ampersands (Mac)
Fixed loss of precision when importing/exporting product unit conversion factor
Fixed problem with restoring backups of files with long file names
Notes shown for a transaction now close when clicking Next
Highlighting newly added record now works more reliably when keyboard focus option for lists is enabled
Transaction note window now closes when Next button is pressed
Receive Stock Before Invoice no longer allows negative quantities to be received into inventory
Receive Stock Before Invoice now uses average unit price instead of value on purchase order for stock creation jnl
Negative purchase of stock now use correct costs if an item appears twice with negative quantities
Session recovery no longer fails for a tax rate change in a newly created file
Custom report/form drill down to another report now determines types for custom report parameters
Job sheet item created for a job prepayment (via an invoice) now matches the sign of the quantity to the amount
Product entry custom validation glitch with revalidating fixed
Product update-importing no longer allows control accounts to be cleared
Command line client now recognises colour names when importing
Budget Editor: Pasting data from spreadsheet with empty cells now treats empty cells as if they were 0
Improved unused reference number reuse when closing transaction window using window close control
Importing Transactions with Create Jobs option. Job code is now sanitised
Payments History now behaves better when transactions have been purged
Fixed a running balance glitch with negative balances in the Balance History from Date statement
Various fixes to transaction reference number allocating
Validation List Items: Can be entered as 15 characters, but only 14 characters are ever displayed
Next with post option was skipping posting
After emailing a PDF, Save as PDF no longer gratuitously emails as well
Parsing of 4 digit numbers for dates (ddmm or mmdd) is again supported on Mac
Prevent negative unit conversion factor for products
Order Prompt Payment Discounts now respect discountable flag in accounts when creating invoices
Typo fix in Prompt payment Discount prefs
Fixed privilege for Accept Deposit on Sales Order
Purchase Order: Backorder qty is now populated by default
Purchase Order Rounding: OrderTotal sometimes disagreed with total
Reports menu was sometimes not enabling in subsequent instances when multilaunching (Mac)
GST report: Fix date format to prevent truncation of dates
Export no longer gratuitously populates mailing/delivery addresses for transactions
Fixed crash with copying of records in validation lists
Fixed a CLI crash when -r parameter was too long
Trial Balance: Print Movements is now correct for forex accounts
Fixed a potential crash when cancelling out of Work-In-Progress choices when Job costing being activated
Bad relational search error now flows back to report interpreter and result in an error alert
Product Importing: calculated cost price now respects currency of buy price
Address book import now handles large numbers of groups (Mac)
Cashbook: Fixed missing resource error when opening file from Gold/Express
Product Images: don't allow uploading of pdf product images on windows
Plain emailing through system client. Subject no longer overrides message
Validation: now displays custom message when reapplying custom validation after a record i modified
Fixed a "client illegally extended selection lock" error
Fixed an issue whereby sorting by calculated column could fail for calculations involving nested strings
Cosmetic fix to the Duplicate Multiple dialog box
Fixed typo in Trades sample chart of accounts
Creditor Invoice writeoff was not reliably rejecting *-rated writeoff accounts
Fixed crash when deleting account with 7 character code