How to build saved search report for amount paid o...
# ask-stanley-ai
k
How to build saved search report for amount paid on invoices
c
AI generated answer (using internal Slack threads):
To build a saved search report for the amount paid on invoices, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction from the list. 3. In the Criteria subtab, set the following: - Type is Invoice - Status is Paid In Full or Partially Paid (based on your requirement) 4. In the Results subtab, you can add the fields you want to display in your report. For the amount paid, you can add the following fields: - Amount (This is the total amount of the invoice) - Amount Paid (This is the amount that has been paid on the invoice) - Amount Remaining (This is the amount that is still due on the invoice) 5. You can also add a Summary Type to these fields, such as Sum, to get the total amount, total amount paid, and total amount remaining across all invoices. 6. Save and Run the search. Remember, you can also use formulas, conditional highlighting, and filters to make your saved search more robust and tailored to your 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. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847912669
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847631812
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.84649086
Please provide your feedback on this answer.