formula in a saved search to show the payment deposited but not applied

AI generated answer (using internal Slack threads):

To create a formula in a saved search to show the payment deposited but not applied, you can use a formula field in your saved search. The formula would be something like this:

max({total}) - sum({applyingtransaction.amount})

. This formula calculates the difference between the total payment and the amount that has been applied. If you want to highlight all orders with less than $5 balance, you can use the highlighting subtab under the summary tab in your saved search. You would set the condition to be

max({total}) - sum({applyingtransaction.amount}) < 5

. Please note that

{total}

refers to the total payment and

{applyingtransaction.amount}

refers to the amount of the payment that has been applied. You might need to adjust these field references based on your specific NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******