Moving your MoneyWorks to a new Computer

So you’ve retired your old workhorse and have a shiny new computer onto which you want to install MoneyWorks, but you’re not sure how to proceed. Here’s what you need do:

  • Install MoneyWorks on your new computer and activate it with your serial number.
  • Transfer your existing MoneyWorks data files and custom plug-ins to the new computer.

Note: The remainder of this article applies to MoneyWorks Gold, Express and Cashbook only. For information on moving MoneyWorks Datacentre please see Moving MoneyWorks Datacentre to a new machine.

Note: If you are transferring from an old Mac to a new Mac using Migration Assistant, you shouldn’t need to do anything (although occasionally the serial number might not transfer, so you should record that in advance). Be aware however that old versions of MoneyWorks may not run on later versions of the Mac OS.

Finding your serial number

You will need this to activate MoneyWorks on your new computer. If you haven’t kept a record of your serial number in a safe place, you can locate it on your old computer by starting MoneyWorks and choosing Help>Enter Serial. Failing this, provided you have registered your serial number, you can request Cognito to send you a copy.

Finding your MoneyWorks version

Your serial number will only activate the version of MoneyWorks that you currently use. Thus if you are using version 6, you will need to install MoneyWorks 6 (and not MoneyWorks 7 or 8). To find out the version number choose About MoneyWorks (under the Help menu in Windows, or the MoneyWorks menu on Mac).

Getting the MoneyWorks Installer

You can request a MoneyWorks installer (from version 5 onwards) to be sent to you from the Try page on the Cognito Website. Fill out the form, and select the correct version of MoneyWorks from the pop-up menu (installers for MoneyWorks 5, 6, 7, 8 and 9 are available). The download link will be emailed to you, and you should download and run the installer on the new computer, and activate the MoneyWorks with your serial number.

If you are using MoneyWorks Datacentre (or you are using an old version of MoneyWorks Gold only as a network client), you won’t need to worry about transferring your MoneyWorks data files as they will be stored on your server or Gold host computer. Gold clients will however need to transfer their MoneyWorks Custom Plug-ins as described later in this post.

Backing up MoneyWorks File(s)

The easiest way to transfer your files is to make a MoneyWorks backup file. Open the MoneyWorks file on your old computer and choose File>Save a Backup as and ensure that you have the Accounts Backup with Custom Plug-ins option set. This creates a compressed backup file that includes any custom plug-ins (customised invoices, reports etc) that you may have. Simply copy this file onto the new machine and double click it—MoneyWorks will open and offer to restore the backup with the specified name to the nominated directory. How you do the physical copying is up to you—either use a memory stick, or copy the file over the network, or whatever method you are using to transfer your other files.

Having transferred your data files, you will need to uninstall MoneyWorks from the old machine. On the Mac, just drag the MoneyWorks app from the Applications folder to the trash; on Windows, use the Windows Uninstall process (which varies, depending on what version of Windows you are using).

If you don’t want to or are unable to transfer the files using a MoneyWorks backup, then you will need to locate the MoneyWorks files and MoneyWorks Custom Plug-ins the hard way, so read on …

Locating your MoneyWorks Data files

Your MoneyWorks data files will be wherever you placed them on your hard drive. The easiest way to find them, if you are using MoneyWorks 6 or later, is to open them in MoneyWorks on the old computer, and click the File Location link on the Housekeeping tab of the Navigator. This will open the folder that contains the file in a Finder window (Mac) or a Windows Explorer window (Windows). You will need to locate the file (on the Mac it will be highlighted in the Finder window) and copy it onto the new machine.

Locating your MoneyWorks Custom Plug-ins

The MoneyWorks Custom Plug-ins directory contains any customised reports, forms (invoice, statement or cheque layouts) or scripts that you might have had done. You will need to transfer these to the new computer if you want to keep using them. To locate the folder, click on the Custom Plug-ins location link on the Housekeeping tab of the Navigator. These need to be copied to the correct location on your new computer—for information on this, see the “Managing your Plug-ins” section in the MoneyWorks manual (page 29 if you are using MoneyWorks 7).

A note on File Extensions

If you have had some sort of hardware failure and are attempting to recover MoneyWorks files from a failed drive, you may have to search for the MoneyWorks files on some backup medium. To facilitate this the most common MoneyWorks file extensions are listed below. Note that, until fairly recently, file extensions were not required on Macs.

Extension Description
.moneyworks MoneyWorks 8 and 9 data file
.mwd7 MoneyWorks 7 data file
.mwd6 MoneyWorks 6 data file
.mwd5 MoneyWorks Gold 5 file
.med5 MoneyWorks Express 5 file
.cwd5 MoneyWorks Cashbook 5 file
.mwgz MoneyWorks backup file
.crep MoneyWorks custom report
.invc MoneyWorks custom invoice
.stmt MoneyWorks custom statement
.remt MoneyWorks custom cheque
Posted in FAQ | Comments Off on Moving your MoneyWorks to a new Computer

Change History for 7.3.6

Bug fixes, stability, performance, and other improvements.

6 April 2016

  • Report Writer: Column part Actual, Movement this Period ± N: N now displayed correctly if negative on 64-bit version (Mac)
  • GST Report: Date column is now a tad wider to accommodate YYYY-MM-DD date format
  • Emailing receipt unrelated to a Name Code no longer populates email address randomly.
  • Report writer preview running on Datacentre server no longer causes the report to be considered unchanged.
  • Updated openssl version to 1.0.2f
  • Applescript Make New Document now works again (7.3 regression)
  • Sending an AppleEvent to MoneyWorks when it is not running will now cause it to be launched to receive the event (64 bit regression, Mac)
  • Failure to create a temp file for SMTP message is no longer a crashworthy error
  • Gold Sharing Mac: Dock icon now longer shows doc name when file is being shared with Multiple instances enabled (64 bit regression)
  • MoneyWorks Now URL login from CLI no longer crashes if password incorrect
  • Export Accounts: Large Budgets now export correctly in 64 bit mode
  • Analyse() function now more robust with improperly specified breakdowns
  • Addressed potential crash processing detail line activation
  • Batch Creditor Payments: Fixed spurious “Cheque number used by another user” encountered by clients of Gold server
  • Forms: Fixed issues with alignment of currency-formatted numbers
  • Made processing of residual deposit credits more robust
  • Improved window teardown stability on Windows to prevent a rare potential crash
  • Addressed crash report associated with ctrl ➝ / ctrl ← in some lists
  • XML payment importing more robust
  • Removed spurious Set Comment command from Express menus
  • Forms Designer: Import image now sees gifs (Mac)
  • Addressed potential instability if Save As dialog is left oprn for a long time (Mac)
  • Open/close document is now logged (Datacentre)
  • Addressed potential crash in View Related in product code field
  • Set cursor for in-field drill down arrows on Mac
  • Trial Balance report with Print Movements performance optimised
  • Addressed potental stability issue with Include Unposted
  • Save Selected Script as XML is now properly disabled when no script is selected
  • Datacentre installer now removes 64 bit Console binary on Snow Leopard (to prevent first-launch crash)
  • Improve low-memory behaviour on Windows, particularly for Save a Compacted Copy
  • Support MWScript aborting a window’s Before message by simulating OK/Cancel
  • Make tax amount read only for product transactions when the tax code is ‘*’
  • Allow 64-bit window handles to be type-converted (for use as opaque keys for per-window data storage)
  • Make Jobsheet.Type mutable for Replace. The only valid values for this field are IN or EX.
  • Displaying Cmd key equivalents on Mac no longer crashy for control names longer than 63 chars
  • Fixed instability in Payments History on Windows

7.3.6r1

  • Fix 7.3.6 order unit price being read-only when tax code is *
  • Cocoa version Product entry window resizable
  • Profit and Loss for Year to Date: revert to single period select
Posted in Change History | Comments Off on Change History for 7.3.6

Change History for 7.3.5

14 Dec 2015

  • Cocoa version was failing to filter hyphens from account codes. If you have inadvertently created an account code with a hyphen in it, it won’t be usable. You should delete the account and recreate it (without hyphen). The hyphen character is reserved for separating account codes and department codes in departmentalised ledgers.
  • Fixed a resource leak on Windows where the process could run out of Device Context handles, especially through excessive use of window minimisation.
  • Failed network logins are now always logged, together with the source IP address. Also improved logging for some other Datacentre error conditions, including MoneyWorks Now login failures.
  • Improved formatting and alignment of additional sell price fields in product list.
  • Increased the line length limit for reports.
  • Cancel search in Job sheet Items now clears the search field.
  • Changed the timing of script loading at startup to prevent scripts from accessing an unstable UI state.
  • Do Report AppleEvent now recognises output option on 64-bit
  • Make things less crashy in Windows when there is no default printer.
  • Warn of tax rate changeover after order date when processing orders.
  • Cosmetic fix to list options dialog on Carbon and Windows.
  • Fixed incorrect encoding of ellipsis displayed when detail description is truncated at a newline for list display.
  • Old-style command line parameters were not being parsed properly on Windows in 7.3, resulting in spurious error messages.

15 Dec 2015

Sorry, that last fix in the above list broke command line parsing on Windows so that double-clicking a document wouldn’t work!

7.3.5r1 changes:

  • Fixed Windows command line parsing. Double-clicking documents now works again.
  • Made the login sound on Mac less LOUD. Hope this makes you happy, Rob.

and 7.3.5r2 changes

  • Fixed an error processing problem when logging in to a Datacentre server.
  • Reorder List report now takes into account the unit conversion factor.
Posted in Change History | Comments Off on Change History for 7.3.5

Change History for 7.3.4

30 November 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.

7.3.4r1 1 Dec

  • Fixed extraneous lines in reports introduced by 7.3.4.
  • Fixed typo in old serial number alert.
Posted in Change History | Comments Off on Change History for 7.3.4

Change History for 7.3.3

12 Nov 2015 — Bug fixes

  • 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.

and

  • Allow a greater range of leading adjustment in the forms designer.
  • Malaysian GST-03 Guide: tweak for terminology issue.
Posted in Change History | Comments Off on Change History for 7.3.3

Change History for 7.3.2

29 October 2015 — bug fixes

  • 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.
Posted in Change History | Comments Off on Change History for 7.3.2

I don’t like the “new” focus ring animation

MoneyWorks 7.3 (64-bit) on Mac, uses the Cocoa UI framework instead of the older Carbon framework.

This means that if you are on OS X 10.10 (Yosemite) or later, tabbing between fields will have an animated focus ring that zooms in around the newly active field. This is standard behaviour for Cocoa apps in Yosemite and later.

But I don’t like it.

You can turn it off (for every application on your Mac).

  1. Quit MoneyWorks
  2. Press ⌘-space to open Spotlight search
  3. type Terminal
  4. the Terminal app should be found; click it to open it.
  5. terminal

  6. In the terminal app, type (or copy/paste) this (then press enter):

defaults write -globalDomain NSUseAnimatedFocusRing -bool NO

Posted in FAQ | Comments Off on I don’t like the “new” focus ring animation

What do I do about “posting resulted in bad currency deltas”?

This could happen when the currency balancing ledger for a foreign currency asset or liability account diverges from the exchange rate for some reason (either accumulated rounding drift, or sometimes cancelling or writing off an invoice after the exchange rate for its period was changed). A foreign currency delta ledger should normally have a balance that when added to the main ledger balance, yields that account’s balance in the base currency (and this ratio should agree with the corresponding exchange rate for the period). The message is actually a failsafe sanity check that is being triggered, and is intended to “never happen”.

The solution has generally been to update the exchange rate for any and all affected periods (even if you just change the exchange rate by .000000001, this gives MoneyWorks an opportunity to create an exchange rate gain/loss transaction that incorporates a correction for any drift).

As of MoneyWorks 7.3, the currency balancing ledgers will never diverge from the exchange rate (any transaction being posted automatically includes any correction required), and this message should never appear.

So, first, make sure you are running MoneyWorks Gold 7.3 or later.

I’m on 7.3 but I got this message. What do I do?

Although the currency delta will be correct for the currency for which you are posting a transaction, the currency sanity check is applied to all currencies whenever you post a foreign currency transaction. It is possible that another foreign currency has a currency balancing delta account that has diverged from the exchange rate.

The solution in this case is to

1. run the Diagnostics (File menu).
2. update the exchange rate for any currencies that show a bad delta for each of the affected periods, starting with the oldest period.

If you’re on v7.3 or later, this should only be necessary once. Thereafter, no currency drift should ever occur.

Posted in FAQ | Comments Off on What do I do about “posting resulted in bad currency deltas”?

Change History for 7.3.1

15 Oct 2015

Bug fixes, mostly—but not entirely— for the Cocoa version.

  • Report/Form Save Changes dialog no longer shows full path.
  • Improved defences against working temp file being deleted.
  • Prevent importing Name with base currency ISO code.
  • Fix assertion failure when right clicking in active form text item.
  • Fix random crash after changing list font in preferences.
  • Open Recent → Clear Menu now working (Cocoa).
  • Add missing app preferences icon in Cashbook/Express Navigators.
  • Acme default transaction entry windows were too small, causing problems with Hold checkbox.
  • Fix menu item enabling during modal dialog at launch.
  • Command line file opening in GUI mode no longer opens twice
  • Respond to Esc key when no active control.
  • Find Related dialog. Show in View popup can now recives focus after selecting a destination.
  • Clicking MOTD on Navigator sidebar on Windows now works.
  • Fixed issue with entering new acct/product on the fly after invoking choices with an @.
  • Fix Windows Datacentre clients listing printing showing “-” instead of actual data.
  • Fix incorrect list lineheight for larger font sizes on Mac.
  • Reenable crash reporting on Windows.
  • Ctrl-Click on Mac: Now works as right click again.
  • Mac Window menu now shows window names.
  • Windows installers: Fix migration of start menu items to top level; redundant folders removed.
  • Entourage attachments now working again.
  • mail_client_helper is now checked to override mail client beghaviour.
  • Shift-⌘-O shortcut for OK button in transaction entry now works when OK not default.
  • MoneyWorks Preferences → Emailing: removed reference to Entourage (although Entourage is still supported, for now).
  • Fix crash with EMF graphics in forms preview on Windows.
  • Correct app name in code signature for Windows Datacentre Console.

and

  • Better placement of annual budget in budget editor for long account-dept names.

7.3.1r1

  • 7.3.1 problem with changing tabs in entry windows
  • Fixed Transaction entry OK/Next buttons on XP.
  • Also now rebuilt the Express and Cashbook installers to strip the 64-bit executable on Snow Leopard to prevent the first-launch crash.
Posted in Change History | Comments Off on Change History for 7.3.1

The default mailing address for a branch on invoice form is the head office address. How can I get the branch mailing address?

On a form, Transaction.MailingAddress will pull in the head office address if the invoice is for a branch that has a head office (e.g if the Name Code is something like “BRCH.HOFF”, the address will come from the Name “HOFF.”)

If there is a per-transaction address, that will be preferred, so one way would be to click the Mail checkbox and enter the branch address.

If you always want the branch address, modify the form to use

Lookup(Transaction.SequenceNumber, "Transaction.MailingAddress")

This will bypass the head office address lookup. It will give the per-transaction address if there is one, otherwise it will look up the address from the Name record associated with the transaction.

Posted in FAQ | Comments Off on The default mailing address for a branch on invoice form is the head office address. How can I get the branch mailing address?