Issue with Failed to create, update/transform record because Please enter value(s) for: Location

Integrator.io
,
1

Hi I am trying to finish a refund cash refund flow I get this error even when i have the good location in Failed to create, update/transform record because Please enter value(s) for: Location

I'm using Celigo to create a cashrefund in NetSuite and getting this error:

You have entered an Invalid Field Value 677 for the following field: location

The record is being created dynamically, and I’ve confirmed:

  • location ID 627 exists and is active
  • It is assigned to Subsidiary ID 2
  • The name of the location is "Refunds CA"
  • entity, account, and subsidiary are all present
  • I'm initializing values with celigo_initializeValues: subsidiary

Has anyone seen NetSuite still reject a valid internal ID for location in a dynamic record? Is there something else in Celigo mapping I might be missing (e.g., text vs. internal ID confusion)?
Celigo logs show:

> r.setValue({ fieldId: "location", value: "627" });




This is the output 
{
  "nlobjFieldIds": {
    "celigo_recordmode_dynamic": "true",
    "eTail Order Id": "[ID]",
    "custbody_refund_id": "[ID]",
    "subsidiary": 2,
    "trandate": "2025-06-02",
    "location": 627,
    "entity": 3571,
    "account": 115,
    "celigo_replaceAllLines_item": "true",
    "discountrate": "5.00",
    "currency": 1,
    "celigo_initializeValues": "subsidiary"
  },
  "nlobjSublistIds": {
    "item": {
      "lines": [
        {
          "item": "[ID]",
          "quantity": 1,
          "rate": 49
        }
      ]
    }
  }
}

I tried with location ID and with location Name as well  thank you I am completely at lost
2

Hi Kelly,
Thanks for sharing your issue here. It sounds like the Subsidiary may not be set properly before the location field mapping is attempted, since you mentioned the location is on Subsidiary ID 2.

Since dynamic mode is being used, one thing to check is that the order of your mappings set from top to bottom, i.e. your Subsidiary ID 2 mapping should be ABOVE the location mapping, and any other dependent mappings.

If you can provide screenshots of your mappings and also the full logs under the "View Request" tab on your error window, that may also help provide more insight.

Ah and one more key question -- Are you creating a stand-alone Cash Refund, or transforming it from another record, i.e. Sales Order, Cash Sale, etc? This will affect how the mappings need to be setup.

Best,
Simon