balance formula for credit column and debit column in saved search for vendor

AI generated answer (using internal Slack threads):

In order to create a running balance column for debit and credit in a vendor transaction saved search, you can use a formula field. However, the formula will depend on the specific requirements of your saved search and the structure of your data. One approach is to create a Formula (Numeric) field in your saved search. The formula could be something like this:

case when {account.number} = '(insert your item asset account)' then 1 else 0 end

. This formula checks if the account number matches your item asset account, and if it does, it returns 1, otherwise it returns 0. This can be used to create a running balance. However, this is a simplified example and your actual formula might need to be more complex, especially if you need to accommodate for different locations and transaction types. For more detailed information and examples, you can refer to this blog post: https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/ ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******