Wondering if anyone has any ideas…We ship from different locations and the carrier depends on which location. When selling via SCA we would like to have generic shipping items(2 day, 3 day, and standard) with a set price per pound calculation. Once the Sales order is submitted I would like to update the sales order to Fedex or Ups per item depending on the location through a script. We have Multiple Locations and Multiple Shipping Route enabled. I’ve attempted to update the line items and shipping group but I get a “Transaction was not in balance” error. If I remove the MSR and attempt to update each fulfillment I get an error because the fulfillment form needs to reload the packages tab based on shipping carrier.I’m out of ideas. Any help is appreciated.

is this a client script?

User event/After submit

I've done quite a bit with scripts that change ship method, but haven't had to deal with MSR

and I’m not sure we need to use the MSR feature, but I’m not sure how else to do it

i've only had to set ship via at the header/body level.

Correct.

what is "shipping group" - header or line item on the SO?

Its a separate sublist on the shipping tab

ok. i'm glancing at this now https://system.netsuite.com/app/help/helpcenter.nl?fid=chapter_N3352338.html

I can set them through the UI

based on the same code, shouldn't you just set the

shipaddress

and

shipmethod

on the SO lines, and let NS worry about

shipgroup

?

It doesn’t update and then it errors out when trying to fulfill because the so lines and the shipgroup are different

Is the record object in dynamic mode or standard mode? If in dynamic mode, have you tried setting the fields in the same order as what you do in the UI?

the record loads in standard mode

Try loading it in dynamic mode

Updated to dynamic but I’m still getting TRANS_UNBALNCD