Suiteanswer 85431: It gives a description of how to create an aging balance with a saved search. All the currency formulas however, returns an error message (Error, field not found). It is a transaction saved search, and here is the formula for current open balance: Case When substr({‌amount},1,1) = '-' and (NVL({‌daysoverdue}, Round({‌today}-{‌trandate}, 0))) < 1 then ({‌amountremaining}*-1) When substr({‌amount},1,1) <> '-' and (NVL({‌daysoverdue}, Round({‌today}-{‌trandate}, 0))) < 1 then {‌amountremaining} else 0 end Can't figure out why. I think it has to do with the substring-thing, but not sure.

have you tried, removing everything then slowly adding it 1 by 1? Maybe, it can help you check where is the real error is