I have been asked to create a validation saved search to prove that the fields in the Advanced SS that we hid in the Advanced Journal Record, Schedule, Start Date, End Date, Residual and Related Asset have no legacy data in them.
Not as simple as it sounds. I was able to pull:
Amoritization Schedule:Number = Schedule
Related Asset:Name = Related Asset
Amortization Schedule:Date = Start Date
Amortization Schedul:Residual = Residual
I can't find the End Date in the Line Item fields.
I have looked through the NetSuite Schema Browser and it is clearly identified as under the Lines:Lines Join, however we don't have a Lines:Lines Join.
No End Date under Amortization:
No End Date under File (Line) Field
No Line Join
Not in Item Join
- How do you determine what join the field is located in when adjusting Results in SS?
- I tried the start and end dates in the main record and that was unsuccessful
- I tried looking through multiple Join tables, but I either missed it or just can't find it
- There is no transaction join table
- I looked at the Back-end of the form and the field is located under the lines subtab
I figured 6 hours of looking was enough.
Any ideas?