saved search for days between invoicing transactio...
# ask-stanley-ai
n
saved search for days between invoicing transactions
c
AI generated answer (using internal Slack threads):
To create a saved search for days between invoicing transactions, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction as the type of search. 3. On the Criteria subtab, set the following filters: - Type = Invoice - Main Line = True - Date = relative date range (e.g., on or after 30 days ago) For the summary criteria, you can use: - Maximum (date) is before today - Count (transactions) > 20 This will give you a list of invoices that were open before a certain date. If you want to find customers with overdue balances that have not made a payment in 45 days, you can add these additional filters: - Due Date > 45 days - Status = Open To check if a payment was made on a different invoice, you can use the 'Applied To Transaction' field with a date filter. Remember to set the 'Main Line' filter to False if you're not getting any results. This is because the 'Main Line' filter determines whether the search results include line-level information or not. ****** 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.840418
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838116884
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83158046
Please provide your feedback on this answer.