This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Just a heads up.
transactionShipment.shippingmethod in a suiteql query used to give the shipping method text previously, now its giving the internal id suddenly for one of the accounts. At least 30 or so script started failing because of it. Netsuite did this changes out of the blue.

We experienced the same thing. Had to deploy hot fixes this morning.

Any more updates here?  We seem to have customers down because of this.

Nope, a colleague  was on a call with Netsuite support for an hour, they put him on hold for almost 15-20 minutes.
I eventually realized the issue and updated the scripts.

I am happy with this change, sometimes I wanted the internal id in some of the customisation. But had no way to use text or do some hard coding for mapping text to internal id.

But they are implementing a change like this without any prior notification is concerning.

yeah, did you create a fall-back in case they revert this. These types of changes should be communicated in advance.  I assume this was a mistake and they will be reverting it when they continue to get calls.  They are about to get a lot from our base.

however, yes, the change is beneficial because it requires us to do one less join I believe.

We have all the scripts in bitbucket. And can always revert the commit as long as there are no other conflicts if needed. Pipeline from bitbucket will take care of the rest.

```While we are waiting for the next support representative to take over this case, we would like to inform you that this might be related to one of the on going issue in NetSuite.

This issue seems to be caused by the ShippingMethod field, which has changed from a string to an integer in the TransactionShipment table.

Our engineers are working on a fix.```

Ours reverted back to previous over the weekend.

same, we reverted the code changes as well.