CODEWITHSUNDEEP
csvnetsuiteimport-csv
Adriano Reis
Adriano Reis

Reputation: 35

NetSuite - CSV Import

I have this search in NetSuite:

enter image description here

Through it down the csv file to update the estimated cost of the invoices. However, it is giving this import error:

Invalid entity reference key "2966894" for subsidiary 1

enter image description here, because in the NetSuite wizard I am not able to map the subsidiary field

enter image description here

Upvotes: 2

Views: 3006

Answers (3)

Adriano Reis
Adriano Reis

Reputation: 35

Was solved. What happens is that in the spreadsheet the Est Extended Cost field had to be as "Custom". In this case it would take 2 updates: one to zero costs and another to update according to the Average Cost. Thank you all.

Upvotes: 0

Sciuridae54696d
Sciuridae54696d

Reputation: 66

Let's pick apart your error.

At quick glance. Invalid entity reference key "2966894" for subsidiary 1

You can check SuiteAnswer ID 35887.

1) In there I would check first, if subsidiary "1" is active. if entity "2966894" is active.

2) Then I would check, if entity "2966894" has subsidiary of "1"

3) Do you have multi-subsidiary customer enabled? I would still change the field on the body of entity "2966894" to the "Brasil" subsidiary first. And then run the test.

Hope this helps pal!

Upvotes: 1

Jdg50
Jdg50

Reputation: 448

You're mapping "2966894" to cliente, which I assume is the entity/customer id.

Click the little pencil next to cliente and switch it to "Internal ID". It shouldn't be "Names". I would also ensure that the ID you're mapping to is a current and active record.

Upvotes: 0

Related Questions