How to get a vendor list with amounts paid in past...
# ask-stanley-ai
f
How to get a vendor list with amounts paid in past 12 months (one vendor per line)
c
AI generated answer (using internal Slack threads):
To get a vendor list with amounts paid in the past 12 months, you can create a saved search in NetSuite. Here are the 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 is Payment - Date is within last fiscal year (or set a specific date range for the past 12 months) 4. On the Results subtab, add the following fields: - Name (Group) - Amount (Sum) 5. Save and run the search. This will give you a list of vendors with the total amount paid to each in the past 12 months. Each vendor will be listed on a separate line. Please note that this search will include all payments, not just those linked to bills. If you want to limit the search to bill payments, you can add another filter on the Criteria subtab: - Main Line is True This will exclude payments that are not linked to a bill's main line. ****** 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.822110057
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.815864146
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.813232243
Please provide your feedback on this answer.
f
I don't see the Criteria subtab