You'll need to test to make sure that works. Some...
# generals
scottvonduhn
10/31/2019, 2:10 PMYou'll need to test to make sure that works. Some SuiteScript calls fail when made on inactive records.
b
Brian Freytag
10/31/2019, 2:33 PMI'm very new to suitescripting.
I plan on doing this with a beforeSubmit usereventscript. How can I determine whether the project is about to be set to inactive?
s
scottvonduhn
10/31/2019, 2:42 PMUsually, I do some testing to determine what can be detected and when. I'll create a new User event script, deployed on the record, and will have all three event types present. Then add logging on the fields you care about on both the old and new record. Let me see if I can dig up an example.
b
Brian Freytag
10/31/2019, 2:46 PMThanks. It actually looks like they delete the record rather than set them to inactive
s
scottvonduhn
10/31/2019, 2:52 PMif that's the case, even better!
scottvonduhn
10/31/2019, 2:53 PMif not, here's a template that might work to test what changes can bet detected, and when
b
Brian Freytag
10/31/2019, 2:53 PMappreciated
s
scottvonduhn
10/31/2019, 2:53 PMuserevent.js
b
Brian Freytag
10/31/2019, 2:55 PMprojectExternalIdUpdate.js
Brian Freytag
10/31/2019, 2:56 PMObviously, the external id will be cleared when it's deleted, but I just want to be absolutely certain in case something happens
s
scottvonduhn
10/31/2019, 3:01 PMAlways a good idea. I code defensively wherever I can.
b
Brian Freytag
10/31/2019, 3:10 PMI feel like suitetalk was just thrown together without much thought behind it
Brian Freytag
10/31/2019, 3:10 PMliterally nothing makes sense lol
s
scottvonduhn
10/31/2019, 3:12 PMIt's a very old API. I am hoping the new SuiteTalk REST API provides more and better capabilities. Going to have to wait a while before it's generally available, though.
b
Brian Freytag
10/31/2019, 3:16 PMyeah
s
scottvonduhn
10/31/2019, 3:17 PMThey claim it will support "SuiteQL" queries. Whatever that is. I am hoping it means I can do arbitrary ODBC-like queries, with JOINs and IN lists.
b
Brian Freytag
10/31/2019, 3:17 PMit does
Brian Freytag
10/31/2019, 3:19 PMidk why they have to reinvent the wheel tho and just use the standard graphql
s
scottvonduhn
10/31/2019, 3:20 PMSo they can charge thousands of dollars for training and certification, is my guess
b
Brian Freytag
10/31/2019, 3:20 PM^^
Brian Freytag
10/31/2019, 3:21 PMfor something that just won't seem to work right
Brian Freytag
10/31/2019, 3:21 PMand then when you call up to file a report, they'll say it's not a bug, but what you're requesting is an enhancement
Brian Freytag
10/31/2019, 3:22 PMfor example in the current API: Every single Transaction Item type has a customFieldList on it... EXCEPT for the RequisitionItem. It's missing that field altogether in the API. They said it wasn't a bug and that I was requesting a new feature
Brian Freytag
10/31/2019, 3:22 PMnah, bro... you guys forgot it
s
scottvonduhn
10/31/2019, 3:26 PMThey forget a lot of things. And make the end users work around it.
b
Brian Freytag
10/31/2019, 3:26 PMyep
Brian Freytag
10/31/2019, 4:05 PMfor some reason it's not persisting the externalid
Brian Freytag
10/31/2019, 4:05 PMUntitled
Brian Freytag
10/31/2019, 4:06 PMthat "Final External Id" shows it updated correctly, but then it isn't updated
Brian Freytag
10/31/2019, 4:11 PMmessage has been deleted
s
scottvonduhn
10/31/2019, 4:12 PMYeah, I was afraid that might happen. Often with inactive records it won't let you change values, even via scripting.
b
Brian Freytag
10/31/2019, 4:12 PMThis isn't an inactive record
s
scottvonduhn
10/31/2019, 4:12 PMoh, that's strange then
scottvonduhn
10/31/2019, 4:17 PMMaybe try forcing
entityIdentityId = String(currentRecord.getValue({fieldId: 'entityid'}))b
Brian Freytag
10/31/2019, 4:17 PMok
Brian Freytag
10/31/2019, 4:17 PMtrying one other thing
Brian Freytag
10/31/2019, 4:19 PMnope the string thing didn't work either
s
scottvonduhn
10/31/2019, 4:21 PMJust as a test, try setting the external id to some static value like 'ItWorked789XYZ'
b
Brian Freytag
10/31/2019, 4:21 PMok
s
scottvonduhn
10/31/2019, 4:21 PMmake sure it's just not preventing you from updating the field
b
Brian Freytag
10/31/2019, 4:29 PMnope lol
Brian Freytag
10/31/2019, 4:29 PMthe static value didn't work either
Brian Freytag
10/31/2019, 4:38 PMnlapiSubmitField is false for externalId here: https://4581056-sb1.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_2/script/record/job.html
Brian Freytag
10/31/2019, 4:38 PMdoes that mean it doesn't submit the field and I have to do it manually?
s
scottvonduhn
10/31/2019, 4:41 PMOh, you might have to.
scottvonduhn
10/31/2019, 4:42 PMBut, I don't know. It seems like it should work. If doing that, I'd move the logic to afterSubmit.
scottvonduhn
10/31/2019, 4:43 PMWeird things can happen if you load/save a record in the middle of a beforeSubmit
b
Brian Freytag
10/31/2019, 4:43 PMI've had a lot of issues with changes persisting in the afterSubmit
Brian Freytag
10/31/2019, 4:43 PMbecause afterSubmit doesn't trigger until the record has already been saved in the database
s
scottvonduhn
10/31/2019, 4:44 PMright. well, so long as it is the only change being made, it may work. I know I have set externalid before in scripts. Unless there is some reason a User Even script can't touch it. Is it running as Administrator?
b
Brian Freytag
10/31/2019, 4:45 PMlet me double check
Brian Freytag
10/31/2019, 4:45 PMit was set to "Current Role"
Brian Freytag
10/31/2019, 4:46 PMand I'm logged in as admin.
Brian Freytag
10/31/2019, 4:46 PMchagned it to run as admin and nothing. I'll change it to an afterSubmit and see what happens
s
scottvonduhn
10/31/2019, 4:48 PMthe big downside to afterSubmit is that you have to do an explicit record load, set field, then save.
scottvonduhn
10/31/2019, 4:49 PMand it hits the database twice, so performance is also an issue, but in most cases not a noticeable one
b
Brian Freytag
10/31/2019, 4:49 PMok
Brian Freytag
10/31/2019, 5:03 PMboom
Brian Freytag
10/31/2019, 5:03 PMthat worked thanks
s
scottvonduhn
10/31/2019, 5:16 PMwell, that's good
b
Brian Freytag
10/31/2019, 5:16 PMI appreciate your time
s
scottvonduhn
10/31/2019, 5:17 PMNot a problem. I am about to work on my own user event script to keep external id in sync with a custom field, so I will probably run into the same issue.
3 Views