I need to put following info on an AR invoice- it will be more like a statement.
It needs to show current Invoice Amount, Previous balance, Total Amount due.
Also previous payment.
If I have a customer who had 0 balance it will show a negative on my Previous Balance field since my formula is BP Amount- Invoice Amount.
I need the formula to know if it is less then 0 not to put anyting on