How to create saved search that shows ending balances based on subsidiary even when the amount is zero?

AI generated answer (using internal Slack threads):

To create a saved search that shows ending balances based on subsidiary even when the amount is zero, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the 'Transaction' record type. 3. In the 'Criteria' tab, set the 'Account Type' to 'Bank'. 4. In the 'Results' tab, add the following fields: - 'Name' (this will display the vendor name) - 'Subsidiary' (this will display the subsidiary) - 'Amount (Credit)' (this will display the credit amount) - 'Amount (Debit)' (this will display the debit amount) 5. To calculate the running balance, you can use a formula field. Click on 'Formula (Numeric)' and use the following formula:

NVL({creditamount},0) - NVL({debitamount},0)

. This formula will subtract the debit amount from the credit amount. The

NVL

function is used to replace null values with zero. 6. Set the 'Summary Type' of the formula field to 'Sum'. This will calculate the total balance for each vendor and subsidiary. 7. In the 'Available Filters' tab, add the 'Subsidiary' field. This will allow you to filter the results by subsidiary. Please note that this saved search will show the ending balances for each vendor and subsidiary, even when the amount is zero. If a vendor has multiple subsidiaries, there will be a separate line for each subsidiary. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

this is not working