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

Posted in Uncategorized | Comments Off on Interfacing with a mail client on Windows

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

Posted in Uncategorized | Comments Off on Optimising a report

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

Posted in Uncategorized | Comments Off on GetLastErrorMessage

TableAccumulateColumn

TableAccumulateColumn (table, key, columnNum, value) Accumulates the value into the specified column of a table. The table must already have been dimensioned to have sufficient columns. As of MoneyWorks 7.3, you can pre-dimension a table on creation by passing the … Continue reading

Posted in Functions, Uncategorized | Comments Off on TableAccumulateColumn

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

Posted in Uncategorized | Comments Off on Importing over high latency network

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

Posted in Uncategorized | Comments Off on Statement Optimisation