I have a FM 6 application where I need to present some summary data for
some accounting information.

There is a table that is a series of payments for an invoice where one
invoice can have multiple payments and hence multiple records in the
table. The data notionally looks like:

[cust a] [inv 1] [inv amt] [payment 1]
[cust a] [inv 1] [inv amt] [payment 2]
[cust a] [inv 1] [inv amt] [payment 3]
[cust a] [inv 1] [inv amt] [payment 4]
[cust a] [inv 2] [inv amt] [payment 1]
[cust a] [inv 2] [inv amt] [payment 2]
[cust a] [inv 2] [inv amt] [payment 3]

I want to produce a report layout as follows:

[Cust a] [inv 1] [inv amt] [payment total] [balance remaining]
[inv 2] [inv amt] [payment total] [balance remaining]
--------------------------------------------------------------
[tot inv] [tot payment] [total balance]

What I am currently getting is [tot inv] includes the invoice amount
multiple times (once per payment). How can I work around that?


thanks

pete

This is by no means elegant, but what you could do is copy the ID
Invoice of the found set of Payment records and put them into a global
text field in Payment.
Create a relationship from the global to the invoice ID in the Invoice
table.
Create a calc in Payment which sums the Invoice Amt using the above
mentioned relationship.

Peter,
Rather than explaining at length, I prefered to do an example that I
sent you personally. (It is also available to anyone asking me
privately)
It works, while I guess there are more elegant ways to do it as my way
to do it is a bit tricky.
Remi-Noel


"Peter Huish" <huish (AT) ozemail (DOT) com.au> a écrit...