This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone know why I am getting this error trying to create a customer payment in a map/reduce script specifically?
```"name":"INVALID_FLD_VALUE","message":"You have entered an Invalid Field Value 2285 for the following field: customer"```

Super basic code is:
```var paymentRecord = record.create({ type: 'customerpayment', isDynamic: true })
paymentRecord.setValue('customer', customerId)```
given the customer _seems_ to be perfectly valid?

I can create a payment from that customer in the UI or browser console using transform just fine?

Screen Shot 2023-11-09 at 1.54.44 PM.png

Screen Shot 2023-11-09 at 1.55.05 PM.png

Using record.transform in the map/reduce gave me the dreaded UNEXPECTED_ERROR which is why I switched to create/setValue

And doing create/setValue in console times out (which sucks but suggests the opposite of an invalid customer value)

added a log.audit in the script to confirm the variable value-
```Audit	customerId - 2285	type - string```
(and checked typeof to get string)

I don't think what you're doing is possible. A customer payment is a transaction and a customer is an entity. How the one would become the other doesn't seem possible to me.

? It's one of the standard transform actions. But even if not what I'm doing in the script is creating a customer payment record and adding the customer (field is `customer` not `entity` in this case I think?)

Screen Shot 2023-11-09 at 1.59.31 PM.png

weird what you're doing is almost exactly what they have in the docs

<https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4267258715.html#bridgehead_4426068347>

Yeah this should be super standard/basic from my understanding/past experience

*Note:* When you use this transformation, do not use <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4273155868.html|Record.setValue(options)> to set the value of the `customer` field on the resulting Customer Payment record. This field is populated automatically during transformation, and you cannot specify a value for this field after the transformation is complete.

your first reply appears to be doing that

```var paymentRecord = record.create({ type: 'customerpayment', isDynamic: true })
paymentRecord.setValue('customer', customerId)```
is not using transform

That's a basic create record and set value. When I try using `transform` I do not set the customer record via setValue. Both should yield me the same result

sorry, i shouldn't have chimed in. never used the transform API

No worries, I appreciate your time and help reptar!

Screen Shot 2023-11-09 at 2.08.27 PM.png

I ran the code in the script debugger and it worked fine too??

I figured it out, there was something wrong with the value being passed. I think some sort of extraneous spacing somewhere