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.

Daryl Beginner Asked on May 9, 2021 in Saved Searches.
Add Comment
2 Answers

Try this,

case when {daysoverdue} < 30 then (round(to_char({amount}-{amountpaid}),2)) else 0 end

Rookie Answered on May 12, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.