On the customer statement report, it shows:
Debit Date and amount for the invoice
Credit Date (receipt date) and amount received.
It does not show the Custom Field “MAAA Number” which is set at Position 1 on the Customer File (I had previously said “VMAA” but it is in fact “MAAA” in the field I am interested in. Sorry, my error).
Therefore in answer to your question, I receipt funds via the Debtors Invoice “Receive Money” option and the invoice itself includes the above fields (including the MAAA number being the custom field in position 1 on the invoice). Receipt Date & $ amount are entered as the second step of this option.
Am I correct in understanding that you want a single report that shows the listed information for all members in one list?
Because if all you are trying to do is get your MAAA number on a statement, you could put that into the address block and it will appear along with the address. The Transactions option for customer statements shows debits and credits.
Yes I need a single report showing all the listed information for all paid up members.
The background is that we are required to provide this information to the State Co-ordinating body before they will insure us for our activity which is flying RC model aircraft. There is a substantial Public Liability insurance issue with regard to this activity and it is managed at State level. To date we have been cobbling this together for 220 members manually via Excel by drawing data from reports in the Manager system but this is not feasible in the long term as our club grows and attracts more members.
It’s great software and a credit to you but, like all systems, it can’t provide for all user needs off the shelf.
I can’t think of a way to get a report like that. Maybe you’ll be able to do it in custom reports, but there isn’t any documentation on that yet. However, if all the necessary data is in the file somewhere, I’d bet it can be done. I just don’t know how.