MoneyWorks support
Custom edit field special properties
MoneyWorks Gold 8 allows you to create new windows that can be used with scripts. The UI form editor allows you to set the type (text/number/date) and numeric format of an edit field, but there are some other useful modes … Continue reading
Interfacing with a mail client on Windows
By default. MoneyWorks uses SimpleMAPI to create a new email message in the system mail client (assuming the default system mail client supports SimpleMAPI). The drawback with SimpleMAPI is that it is modal (you must send or discard each message … Continue reading
Optimising a report
Some time ago I had the need to find a pair of transactions that added or subtracted to a particular number. In fact when you are chasing down a problem in a set of accounts this is not an uncommon … Continue reading
GetLastErrorMessage
GetLastErrorMessage() Retrieves the last logged error message. When a script gets an error from the Import() function, you can use GetLastErrorMessage() to get more information about the last error that occurred. Important: The last error message will only be updated … Continue reading
Importing over high latency network
Ideally, importing to a cloud server would always be done via cloud APIs (i.e. the REST API provided by MoneyWorks Datacentre). However, one of the advantages of MoneyWorks over browser-based cloud solutions is that you can integrate seamlessly with other … Continue reading
Interfacing with a mail client on Mac
Deprecated on Catalina and later — recent macOS versions have made scripting Mail (and Applescript generally) extremely unreliable, so MoneyWorks has transitioned to using the macOS Sharing APIs. This information may still apply if you are using other scriptable mail … Continue reading
Statement Optimisation
Name.DBalance Generating statements involves quite a lot of database requests per statement. Statement (and invoice) forms are generated on the client, so it pays to try to eliminate unnecessary processing when statements will be generated for data that is hosted … Continue reading
Sending SMTP email with TLS on Windows
this post is obsolete see: Using Gmail SMTP Using Office365 SMTP Using SendSMTPMail 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 … Continue reading
Sorting Filters
In MoneyWorks Gold 7.1.4, it is now possible to use CreateSelection() with the "*Found" and "*Highlight" metasearches to access more tables and list windows than were previously possible (e.g. department, offledger, filter). Access to the transaction selection in the Creditor … Continue reading
Make the Bank Transfer dialog remember the From and To accounts
If you are doing a lot of bank transfers, you might want to have one or both of the bank account popups remember their settings, at least for the session. Here's a script that does that. constant meta = "Cognito … Continue reading