Where do I find my serial number

From version 6 onward – open Moneyworks and select Help – Enter serial.

In previous versions you will find your registration number by opening the software and selecting,  in Windows, Help – About MoneyWorks; on a Mac, MoneyWorks Gold/Express/Cashbook – About MoneyWorks.

Posted in FAQ | Comments Off on Where do I find my serial number

How do I look up the description of a Category when using Subsummary by category

Subsummaries provide a quick and easy way to create summarised reports.

In an account range part (such as Find Accounts) where a subsummary is applied (either locally, or for the report as a whole), The Account.fieldName notation cannot be used to access values (because accounts have been consolidated by the Subsummary). If you which to access the current subsummary code value being output, use the SubSummaryScopeCode variable.

E.g. If the Subsummary is consolidating by Category, and you want a cell to look up the category description, use:


=lookup("C"+SubSummaryScopeCode,"general.description")

Actually, for Category, the lookup is not necessary, because there is also a SubSummaryScopeDesc variable which already contains the description. You can just use that. If you were summarising on something else (such as Category2) that does not have a natural relationship with a description, then you would need to do the Lookup as above.

=lookup(“C”+account.category,”general.description”) will not work.

Posted in FAQ, Report Writer | Comments Off on How do I look up the description of a Category when using Subsummary by category

Insert Disk Message on Windows

There have been instances MoneyWorks 6 on Windows where MoneyWorks appears to open and run, but when people try to do something they get a message along the lines of: “Please insert the disk <<some removeable disk>>”. We do not know why this happens, but believe it is something to do with backing-up using the Save A Backup as command directly onto a removable device.

The only way we know how to clear it is to zap the registry preferences for MoneyWorks — in RegEdit go to HKEY_CURRENT_USER>Software>Cognito>MoneyWorks {Cashbook/Express/Gold} and click on Preferences and Delete it (Edit>Delete)

You should backup to your hard drive and then move the data file to a thumb drive/usb drive if you need to move it.  Then copy to the hard drive of the new computer and open from there.

Posted in FAQ | Comments Off on Insert Disk Message on Windows

Change History for 7.1.5

10 July 2014. Performance and reliability enhancements. MoneyWorks Now logins operational.

Datacentre

  • MoneyWorks Now login service is now live
  • MoneyWorks Now usernames longer than 31 characters are now supported
  • Folder deletion from Datacante Console now more reliable
  • Datacentre Console folder usage report now counts attachments properly
  • Datacentre now supports intermediate certificates for SSL
  • Improved behaviour of server upload facility when user has no hosting folder to upload to
  • Installing scripts ftom mwxml now flushes to server when installing as Datacentre client
  • Datacentre daemon interconnect now uses 127.0.0.1 rather than hostname on Windows
  • Datacentre compatibility with Mac OS X Yosemite (no longer use /usr/libexec/StartupItemContext)
  • Datacentre Console can now handling Unix line endings in .pem block pasted from (e.g.) Notepad++ on Windows
  • Datacentre Console on Mac now detects and sets ownership of data folder contents more reliably
  • Datacentre Console on Mac now installs Gold client more reliably when needed following manual install
  • Simultaneous REST list requests no longer kill moneyworks_datacentre.exe on Windows
  • MoneyWorks Gold now recognises wildcard SSL certificates in Datacentre
  • Windows Datacentre service now restarts automatically on failure
  • Datacentre Console folders/files list no longer erroneously allows multiline selection
  • CLI/REST doreport with bad period now flagged as soft error
  • updated moneyworks-rest manual page
  • REST request against non-existent document no longer causes hung worker processes on server
  • MoneyWorks Now servers now accept whitelisted file types only via Upload facility
  • Improved SSL protocol support and removed weak ciphers for better security
  • Windows server better respects requested font for reports
  • Shorter initial connection timeout when connecting to non-existent server
  • Lengthened network timeout to reduce incidents of disconnects when someone is doing a remote save/backup for very large files on slow servers
  • Improved filename sanitisation for files unarchived on Windows that originated on Mac (containing * or ?)
  • Mac no longer forcing .txt extension on bank export files
  • Job Sheet: pasting a job sheet record that results in a stock requisition now includes the job number in the journal analysis
  • Bank Register Report now shows correct open/close balances for forex accounts
  • Cosmetic fix for Mac OS X Yosemite (disclosure triangles)
  • Payments History redraw no longer lost after retrieving results from server
  • Search box no longer crashes if used while entering stocktake figures on Windows
  • New intrinsic function: WriteToTempFile(text). Returns path to new temp file
  • Importing accounts with update now updates the colour field
  • Parameters to external() no longer limited to MAX_PATH on Windows
  • Windows Script Editor no longer steals ^T and ^L keyboard shortcuts for its own nefarious purposes
  • XML Journal Export now gets correct signs for credits
  • Optimised standard statement forms for better performance with head office accounts
  • Improved caching performance (particularly affects price relookup for very large sales orders)
  • Updating budgets for ledgers found in the budget editor using Find now works
  • Added new RCM code for Singapore as requested by IRAS (it is not actually used anywhere)
  • Unreachable url in foreach on Windows no longer throws up an open file dialog
  • Electronic payments are now stamped with bank account when exported from batch creditor payments
  • Windows Gold no longer exits when given unknown command line switch
  • Increased the maximum record size that can be imported
  • Canonical export formats now use larger buffer so that very large records are not truncated
  • Updating date fields via XML import now works
  • GST Report: Shows description on Currency Balancing Lines as required by IRAS
  • Manual GST control account journals are now stamped by GST finalisation
  • Dispatch code for viewing a jobsheet record from Navigator
  • Balance Sheet report currency popup now behaves properly
  • Fixed a crash in Find() function with an empty delimiter param (this was killing the stocktake report)
  • Don’t show Windows executable types in Mac Command menu
  • Tweaked the layering of multiseries line charts to put the primary series on top
  • Bundle style Applescript apps now showing in command menu again
  • Account Enquiry “include unposted” no longer affects reports run while enquiry is still open
  • Originating Order Sequence Number is now set for order deposits
  • Job Billing window resource leak fixed (leaked selection object)
  • Cosmetic fix to popups on Mac (sometimes bottom edge was not being drawn)
  • Bill Job: Carried forward job sheet items now get invoice date if it is changed prior to accepting the invoice
  • Bill Job: discarding invoice with carry-forward entries will no longer potentially remove other entires created while the invoice was open
  • say() function no longer crashes when used in command line mode
  • Duplicating a Funds Xfer payment now clears the FundsXfer flag (which allows the duplicate to work with Cancel Transaction)
  • Updated OS version detection on Mac to work with Yosemite
Posted in Change History | Comments Off on Change History for 7.1.5

Using MoneyWorks Now™—MoneyWorks in the cloud

MoneyWorks Now is MoneyWorks accounting hosted in the cloud. Cognito currently maintains several cloud servers in Auckland, New Zealand. You can have your data hosted on our server for a monthly fee without any other software costs. You still get the benefits of the full gamut of MoneyWorks Gold features, including the ability to integrate with your local desktop apps on Mac or Windows, as well as access from mobile web apps.

Making a MoneyWorks Now login account

  1. In MoneyWorks Gold, click Connect
  2. Select Connect Using: MoneyWorks Now
  3. Turn off the “I have a MoneyWorks Now account” checkbox (it will usually be off already if you have never used MoneyWorks Now)
  4. Connect

  5. Enter your email address: This will be your MoneyWorks Now username.
  6. Enter a SECURE password. The password will be used to encrypt access to every document you use in MoneyWorks Now, so it is important that it is secure. Short passwords are not allowed. Ideally, leave the Add to Keychain/Vault option turned on (unless you are not on your own computer)
  7. Click Create to create the account.
  8. Wait for someone to grant you access to a server folder (to upload to) or to a document to log in to.
  9. Do not lose or forget your password. Although passwords can be changed, they cannot be reset without losing all previously granted access records.

Getting your accounts into the cloud

First, you’ll need to arrange a hosting account. Contact Cognito to do this.

  • Open the file
  • Go to Users and Security. Multiple users must be turned on. The user you are logged in as (usually the master admin user) must have a password (cannot be blank)
  • Click Upload to Server
  • Uploading

    Your file and its associated Custom Plugins folder (including custom forms, reports and transaction and product image files) will be compressed and uploaded. Note that a MoneyWorks Now server will discard filetypes that are not on its filetype whitelist. allowed file types are: mwd7;txt;text;jpg;jpeg;png;pdf;stmt;invc;crep;impo;rept;srep;rchn;adf_;remt;prod;job_;bmp;csv;gif;tiff

  • Log in to MoneyWorks Now, select the folder to upload to, and click Upload.
  • The file will be saved, backed up, and uploaded (including plugins); also your MoneyWorks Now login will be entered into the email address field of the user you are logged into the document as.
  • Close the document.
  • Click Connect and select Connect Using MoneyWorks Now and log in; the document will be available: select it and log in.

Logging in to your accounts

  1. You must have the latest version of MoneyWorks Gold installed on your computer
  2. Click Connect on the MoneyWorks Gold Welcome screen
  3. From the Connect Using popup, select “MoneyWorks Now”, check that the “I have a MoneyWorks Now account” checkbox is on, and enter your username and password (if your password is in your keychain/vault, it will be entered automatically)
  4. Click Log In
    A list of all documents that you have access to in the MoneyWorks Now distributed cloud will be shown
  5. Select a document and click Log In

Granting access to other users

  1. Log in to the document using MoneyWorks Now.
  2. Go to Users & Security
  3. Create the user if they do not already exist.
  4. Fill in the user’s email address / MoneyWorks Now username
  5. click the Enable MoneyWorks Now Access checkbox
    Grant
  6. The user’s password will be set to a random password and an activation link will be sent to the user
  7. The user clicks the activation link and logs in to MoneyWorks Now. Their login credentials for the document will be securely stored by the MoneyWorks Now login gateway
  8. User can now use Connect in MoneyWorks Gold to access the document

Regional Formatting

Currently, reports run on the server will use the regional formats set on the server for dates and numbers, so do not be surprised if these formats don’t match what you may have set on your own computer. Our New Zealand servers are set to New Zealand date and number formats.

Getting the Best Performance

While it can be very convenient to have your data hosted in the cloud (especially if you will be accessing it from several different locations), there are some costs: the main one is that accessing anything over the internet is going to be somewhat slower than if it was on the same LAN.

Reports

The standard reports included with MoneyWorks are set to run on the server. This means that the time to generate a report will be pretty much the same as it would be if you were running it on a server on your own local network. When running reports, you will see a symbol next to the output setting for the report. This means that the report is going to run on the server. If you don’t see this, the report is going to run on your computer, with a lot of back and forth to the MoneyWorks Now server, and may be a lot slower. If you hold down the Shift key when you click Preview, MoneyWorks will switch the “run on server” setting (so if it was going to, it won’t this time and vice versa).

Because reports are generated on the server, the font used for the report has to be one that is on the server.

Forms

Because you typically want complete control over fonts and layout for invoice forms and such, these are always generated on your computer, using your fonts. If you’re using a customised statement form, you might want to check out the statement optimisation notes here

Posted in Uncategorized | Comments Off on Using MoneyWorks Now™—MoneyWorks in the cloud

How can I send email via an SMTP server that requires TLS on Windows


this post is obsolete
see:
Using Gmail SMTP
Using Office365 SMTP
Using SendSMTPMail


As of v7.1.8, MoneyWorks includes the sendEmail tool as part of the standard install, so TLS support is available on Windows (as well as Mac) out of the box. Blat is also still included, but will no longer normally be used.

Previous version of this FAQ:

The standard MoneyWorks install on Windows includes a tool called blat (http://www.blat.net) for sending emails via an SMTP server. This is used when you select and configure the SMTP email option in MoneyWorks Preferences.

While it is light weight, blat does not support secure TLS connections to SMTP servers (such as smtp.gmail.com) that require them. If you need to send via TLS, you can install sendEmail.exe in the MoneyWorks executable folder. If this tool is detected, it will be used preferentially to blat.

Sendemail is available here: http://caspian.dotconf.net/menu/Software/SendEmail/ . Be sure to get the full binary with TLS support compiled in. Download sendEmail-v156.zip and unzip into (e.g.) C:\Program Files (x86)\MoneyWorks Gold\

BTW, the standard Mac install of MoneyWorks includes the perl version of sendEmail within the MoneyWorks app package, so you don’t need to install anything further to support TLS SMTP on Mac.

Note: Requires MoneyWorks version 7.1.4 or later

Posted in FAQ, Tip du Jour | Comments Off on How can I send email via an SMTP server that requires TLS on Windows

Change History for 7.1.4

3 June 2014 Minor feature enhancements, performance enhancements, and bug fixes

  • Allow CreateSelection with *highlight, *found to apply to the Batch Creditor Mark For Payment window, and also to apply for previously unsupported files such as filters, messages and depts
  • Improved column calculation suppression for calcs that are not practical for high latency networks
  • Implemented override for column calculation suppression
  • Save command issued from script editor now flushes changed scripts before saving
  • Script Editor Help lookup now works for text that follows multibyte unicode text
  • Cache speed optimisation
  • optimised network packet decoding a bit
  • Cheque form editor: removed obsolete Cheque.DrCrCode identifier
  • Fulltext search by custom colour name now works consistently on Datacentre
  • Batch Creditor Payments, Electronic Payment Method missing bank warning icon was not showing on Mac
  • MWScript: declaring loop control variable with same name as existing variable no longer crashes the compiler
  • Job Detailed Report updated
  • Run on Server is now ON by default for new reports
  • Overlong manual log entries no longer crash
  • Cash Forecast updated
  • IRAS Audit Report (Singapore) updated
  • [critical] Windows typing =calc in a field was not doing expected processing when field exited
  • Better error message when opening a .mwxml without any accounts document open
  • Applescript Helper.scpt now more stable when quickly tabbing through fields
  • Added copies of purchase analysis reports back into main report menu
  • Console queries now shut down ssl connection in orderly fashion on Windows, eliminating spurious errors in log
  • Serverside analysis reports now work with Windows-hosted server
  • Updated tax codes for Singapore
  • Fixed hyperlinks in Datacentre Admin Guide pdf
  • Analysis reports can now run serverside on Windows server
Posted in Change History | Comments Off on Change History for 7.1.4

Change History for 7.1.3

  • Windows: Period popups were not syncing after changing a date to a different month

no changes to Mac version

Posted in Change History | Comments Off on Change History for 7.1.3

Change History for 7.1.2

May 2014 — bug fixes and performance improvements

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

How do I open more than one document at once?

That depends on what platform you are on.

First of all, on both Mac and Windows, you will need to turn on the Multiple Instances preference (this is under the Documents tab in the MoneyWorks Preferences dialog box). This is off by default, so the default behaviour when opening a new file is to close the file that was currently open.

Mac

With Multiple Instances turned on, you can open another file on Mac by choosing that file from the Open Recent menu (you will have to have previously opened it). This will cause MoneyWorks to start a new instance of the application for you.

As of v7.1 you can create a shortcut for starting new instances by entering moneyworks:// in a Safari window and then dragging that URL to the Dock. Clicking that shortcut will now start a new instance (provided the Multiple Instances preference is on, and assuming the current instance has a document open already).

Windows

On Windows, you can open a new instance of MoneyWorks by choosing MoneyWorks from the Start menu. You can then open another document. Or, you can double-click a document in Windows Explorer, and Windows will start a new instance of MoneyWorks for you. On Windows, the Open Recent menu does not start a new instance. If you double-click a report or form document, MoneyWorks will open that in the currently running instance, rather than starting a new instance, regardless of the Multiple Instances preference

Posted in FAQ | Comments Off on How do I open more than one document at once?