Custom Debtor Reports using Custom Lists

Hi,

I've been a MYOB user for 10+ years, but mostly as an accountant in practice, so my ability to get information out of AR is much greater that to get it in! I'm now in commerce and on "the other side", and my ability is being tested!

I have a specific issue that I know can be solved with external applications, but I've been asked to see if it can be done within MYOB.

The situation is this:

1. We have a large number of customers who we charge for 3 separate items - say, A, B and C
2. Item A is billed weekly and everyone pays on time
3. Item B is billed quarterly, and some people pay on time, some by instalment, and some need chasing
4. Item C is billed monthly. However, some customers are eligible for government assistance for this item and receive an annual credit for it at the beginning of the year - in practice, we receive the actual funds, deposit them in our bank account and then allocate them as a POA against the relevant customer. When we produce the monthly invoices they then effectively reduce this credit - nothing is paid by the customer for this item

We need to be able to produce customer reports that show, for each customer for a specific period, the three different income streams A, B and C with b/fwd balances, invoices issued in the period, any payments allocated against them, any government credits relating to that item, and the balance outstanding at the end of the period for each item A, B and C.

In particular, a customer might owe us money for item B, but as they have received a large government rebate for item C, overall their account is in credit if we just run the aged receivables report - we need to know that they actually owe us for item B and chase payment, and that the credit for item C needs to sit on the account until the monthly invoices have been issued for item C, using up this credit.

Is this possible? If so, how do I go about creating such a report? I assume I need to use custom fields and items, but I've played around with it and can't get it to do what I want it to!

Thanks for your help!