In NetSuite, we calculate the average daily balance of an Entity based on the following conditions.
- Find the opening balance of the entity from which average daily fund balance has to be calculated.
- Use the opening balance to find the balance for 1st day.
- Use another saved search to finf the transactions made in the selected period.