Afternoon,
I'm hoping that someone can help me with what I thought should be a relatively easy process.
I'm looking to automatically create a case in NetSuite based on the change of a field on a Sub Partner record.
My State uses Record Type Partner, Event Definition is on View or Update. I've created a workflow using Create Record Type with a status which looks at the change of a field on the Sub Partner Record. My Parameter is Record Type Case.
My issue starts for field Company , if I manually create a case the data structure is
Sub Partner Acc Number Parent : Sub Partner Acc Name
If I set the field value to Company I get an error on execution Please enter value for Company. If I set my field value to Parent I get the same error.
If I set the Formula to {companyname} I get Invalid Reference Key. If I set the Formula field to {entityid}||' '||{parent}||' '||{altname} I think I get pretty close but the Parent value includes the Parent Acc No as well as the Name and its just the name I need.
I'm sure their has got to be an easier way of doing this and any help would be warmly received