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

Title

Showing current balance in a payment record

Post

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?

 

Thanks,

Carolyn Haywood

Beginner

 

FMP 10 Advanced Mac 10.6.2

Outcomes