I have an invoicing solution and need to put a summary of all outstanding balances on the invoice layout that I send to the client. I send the invoices out monthly and do a find to print all the current invoices for that month. The problem is that when i do that find, it doesn't let me show a summary of each clients outstanding balances. Only shows for the current month.

Thanks

You can create a self join for the invoice TO keyed on the ClientID. Then you can use a summary field from the Self Join TO for your total outstanding balance for each Client ID for your found set.