Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to Calculate the Age of Customer?
I tried calculating the Age of the Customer under Validating and Defaulting tab but since the formula needs summary I created a saved search and pulled those values into a custom field in the Customer record using BEFORE LOAD user event script. Now, since that field's store value is unchecked (name it ABC) I couldn't source it into another search. So, I duplicated that field into another field whose store value is checked (name it XYZ) using WORKFLOW and hid the ABC field in Customer record. The problem here is since the script is BEFORE LOAD, I cannot run the