Hi All,
Can any one let me know if the user event...
# suitescriptz
Zeeshan
10/22/2021, 6:07 AMHi All,
Can any one let me know if the user event is triggered when the inbound shipment status is changed from "To Be Shipped" to "In Transit" from a button(Mark in Transit)?
Thanks
t
Tyn Guardian
10/22/2021, 6:35 AMhave you tried adding logs?
n
NElliott
10/22/2021, 8:25 AM@Zeeshan I don't see it listed in help but as Tyn mentioned you could log the UserEventType:
For the related help:
https://<youracount>.app.netsuite.com/app/help/helpcenter.nl?fid=section_4407992596.html
If you find there is an appropriate type maybe post back here your findings 🙂
t
tuli
10/22/2021, 9:07 AMNO
tuli
10/22/2021, 9:08 AMI had to use a scheduled script to perform what I wanted to back then
n
NElliott
10/22/2021, 9:46 AMI imagine you could use a UE script to check on edit if that status had changed to "In Transit" comparing the oldRecord / NewRecord value beforeSubmit...
z
Zeeshan
10/22/2021, 9:49 AMI verified UE, event never triggers on the mentioned action.
Zeeshan
10/22/2021, 9:50 AMthere is also a limitation on the saved search that modified date is neither available on filters nor columns.
Zeeshan
10/22/2021, 9:51 AMand the last resort would be to execute the search using Analytics. Last Modified Date available here 🙂
Zeeshan
10/22/2021, 9:54 AMThanks @Tyn Guardian, @NElliott, @tuli for the quick responses.
I believe that my last message would be helpful for everyone.
n
NElliott
10/22/2021, 10:17 AM@Zeeshan does the inbound shipment not have a status you can check as I proposed?
NElliott
10/22/2021, 10:20 AM@Zeeshan
You should be able to check this field for this value:
fieldId: 'shipmentstatus' , value: 'inTransit'
so I'd do something like :
Copy code
let newRecord = context.newRecord;
let oldRecord = context.oldRecord;
let oldStatus = oldRecord.getValue({fieldId:'shipmentstatus'})||'';
let newStatus = newRecord.getValue({fieldId:'shipmentstatus'})||'';
if(oldStatus !=='inTransit' && newStatus ==='inTransit'){
// your logic here
}t
tuli
10/22/2021, 10:56 AM@NElliott The user event is not triggered while marking it inTransit. Now who will come to Inbound shipment and edit and save that. and even someone will do it doesn’t makes sense.
That was pretty weird situation back then, but I’ll look up to search using analytics.
tuli
10/22/2021, 10:58 AMI absolutely agree with you, I talked it with my team back then and they proposed the same solution you did, and seems obvious, I might have proposed the same, but then I went in to weeds to know the actual situation there 😄
n
NElliott
10/22/2021, 11:00 AMRight, OK, I thought you were saying you couldn't establish the trigger type when it moved to In Transit, not that a UE was not triggered at all 🤷♂️ (just looked back at your original question and appreciate that's what you asked)
z
Zeeshan
10/25/2021, 11:19 AMThanks for the clarification @tuli to @NElliott :)
Zeeshan
10/25/2021, 11:20 AMWe all the need to play with analytics feature inside SuiteScript 2.x.
t
tuli
10/25/2021, 11:29 AMOnce done, please share back 😄
🏄 1
z
Zeeshan
10/25/2021, 11:19 PMconst getModifiedInboundShipments = (lastSyncTime = '') => {if (lastSyncTime === '') {throw {name: 'LAST_SYNC_TIME_IS_BLANK',message: 'lastSyncTime can not be blank.'};}const inboundShipQuery = nsQuery.create({type: nsQuery.Type.INBOUND_SHIPMENT});const firstCondition = inboundShipQuery.createCondition({fieldId: 'lastmodifieddate',operator: nsQuery.Operator.AFTER,});const secondCondition = inboundShipQuery.createCondition({fieldId: 'shipmentstatus',operator: nsQuery.Operator.ANY_OF,values: ['inTransit']});inboundShipQuery.condition = inboundShipQuery.and(firstCondition,secondCondition);inboundShipQuery.columns = [inboundShipQuery.createColumn({fieldId: 'lastmodifieddate',alias: 'lastModifiedDate'}),inboundShipQuery.createColumn({TO_CHAR({lastmodifieddate}, 'DD-Mon-YYYY HH12:MI:SS AM')type: nsQuery.ReturnType.STRING,alias: 'lastModifiedDateStr'}),inboundShipQuery.createColumn({fieldId: 'shipmentnumber',alias: 'shipmentNumber'}),inboundShipQuery.createColumn({fieldId: 'id',alias: 'internalId'})];inboundShipQuery.sort = [inboundShipQuery.createSort({column: inboundShipQuery.columns[0]})];// returns max 5K recordsconst resultSet = inboundShipQuery.run();const mappedResultSet = resultSet.asMappedResults();return mappedResultSet;};Zeeshan
10/25/2021, 11:19 PMCheers 😉
Zeeshan
10/25/2021, 11:20 PMFYI: @Tyn Guardian @NElliott @tuli
keanu thanks 1
3 Views