We can in fact design reports around any file in MoneyWorks, allowing for Customer, Product and Job reports amongst others. To illustrate this, we’ll write a quick report to show our top debtors.
To do this you can either create a new custom report (choose File>New>New Custom Report), or just append the required parts onto the bottom of the report we have just created.
In the previous section we only looked at the general ledger. Now we want to step through each of our customers. To do this we use the For Each part, which steps through each record of the nominated file that meets a specified criteria.
This is going to step through each customer (i.e. each record in the Name file) which has a DBalance value greater than zero (i.e. they owe us something). This is sorted by the amount owed (note that we have set the sort to
descending). We have named the current record being processed CUST so that we can refer to it in later calculations.
When the report is printed, MoneyWorks will evaluate this formula, which will give us the value of the code field in the name record being processed.
We’ll put the name and balance in columns 2 and 3 of the report—if you are creating a new report, you will need to append a couple of columns.
You should have something like:
This is where the For Loop terminates. Basically every report part between the For Each and the End For is processed for each record found in the file (or list) that the For Loop is traversing.
You should get a list of everyone who owes you anything. We want to limit the report to just those who owe more than a specified amount, which we will enter when the report runs. Such a custom setting is done in the report Settings.
A My Checkbox custom setting will appear in the list
When we run the report, we can now enter a number into MinBal. We just need to change the For Each loop to only search for balances that exceed this value.
The report only lists customers who owe more than the balance entered.
From this, you should have got a hint of the awesome power and flexibility that is available to you in report design in MoneyWorks. We’ve only skimmed the surface—for a more technical discussion see Custom Reports.