Reopening NetSuite Work Orders | scotthung

NetSuite Work Orders can also be closed via the blue Close button in the UI. This last can be problematic if there is still work to be ... NetSuiteWorkOrders haveafewdifferentstatusdependingonthefieldsBuildableandBuiltquantity: “Released”(whentheBuiltquantityis0), “InProgress”(whenBuiltquantity>0butnotequaltotheBuildablequantity)and “Closed”(whenBuiltquantity=Buildable) NetSuite WorkOrderscanalsobeclosedviatheblueClosebuttonintheUI. ThislastcanbeproblematicifthereisstillworktobeperformedintheWorkOrder. Reopening a WorkOrderisthesameasany NetSuiteTransaction: UnchecktheIsClosedcolumnofoneormore WorkOrderlineitems. TheproblemisthereisnowaytodothisintheUI. Instead,wecanrun SuiteScriptin theScriptDebugger(Customization|Scripting|ScriptDebugger)toupdate thelineitems. Inthegistbelow,weloadtheworkorderbyID,set eachlineitem’sisclosedpropertytoFalseandcommittherecordtothedatabase. ThelastnlapiLoadRecord()callisjustsowecanexaminetherecordishowweexpect. ThisfilecontainsbidirectionalUnicodetextthatmaybeinterpretedorcompileddifferentlythanwhatappearsbelow.Toreview,openthefileinaneditorthatrevealshiddenUnicodecharacters. LearnmoreaboutbidirectionalUnicodecharacters Showhiddencharacters varo=nlapiLoadRecord("workorder",2433031); for(vari=1;i<=o.getLineItemCount("item");i++) o.setLineItemValue("item","isclosed",i,"F"); varstat=nlapiSubmitRecord(o); o=nlapiLoadRecord("workorder",2433031); varx=1; viewraw ns_workorder_reopen hostedwith❤byGitHub Dobecarefulbecauseeventhoughthedebuggerisitsowndomainitwillchange datainyour productioninstancesousethiscautiously! Sharethis:ShareEmailTwitterLinkedInFacebookLikethis:LikeLoading... Related Postnavigation ←HowTo:ParseaJSONresponseusingSalesforce’sJSONParser class 2thoughtson“ReopeningNetSuiteWork Orders” Sir,ifyouarestillmonitoringthis,Itriedtouseyourscriptbutamgettingtheerrormsgof“ReferenceError:“nlapiLoadRecord”isnotdefined.(adhoc$-1$debugger.user#1)” Yourcomments/thoughtswouldbegreatlyappreciated. LikeLike Reply IthasbeenalongtimesinceIwrotethisandNetSuiteisalwaysintroducingnewfeatures–inthiscaseSuiteScript2.0.IhadtoselecttheAPIversiontobe1.0intheDebuggertogetthistoworkbecause2.0wasthedefault. Unfortunately,Idon’tworkontheNetSuiteplatformanymore,butIdorecommendlearningSuiteScript2.0.IfoundthisposttalkingaboutSuiteScript2.0andworkingwithNetsuiterecordsat:https://stoic.software/effective-suitescript/3-records-in-ss2/ Hopethishelps! LikeLike Reply LeaveaReplyCancelreply Enteryourcommenthere... Fillinyourdetailsbeloworclickanicontologin: Email(required)(Addressnevermadepublic) Name(required) Website YouarecommentingusingyourWordPress.comaccount. ( Log Out /  Change ) YouarecommentingusingyourGoogleaccount. ( Log Out /  Change ) YouarecommentingusingyourTwitteraccount. ( Log Out /  Change ) YouarecommentingusingyourFacebookaccount. ( Log Out /  Change ) Cancel Connectingto%s Notifymeofnewcommentsviaemail.Notifymeofnewpostsviaemail. Δ Archives April2016 January2015 December2014 November2014 October2014 September2014 August2014 July2014 June2014 May2014 March2014 February2014 January2014 September2013 Categories apexclass apiversion certification cloudflow devops flow how-to netsuite salesfor salesforce suitescript trigger Uncategorized visualflow visualforce Tagsadm201 apex apiversion button chromeissue csvfile dataloader documentation dreamforce dynamicchoice eclipse email enaberforexcel excel geonames heartbleed https integration JSON jsonparser JSONParserenum mapclass netsuite null openssl outputText pricebookupdate Profilepermissions refresh renderedattribute reporttype salesforce ssl suitescript tls unittest visualforce workorder zipcodeMeta Register Login Entriesfeed Commentsfeed WordPress.com FollowscotthungonWordPress.com Privacy&Cookies:Thissiteusescookies.Bycontinuingtousethiswebsite,youagreetotheiruse. Tofindoutmore,includinghowtocontrolcookies,seehere: CookiePolicy Follow Following scotthung Join164otherfollowers Signmeup AlreadyhaveaWordPress.comaccount?Loginnow. scotthung Customize Follow Following Signup Login Copyshortlink Reportthiscontent ViewpostinReader Managesubscriptions Collapsethisbar SendtoEmailAddress YourName YourEmailAddress Cancel Postwasnotsent-checkyouremailaddresses! Emailcheckfailed,pleasetryagain Sorry,yourblogcannotsharepostsbyemail. %dbloggerslikethis: