I'm trying to work around the issue of tracking new Customers that have $0 sales (i.e. we sent samples etc).
1) I understand you can't retrieve a saved search populated value in another saved search - that is ultimately what I'm trying to do, or find a work around. Limitations - https://netsuite.custhelp.com/app/answers/detail/a_id/31727
2) Created a customer field on the customer form, and Saved Search to populate per this article:
Display the First Transaction Date of a Customer on the Customer Record https://netsuite.custhelp.com/app/answers/detail/a_id/92014
2) I followed this train of thought: Display Summary Search Results in Custom Body Field with Store Value Checked - https://netsuite.custhelp.com/app/answers/detail/a_id/76655
The problem is the values never copy over, either on a record save, or when I setup a CSV import to exercise the customer records.
I've tried sourcing using the "from field", using formula {entity_id_name}, {entity internal id}
Basically I want to setup a excercie script that touches every customer (to preload the data one record at a time using the above copy from hidden (search populated) to visible (stored) value, and after complete, I'll just change the workflow to just fire on invoices/sales orders.
I know the workflow is triggering as the log says so... so it must be something in how I'm sourcing or it just won't work on an exercise (workflow execution enabled on csv imports).
I'm sure I could to it by exporting all SO and CS in netsuite, and taking the minimum dates, doing a pivot table and reimporting, but that still doesn't solve the problem after the initial import...
Thoughts?