How do I pull the date a vendor bill was paid by joining the related record of vendor payment. I want to be able to see the bill date, posting date, and the date the bill was paid on an income statement

AI generated answer (using internal Slack threads):

To pull the date a vendor bill was paid, you can create a saved search with a join to the Transactions. Here are the steps: 1. Go to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction as the type of search. 3. In the Criteria subtab, add the following filters: - Type = Vendor Bill - Main Line = True 4. In the Results subtab, add the following fields: - Date (this is the bill date) - Posting Period (this is the posting date) 5. To get the date the bill was paid, you need to join to the related record of vendor payment. Add a new field in the Results subtab: - Field: Date - Summary Type: Maximum - Function: Transaction Fields... > Payment 6. Save and run the search. This will give you a list of vendor bills with the bill date, posting date, and the date the bill was paid. If a bill has multiple payments, the Maximum summary type on the Date field will ensure that only the most recent payment date is shown. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******