Is this a defect in the latest Celigo NetSuite bun...
# integrationsc
Craig
10/12/2023, 11:39 AMIs this a defect in the latest Celigo NetSuite bundle?
Craig
10/12/2023, 11:40 AMThe configuration UI shows the status values for the order status which means Celigo can see all available statuses. I am surprised to get an error on import from this field.
Craig
10/12/2023, 11:41 AMI selected "Pending Fulfillment" which gets converted into "B" in the import mapping.
m
mightyd3
10/12/2023, 12:41 PMI received this same error setting IF’s to the internal id. Switching to “shipped” for example, fixed it for me.
c
Craig
10/12/2023, 1:36 PMDid you map that to the orderstatus.name instead of the orderstatus.internalid ?
Craig
10/12/2023, 1:37 PMName also failed with "B" but I could try the label name "Pending Fulfillment". Celigo shouldn't offer the status code mapping to internal ID if it can't do it. It looks like a SuiteScript error that's bubbling up to the surface.
m
mightyd3
10/12/2023, 1:38 PMYes, because it wouldn’t work otherwise.
mightyd3
10/12/2023, 1:38 PMStatus (InternalId) just wouldn’t work. I struggled for a long time to figure that one out.
c
Craig
10/12/2023, 2:54 PMThe mapping against the name didn't work
Craig
10/12/2023, 2:54 PMSo I created a workflow in NetSuite to set the status on the sales order
t
Tyler Lamparter
10/12/2023, 3:36 PMc
Craig
10/12/2023, 4:11 PM@Tyler Lamparter I can't persuade anyone to let me remove the workflow in NS but I'm sure your solution would have worked. I'll remember it for next time,
t
Tyler Lamparter
10/12/2023, 4:15 PMSounds good. The reason to use dynamic is this getSelectOptions only works in dynamic and I guess we use this function when some list fields like status are referenced
👍 1
c
Craig
10/12/2023, 4:17 PMI did have a feeling the constraint was on the NS side, I hadn't considered standard vs dynamic mode though
👍 1