AK47
12/22/2024, 11:53 PMCeligo AI
12/22/2024, 11:53 PMAI generated answer (using internal Slack threads):To create a saved search to show payments that have unapplied amounts, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the 'Transaction' type for the saved search. 3. In the 'Criteria' tab, add the following filters: - Type = Payment - Posting = Yes - Main Line = Yes - Amount Remaining (under Results) is greater than 0 4. In the 'Results' tab, you can add the fields you want to display in the search results. For example, you might want to include 'Name', 'Date', 'Amount', 'Amount Paid', and 'Amount Remaining'. For Customer Deposits, it's a bit more complex because they apply differently compared to other transactions. 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. To get details of what the Customer Deposit is applied to and the remaining (not applied) amount, you have to use the 'Applied to ...' join. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
12/22/2024, 11:53 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.843613923
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836643279
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83352989
Celigo AI
12/22/2024, 11:53 PM