how can i send an email to a user when item quanti...
# suitescriptl
Livio
03/09/2022, 3:01 PMhow can i send an email to a user when item quantity (on hand) changes? Do i need a scheduled script?
d
dcrsmith
03/09/2022, 3:37 PMtry a saved search alert
l
Livio
03/09/2022, 3:48 PMthat wont work
d
dcrsmith
03/09/2022, 4:15 PMAre you basing this on an order or on the item? The qty on hand changes with inventory adjustments or item receipts. You could use a UE to alert immediate changes or use the scheduled script as you suggested.
l
Livio
03/09/2022, 4:27 PMyeah i would need to consider fulfillments, receipts, adjustments, return to vendors... i guess i can do that
s
Sandii
03/09/2022, 5:01 PMThis sounds like an awful process/request tbh
Sandii
03/09/2022, 5:02 PMAnd idk why you think a saved search alert won't work, you could look for inventory posting transactions, nothing else should change the on hand
l
Livio
03/09/2022, 6:25 PMi would need to explain the whole process and why we are doing this, and that would make a lot of sense. this is just the first step...
b
battk
03/10/2022, 4:15 AMthis requirement is significantly easier if you want changes to quantity available instead of quantity on hand
battk
03/10/2022, 4:17 AMthe last quantity available change column from an item search or query stores the datetime representing when the quantity available changes
4 Views