Notify Users of Material and Service Receipts
BrianBaird 310000VYWJ Comment (1) Visits (9341)
One of my recurring issues has been notifying uses of receipts in an email, without a separate email for each receipt record. To that end, I’ve created a process that uses an escalation to fire a custom action to do this. This is built on Maximo 18.104.22.168 on SQL Server.
Note: The way this is built, it only works for POs where all lines are requested by the same user. You’re smart, I’m sure you can figure out options if you need to.
Create a persistent attribute PO.LASTRECDATE (DATETIME 10).
Create a new Role POREQ
Create a new Communication Template PORECEIPT
Create a Custom Launchpoint PORECCOMM.
Create a new Action Group PORECESC.
If you wish, you can create new views on the DB outside of Maximo.
Create new Escalation PORECESC.
AND po.receipts <> 'NONE'
AND (exists (SELECT 1 FROM matrectrans mr WHERE mr.ponum = po.ponum AND mr.receiptref is NULL AND mr.issuetype = 'RECEIPT' AND mr.transdate >isn
OR exists (SELECT 1 FROM servrectrans sr WHERE sr.ponum = po.ponum AND sr.receiptref is NULL AND sr.issuetype = 'RECEIPT' AND sr.transdate >isn
This entire document is available at the