I've been working (for some time!) on creating a personal accounts solution and I'm currently into my second revision.

One table is given over to Petty Cash transactions.

Petty cash has been isolated from two other transaction tables in order to produce two separate results.

1) Sending some detail along with other summarised info, via scripting, to another table. [Currently successful.]

2) Producing a monthly statement for printing, inclusive of running totals, brought forward and carry forward totals - and this is where the problem is.

I have been able to create a working report from within the Petty Cash table utilising a sub-summary part and breaking after each month, but this relies on all the records being present to keep the running totals right, whereas the script relies on a find based on a given 'month', which breaks all the running totals...

I thought the solution might be to create a second table related by 'month' and show records in a portal. This works in part, but the running balance calc won't carry forward into month 2.

Why won't my portal behave like the report?

Is the relationship wrong?

Is my maths wrong?

Does this need a custom recursive function?

Any help, suggestions or pointers would be gratefully received.

Accounts.fp7.zip

Hi,

I'm facing the same problem, did you manage to get a solution?

Regards,

Garry

In the absence of being steered in the right direction and following much effort on making the portal totals work, I was forced to conclude that a portal won't do it.

It may be that my maths and/or my logic is not up to the task, but with only me to talk to...

However, having dismissed the portal route, I was able to produce pretty-much what I wanted via sub-summary parts. All the math stands up and the report prints exactly as intended. Any finds which would affect running totals, don't rely on those running totals; so all is good, for the moment!

I am close to the point where I have to join two tables together for both quarter and annual summary overviews, but at this point I can't see that this is any more of a problem than the one I worked around!

I've just taken a look at your query. I'll have a little think about it...