how to calculate the opening and closing balances using saved search for vendors based on account payable and advance payment account only lines

AI generated answer (using internal Slack threads):

To calculate the opening and closing balances using a saved search for vendors based on account payable and advance payment account only lines, you can follow these steps: 1. Create a Transaction Saved Search. 2. In the criteria, select 'Account' and set it to 'Accounts Payable' and 'Advance Payment Account'. 3. In the results, add 'Name' (which is the vendor), 'Date', 'Debit Amount', and 'Credit Amount'. 4. To calculate the opening balance, you can use a formula field with the formula

SUM({amount})

and set the summary type to 'Group'. This will give you the total amount for each vendor at the start of the period. 5. To calculate the closing balance, you can add another formula field with the formula

SUM({amount})

and set the summary type to 'Group'. This will give you the total amount for each vendor at the end of the period. 6. To get a running balance, you can use a formula field with the formula

SUM({amount}) OVER (PARTITION BY {name} ORDER BY {trandate} ROWS UNBOUNDED PRECEDING)

. This will give you a running total for each vendor. Please note that this is a general approach and you might need to adjust it based on your specific requirements and the structure of your data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******