Discussions
"Amount Paid" Value for Vendor Credits in Saved Search Shows as Positive
Hello!
I am trying to create a saved search that acts as a payment register (shows all vendor invoices, the payment date, paid amount, cheque #, etc).
An issue that I keep running into is that the "Amount Paid" for vendor credits shows up as a positive value, rather than a negative. My Amount Remaining field is a formula due to occasionally doing partial payments:
{amount}-{amountpaid}
so it's resulting in a negative balance of double the original amount.
For example:
Original credit amount: ($100.00)
Amount Paid: $100.00
Amount Remaining: ($200.00).
Any insight on fixing the paid value of these credits would be much appreciated.