NetSuite Sales Order Item Location - "I feel like I'm taking crazy pills!!"
Hello,
Humorous movie clip: if "Dumb & Dumber" isn't in your top 10, don't bother clicking.
https://www.youtube.com/watch?v=a-w6nSgJLmU
I'm working on a request to update the Location on the Items sublist on a sales order in NetSuite and NOT making it very far! LOL, I must be missing something, but in the mapping I cannot find 'Items : Inventory Location' or 'Items : Location' in the list. I've refreshed the field list, tried different account, etc. - it's not there. But it must be, I can't imagine that Celigo wouldn't support setting the Location on the Item sublist. It's supported in SuiteScript and SuiteTalk, so why wouldn't it be there?
Is it known by some other name? What am I missing?
0
Comments
Steve Klett this what you're looking for?
Steve Klett maybe try hardcoding to the field id like this?
Tyler Lamparter it sure is, but I don't have it:
Tyler Lamparter I appreciate the replies! I tried similar hardcoding but the preview shows its interpreted as a body field.
Steve Klett, sorry I forgot the star.
Tyler Lamparter You're the man! The hard coding worked. I'd feel a little better if the field was showing up in the list, but it's working so that's what matters. Thank you for your help on this.
Celigo pulls the field list from the NetSuite UI.
So if the field is not visible on the NetSuite Sales Order form that your integration user is using, it wont show up in the suggested field list in Celigo.
Log in as the integration user and unhide the field on the form, and then it should be visible in Celigo as well.
Thanks Bas van Ditzhuijzen, that was the issue. I checked the default form but there was a Role preference for another form, so I missed it. I appreciate the help. This community is great. :)
Please sign in to leave a comment.