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

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.

Beginner Answered on May 12, 2021.
Add Comment

Your Answer

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