Hi Guys,

I need some help!

On the customer statement there is the list of invoices what has not been paid yet. On the last columb we have balance, it is showing the balance for each invoices.

I need a balance what is adding the amounts together invoices by invoices, example:

CODE NAME Debit Payment Balance
I01 Invoice $5 $0 $5
I02 Invoice2 $7 $0 $12
I02 Invoice3 $10 $0 $22


How can I do this? I created a calculatedField but I dont now what I need to write on the Expression editor.

Please answer if you know anything ;)

Thank you xx

Hi!

Thank you, I found this field before but it's showing the total amount owed by cutomer. I need this option but this is already on the statement what is perfect.
What exactly I need is create a field what is counting the invoices one by one.

CODE NAME Debit Payment Balance
I01 Invoice1 $5 $0 $5
I02 Invoice2 $7 $0 $12 ---> Here you can see, it is not showing the balance of the invoice2, but is showing me the Invoice1+Invoice2
I03 Invoice3 $10 $0 $22 ---> Here is Invoice1+Invoice2+Invoice3

It would be amazing if you can help me on this.

Thank you Administrator!

x