AnsweredAssumed Answered

getSelectValue to retrieve invoice internalId using externalId

Question asked by ivo.fandel123456 on Apr 11, 2017
Latest reply on Apr 20, 2017 by ivo.fandel123456

Hi everybody,

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:

where:

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...

Outcomes