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.