Double Joins

Hello,

 

So I’m trying to pull information that essentially would be much easier if I could use a double join in NetSuite.

I have a Customer Search that has been requested to show the date a specific type of Project Task was completed “Install Start” being the task.

 

Without being able to utilize double joins is there any way VIA formula that I can pull this information?

 

Thank you,

Beginner Asked on February 10, 2020 in Saved Searches.
Add Comment
1 Answer(s)
Best answer

If your customer is tied to the project, start your search there, and go one way each direction.  Otherwise, sounds like you need to use Analytics module and represent your data differently.

Intermediate Answered on February 10, 2020.

The Customer and Project are tied to each other, yes. Problem is that the end destination is a project task field technically. Only route I can find that makes sense with what is in the system currently is;

Customer > Project > Project task.

The other information that is desired dictates that it has to be a customer search.

 

The trouble is that I know that this has been achieved in one way or another in the past, the employee requesting this sent me a copy of an Excel export pulled from it, but I checked the audit log and couldn’t find much.

 

Only thing I can think of is if I make a field that links the data from the task to the customer or project level, but that’s an adjustment I would need high level approval to make of course..

on February 10, 2020.

Both sides needed are linked to the Project, start there.  You can go either direction one way to get the necessary data.  Also, if someone sent you an excel, that does not mean the information was pulled in one search.

on February 10, 2020.

I see what you’re saying. I will take a closer look at the search, I just believe there is other information joined from other customer- adjacent fields.

 

We found that the issue was that another field connected to the project task completion date was not pulling the information correctly.

on February 11, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor