AnsweredAssumed Answered

Running Total with fields from different tables

Question asked by rounakjain on Apr 1, 2013
Latest reply on Apr 4, 2013 by philmodjunk

Title

Running Total with fields from different tables

Post

     Two Tables:
     Table X (Think of it as Purchase Invoice Table)
     Table Y (Think of it as Payment Voucher Table)

     No relationship defined yet between Table X and Table Y

     Table X Fields:
     1. Name
     2. Bill Amount
     3. Date
     and some other fields

     Table Y Fields:
     1. Name
     2. Payment Amount
     3. Date

     What I want:
     A ledger showing running balance of net payment.
     The ledger will be based on Name.
     Each portal line will have fields: X::Date, X::Bill Amount, Y::Date, Y::Payment Amount, Net Running Balance
      

Outcomes