creating a "Balance Due" for a Payment History Report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Day,

I have a report that show payment history for customer invoices. on this
report I have the following field pulled from tblpaymenthistory:

paymentnumber
paymentdate
paymentamount
invoicetotal

For each payment that is made, I would like a field to show a running
"Balance Due"

I have looked the group, but cannot find what I am looking for.

Can anyone pass any suggestions?

Thanks,

Brook
 
Brook said:
I have a report that show payment history for customer invoices. on this
report I have the following field pulled from tblpaymenthistory:

paymentnumber
paymentdate
paymentamount
invoicetotal

For each payment that is made, I would like a field to show a running
"Balance Due"
Click to expand...


Presumably, InvoiceTotal is the amount due. If so, you can
add a (invisible?) text box named txtRunPaid bound to the
PaymentAmount field and set its RunningSum property to Over
Group.

The running amount due text box can the use the expression:

=InvoiceTotal - txtRunPaid
 
Back
Top