Advanced Saved Search Advanced Journal Entry
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.