How to pull the number of vendor payments per active vendor for the past 3 years

AI generated answer (using internal Slack threads):

To pull the number of vendor payments per active vendor for the past 3 years, 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 Bill Payment - Date: within the last 3 fiscal years - Status: any of Paid In Full - Main Line: is true (to exclude tax lines, shipping lines, etc.) 4. On the Results subtab, set the following columns: - Vendor (Group) - Internal ID (Count, Summary Type) 5. Save and Run the search. This will give you a list of active vendors and the count of their payments in the last 3 fiscal years. Please note that this search will only include vendors that have had at least one payment in the last 3 years. If you want to include all active vendors, regardless of whether they've had a payment or not, you would need to create a Vendor saved search and use a Summary Type of Count on the Internal ID field, with a Criteria where the Vendor Status is Active. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******