AnsweredAssumed Answered

Showing current balance in a payment record

Question asked by carolynhaywood on Mar 13, 2010
Latest reply on Mar 14, 2010 by carolynhaywood


Showing current balance in a payment record


I have a payment table connected to a statement table (via statement ID) which is connected to an invoicing table via Invoice Id.


I have a portal based on payments on the invoicing layout in which I post payments and interest.  I want to see a current balance on  for each record but all I get is a new balance based on the current record.  My balance field is a calculation: Principal - sum(amount paid) + sum(interest).


Is there any way I can get this to work?



Carolyn Haywood



FMP 10 Advanced Mac 10.6.2