MoneyWorks support
New web views in MoneyWorks 9.1 and later
WKWebKit on Mac MoneyWorks 9.1 and later on Mac uses WKWebView instead Webview for embedded web controls. This change should be entirely transparent to existing scripts that use webviews. You get the newer out-of-process javascript engine. WebView2 on Windows MoneyWorks … Continue reading
Communicating with Javascript in a Web View
MoneyWorks 9.1 provides modernised web views on Mac and Windows (see New Web Views in MoneyWorks 9.1). MoneyWorks 9.1 and later also provides new functionality for communicating with the content of web views (requires WebView2 Runtime on Windows). Calling out … Continue reading
Server change notifications
Experimental and subject to change External system notification has been implemented in MoneyWorks Datacentre 9.0.2. This allows another server to be notified whenever a change is made in a MoneyWorks database. This will remove the need for external systems to … Continue reading
XOR handler
MWScript doesn't have a bitwise XOR function, but it does have an AND with ones-complement function in ClearFlag, which provides a bitwise NOT, which can be used with TestFlags (which is bitwise AND) to do a NAND. Thus you can … Continue reading
SendSMTPMail
SendSMTPMail is a script handler you can implement that takes over the job of sending SMTP mail. The handler signature is: SendSMTPMail(recipients, attachmentPath, subject, message, attachmentFileName) When MoneyWorks 9 has an email + attachment to send and the preferences are … Continue reading
MoneyWorks Now login gateway API
If you are implementing a service that will access a MoneyWorks database via its REST interface hosted on a MoneyWorks Now server, you can retrieve the necessary login credentials by querying the MoneyWorks Now login gateway. A MoneyWorks Datacentre REST … Continue reading
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