RE: Customer Aging Saved Search
I’m attempting to recreate the aging fields on a Customer, under Financial, but I’m having trouble getting the Saved Search to match the Customer Record.
I did Google Search and found quite a few results where they used the below case statement in the search.
case when trunc({today})-{duedate} between 1 and 30 then {amount} end
No one else seems to have a different solution though, so I though I’d ask here.
Try this,
case when {daysoverdue} < 30 then (round(to_char({amount}-{amountpaid}),2)) else 0 end