How do you get unapplied amount from payment record to saved search results

AI generated answer (using internal Slack threads):

To get the unapplied amount from a payment record to saved search results, you can use the 'Amount Remaining' field. This field shows the remaining unapplied amount of the payment. For Customer Deposits, it's a bit more complex as they apply differently compared to other transactions. 'Amount Remaining' doesn't apply to Customer Deposits. You might need to do a grouped search summarizing Deposit Application(s) applied against the Customer Deposit. This can be done via the 'Applying' join. Then, calculate the difference between the maximum Customer Deposit amount and the sum of the applying amount. The applying amount is the total of all the Deposit Applications. Here's a brief guide on how to do it: 1. Set your criteria to Type=Customer Deposit and Posting=Yes. 2. In the results tab, use the fields with the (...) after them at the bottom of the field list. These are the joins. 3. Use the 'Applied to ...' join to get details of what the Customer Deposit is applied to and the remaining (not applied) amount. Please note that if you're trying to get the unapplied amount from a Payment onto a sublist view, you might encounter issues where the first result shows a blank under the Unapplied amount. This is because the first line gets pulled onto the sublist. However, subsequent lines should display the unapplied amount correctly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******