Optimised searching

Posted on 25 May, 2011 by Rowan

Sometimes you need to do a search that involves a fast component and a very slow component. Maybe something like this detail.parentseq = transaction.sequencenumber and testflags(detail.flags, #0008) The problem with this search expression is that it defeats the search optimiser … Continue reading →

Posted in Esoterica | 1 Comment

Adding and removing Transaction images via script

Posted on 13 April, 2011 by Rowan

Although it is obvious that you can create transaction images yourself in the Pictures/Transactions folder (see also The Pictures Folder), MoneyWorks won't "see" the picture unless the fHasScan flag (= 0x00100000) is set in the flags field of the transaction. … Continue reading →

Posted in Database, Esoterica | Comments Off on Adding and removing Transaction images via script

Reports as Scripts

Posted on 12 April, 2011 by Rowan

By popular request (actually just multiple requests from Grant), from v6.0.6, you can run reports from the Command menu by placing them in the Scripts folder. The "No Dialog" report settings option—which used to completely suppress the report settings dialog … Continue reading →

Posted in Esoterica, Reporting | Comments Off on Reports as Scripts

The Pictures folder

Posted on 6 April, 2011 by Rowan

MoneyWorks currently stores 2 types of images. Transaction images and product images. These go in a subfolder of Custom Plugins called "Pictures for NAME", where NAME is the company name from the company details dialog box. If you change the … Continue reading →

Posted in Esoterica | Comments Off on The Pictures folder

Orphaned Branch Names

Posted on 6 April, 2011 by Rowan

The Headoffice-branch relationship is defined by the head-office code being e.g. "HEAD.", and branches being "HEAD.BRANCH". Any Name code with an internal dot is taken to be a branch of some head office. MoneyWorks now warns you about using internal … Continue reading →

Posted in Esoterica | Comments Off on Orphaned Branch Names