I have one complication when importing Credit Memos into NetSuite. The problem is, if I want to fill Apply line, internalId of credited Invoice is required. But I have only externalId. First idea is, to use a Map Function - Connector Call - Execute - getSelectValue. I hope I can make it use Invoice externalId as input and give me Invoice internalId as output. Unfortunately, without any luck so far. Is is possible? By the way, the externalId is also used as Invoice tranId. But when I set getSelecValue function like this:
recordType = invoice
field = tranId
operator = is
filterValue = <value from input csv file>
Then I get error: You do not have permissions to set a value for element tranid due to one of the following reasons: 1) The field is read-only; 2) An associated feature is disabled; 3) The field is available either when a record is created or updated, but not in both cases.
Any advice? I thought getSelectValue is not changing any values...
Thanks in advance...