What is the formula expression or calculation for the native transaction search result column "amountremaining"?

AI generated answer (using internal Slack threads):

The native transaction search result column "amountremaining" represents the unallocated or remaining amount for a transaction. This is calculated as the total amount of the money received (Amount) minus the amount applied to Invoices (Amount Paid). In a saved search, you can use the result column Amount Remaining (Foreign Currency)

fxamountremaining

to get the same value as

amountremainingtotalbox

from a record load. For Vendor Prepayments, you can use the formula numeric:

amount - amount paid

to get the unapplied/remaining amount. Please note that for payment transactions, you need to set the criteria

Main Line = False

to get the correct "amountremaining" value. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******