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

AI generated answer (using internal Slack threads):

To get the unapplied amount from a customer payment record to saved search results, you can use the 'Amount Remaining' field. This field shows the amount of the payment that has not been applied to any invoices or bills. 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. You then take max(Customer Deposit amount)-sum(applying amount) where the applying amounts is the total of all the Deposit Applications. Here is a sample of how you can set it up in the results tab of a saved search: 1. Set the 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. You can also use the 'Applied to ...' join to get details of what the Customer Deposit is applied to and the remaining (not applied) amount. For the applied amount of a Customer Deposit, you can use this formula:

{amount}-{amountpaid}

. This will give you the amount of the Customer Deposit that has been applied. Please note that these methods require some familiarity with NetSuite's saved search functionality and may require some tweaking to fit your specific needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******