Scenario:
A user has an Approval Workflow that will set the Next Approver on the Bill record. The user to be set as the Next Approver can be found on the Subsidiary record under a custom field. That custom field has a value of Employee list.
For example: The employee set on the subsidiary is ‘Jane Doe’. This means, Jane Doe should be set as the Next Approver on the Bill record.
When the workflow is initiated, the user will get an error: “Invalid nextapprover reference key Jane Doe”. Usually, if a user gets this error, this means the user being set is an inactive user. However, Jane Doe is not.
Solution :
In order for the Next Approver to appear, add ‘id’ on the formula:
{subsidiary.custrecord_internalId.id}
The user is getting an error because the formula is looking for a name on that custom field. However, the custom field on the Subsidiary record has a value of the internal Id and not the actual name of the user.