MoneyWorks support
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
AddStatementTransaction
AddStatementTransaction (ref, date, tofrom, desc, amt) Use this function to add a transaction to a bank statement import. The function only works when a Load Statement dialog is open, so can only be used from a statement loading script. Statement … 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
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
ImportImage
ImportImage (tablename, key, path) ImportImage() loads an image file and attaches it to a transaction or item record. tablename is “transaction” or “product” key is the sequencenumber for a transaction or product code for a product path is the filesystem … 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
MoneyWorks supports sending mail on Mac via Apple Mail or Microsoft Outlook automatically (or direct via an SMTP server). But you may want to customise the way mail is sent. In MoneyWorks 7.1.6 there is an additional (simpler) way to … Continue reading