Hey... having a weird bug that is an open case but we are still struggling. We import Sales Orders from Shopify and we set the shipping cost manually. When we perform any edit to the sales order it reverts the shipping cost to waht is in the Netsuite Shipping Items list for that shipping method. Only started happening early last week. Is this happening for anyone else?

We had a user report something that I believe is the same issue though I haven't been able to verify it. Has support's response been of any use so far?

This has been happening to us as well. For a magento integration but otherwise the exact same issue - started on 6/13. I'm trying to get an answer from support now - if y'all learn anything, would love to hear it.

support is saying the issue is with one of user event scripts but I call BS. They have shown in their QA environment that by disabling all of our scripts it doesn't exhibit that behaviour, however, my gut tells me they our scripts are not the issue. I made no changes to any scripts last week

we are using avalara, yes. my rep has at least admitted it may not be a script issue, which i agree - we haven't touched any scripts in like 2 years so i know for a fact it's not a script issue.

We also use Avalara, though we haven't updated the bundle in over 3 months so I'd be surprised if this issue was due to something on their end. We do update our scripts pretty often but I haven't made any changes recently that should be affecting the shipping charge, and we don't have any scripts that set the shipping item so I'm confident it's not an issue in our scripts.

no defect number yet 🙃 if I do get one i'll share it here so y'all can tie your cases to it as well

I have a case number but have not heard back if they have filed a defect

I filed Case 3457211 yesterday, but haven't heard anything substantive back yet.

my case # is 3456135 - i've been able to show in Sandbox that the same behavior occurs outside of a script as well, so I'm hoping they will file a defect soon.

Thanks

Thanks! i've also shared both of your case #s with my rep - hopefully that will push them to realize it's a defect since our accounts are all unrelated, using different scripts, etc

quick ? .... Do you have Bronto installed?

We do not. I did receive an update on our Case that supposedly an e-fix released late last week has fixed this issue, but maybe only for transactions created after the fix was released (6/20/19)? That doesn't make a ton of sense to me and I don't know how to reliably test that, but I wanted to pass it along in case it could help either of you.

Huh, good to know. I ended up finding a workaround on Friday - we had a script + workflow combination which was clearing and then re-setting the location field with the same value (just mistakes made years ago with people who weren't as familiar with NetSuite). Removing that workflow/script section, so that the location just stayed what it was originally set, stopped the re-calculation of shipping for us. Obviously there is (was?) still some defect because it had been working fine for years, but if y'all happen to have anything setting a location value that you can remove/avoid, that might be worth trying if that e-fix didn't resolve it.

That's interesting, we got defect 545633 for this issue ~30 minutes ago. What's the subject of yours? Our is

Edit Sales Order/Invoice > Add New Items > Shipping Cost Changes to the Default Value

. Maybe getting all of our cases on the same defect will up the priority of it.

Mine is called 'Sales Order/Cash Sale > Shipping Cost changed by a Scheduled Script', so I guess they are creating different defects since we technically have different "triggers" of the recalculation of shipping cost.

That's weird, I'm assuming they're the same underlying issue. In any event, I'm glad we've at least got defects filed - hopefully they'll actually get a fix pushed out soon enough.

Ha, just got an update that actually my defect is expected behavior, due to another defect 511881 which was fixed on june 12th. They said "If you do not want to change the shipping cost, kindly update "shippingcostoverridden" flag to "T". nlapiSubmitField ( 'salesorder' , recordId , 'shippingcostoverridden' , 'T' , false );"

Wow, that's pretty ridiculous. We've been on NetSuite for over 7 years and this is the first time our shipping charges are automatically updating, are they saying that they've let that defect sit untouched for that long?

wow, yeah, my client has only been on netsuite for ~3 years which is still absurd but at least somewhat reasonable given netsuite's bug release schedule. but 7 years! how do you push a bugfix for something that's been broken for 7+ years on a random wednesday without warning, especially when it affects financials

Yeah, as much as I hate to say this as it relates to other long-standing defects, after a certain amount of time (and 7 years definitely qualifies), it's not really a defect anymore, it's just the way the system works.

Same issue but NS support will point to the script because the log shows the 'Total' value changed along with the field that the script set. I can't undeploy the script since it is prod and sandbox is too outdated to reproduce the issue.

I got the "This is now expected behaviour" line as well. I have taken steps to revert the shipping cost to what comes in via Shopify, and I have also checked the shippingcostoverridden flag as well. will report back tomorrow on how it goes when we go to bill our orders from today

I had no idea that the shippingcostoverridden field existed, but after playing around with it for a couple minutes it does appear that it's a reasonable solution for this issue. Additionally, it seems like setting a manual shipping cost in the UI automatically sets that field to true so at least for the bulk of our orders that alone should resolve this issue (except for a few that seem to still have the flag set to false - I wonder if that was the real defect that's already been fixed).

Good News! shippingcostoverridden fixed our issue. We now set this to be true when we import the order and we are able to modify the SO after the fact and the shipping cost remains. Big Thanks for your help! 👍🏻👍🏻

Hey, started noticing the same issue and found this thread. I can’t find this shippingcostoverridden anywhere…can’t search it either. Any ideas why?

I'm pretty sure it's only accessible by script - I couldn't find it anywhere in on the forms or in searches.

yeah it seems to be a script-only field for some reason

yes. you can only set it via script