AnsweredAssumed Answered

Running Outstanding Balance

Question asked by brentjohn on Sep 23, 2012
Latest reply on Sep 24, 2012 by brentjohn

Title

Running Outstanding Balance

Post

     Greetings,

     I have spent the last 3 days searching the FM Forum (as well as other FM forums) for a solution to me problem:

     I have 2 tables –

      

     Table #1: ProjectSetUp

     Field:PS_Name(text)

     Field:PS_Labor(number)

     Field:PS_Material(number)

     Field:PS_Amount(cal: ps_labor +ps_ material)

     Plus several other fields not relevant to my issue.

      

     Table #2: PaymentRec

     Field:PR_Name(text) drop down list with names from table #1

     Field:PR_Paid(number)

     Field:PR_Prev_Bal(look up PS_Amount {from table #1 through a relation based on PS_Name = PR_Name})

     Field:PR_Bal(cal: pr_prev_bal – pr_paid)

     Plus several other fields not relevant to my issue.

      

     What I want to do is create a running outstanding balance of PS_Amount for future payments.

      

     HELP!

Outcomes