Reference number allocation

We sometimes get queries about gaps in reference number sequences. Why would MoneyWorks be so dumb as to skip reference numbers? In fact, reference number allocation is not that trivial. Consider the situation where you open 5 new invoice windows. … Continue reading

Posted in Database, Esoterica, Networking | Comments Off on Reference number allocation

XML data exchange

MoneyWorks 6.1 and later supports import and export of xml-formatted data. This removes the need to preconfigure an import map when building automated importing scripts (although you will still need to understand import maps). XML is the only import format … Continue reading

Posted in COM/VBS, Database, Esoterica, MWScript, REST, XML | Comments Off on XML data exchange

useDefaultPrinter

By default, on Windows, MoneyWorks will attempt to print to the same printer that any given report, form, or list was printed to last time. If this is not desirable, there is a preference for it, but there is no … Continue reading

Posted in Esoterica | Comments Off on useDefaultPrinter

OS X Server and folder permissions

It is strongly recommended that Datacentre data is stored in the standard location (/Library/MoneyWorks/Documents). If you store data in another location it is important that you ensure that the entire path to that location is searchable by the server user … Continue reading

Posted in Esoterica, Servers | Comments Off on OS X Server and folder permissions

DNS, if available, must be correct

Had an instance of mysterious "permissions error" when logging in to a 6.1 Mac server. Every time. Permissions were all correct. After some investigation, the problem turned out to be that the server had an incorrect DNS entry. Since MoneyWorks … Continue reading

Posted in Esoterica, Networking, Servers | Comments Off on DNS, if available, must be correct

Operand Type Gotcha

The Balance History from Date form previously had a bug in the case where a credit balance in the running balance column then gets a further credit added to it. The result is that the credit balance behaves as if … Continue reading

Posted in Esoterica | Comments Off on Operand Type Gotcha

Mapped drives

All too often we find that Windows Datacentre admins configure Datacentre to use "mapped drive" paths for Backups (or even for the Documents root). In the latter case, they soon find out that it doesn't work. In the former, they … Continue reading

Posted in Esoterica, Servers | Comments Off on Mapped drives

Relational Find for arbitrary link fields

When you do a relational find for anything that does not have a link that shows up in the Find Related dialog box, then you must explicitly provide the link fields. A good example of this is when finding Ledger … Continue reading

Posted in Database, Esoterica | Comments Off on Relational Find for arbitrary link fields

Downwards compatibility of documents

Now that all products use the same document type, it is perhaps less obvious when a document is not openable in Express after you have been making changes in Gold (because you no longer need to do a down-save which … Continue reading

Posted in Database, Esoterica | Comments Off on Downwards compatibility of documents

Silent installation

Our Windows installers (based on NSIS) have a "silent" mode that allows them to run from the command line without user interaction. This is enabled with the command switch /S. You can type, for example: "Install MoneyWorks Gold.exe" /S This … Continue reading

Posted in Esoterica | Comments Off on Silent installation