MoneyWorks support
Connecting to Datacentre
Datacentre connections must be negotiated through the normal Datacentre port (6699). Some earlier versions of MoneyWorks Datacentre* inadvertently allowed a client to directly connect to the database daemon port (e.g. 6674) without going through the Datacentre login process. i.e manual … Continue reading
Crash recovery
After a crash or power loss, Moneyworks will normally recover unsaved changes from the session file the next time a document is opened. There is a confirmation UI if you open the file directly. If the file is opened in … Continue reading
Stickies
I shouldn't tell you this, because the knowledge is open to extreme abuse by the irresponsible... Displaying sticky notes in a list column This is for transactions (directly owned sticky notes) Find("Stickies.Message", "FileNum=5 and OwnerSeq="+SequenceNumber, 9) File number 5 is … Continue reading
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
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
Report Writer: For loop redux
The For loop in the MoneyWorks report writer can be used in several different ways: Iterate over records in a table in the database. You select the table and specify a search expression to select records, an optional sort (up … Continue reading
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
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
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
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