Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Updating the Multiselect Subsidiary field on GL Accounts
I have a test CSV file with this one row:
"137","11|9|2|6|10|4|12"
I am trying to Update the Subsidiary field on one GL account (OneWorld) with an InternalID of 137.
I am using the pipe delimiter and those are InternalIDs of the Subsidiaries.
I map InternalID & Subsidiaries
I click pencil and change the reference type on Subsidiaries to "Internal ID"
I get this error message:
Unparseable Internal Id, did you mean to lookup this field by Name or External ID? for field "Subsidiaries"
It appears that NS will not accept InternalIDs delimited with pipe. Maybe the pipe delimeter method only works with the Name strings as the Reference type?
0