I have a saved search of invoices and payments for a certain time period and am trying to get an actual amount but the payment amounts are being added to the invoice amounts and my final total is not correct. How can I have the payment amount be treated as a negative?

So there's two ways to fix this most straight-forward way is to use a formula column to the tune of:

{amount} * DECODE({type},'Payment', -1, 1)

(or similar) This will invert the amount value when the transaction type is "Payment" However, you should also find that, when you add the

account

field to your search results, your amount field should be negative next to the crediting account and positive next to the debiting account. You can setup your criteria to filter for the account being credited (payment) and debited (invoice) ("Accounts Receivable"?)