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
I ended up using the Foreign Currency fields, which resolved most of the discrepancy between the Search and the Customer. Netsuite seems to love not being clear sometimes, about what currency a particular value is in.
case when trunc({today})-{duedate} between 1 and 30 then {fxamount} - {fxamountpaid} end
I still have an issue with the Criteria, it seems other than Account and Status, there is something else that Netsuite uses for the Over 91 range.
I pulled all the relevant transactions, but I could not see any combination that would come up with the result I needed.