Saturday 23 February 2019

Primary Vendor attribute vs Default Vendor checkbox in Reorder Tab | Maximo

In inventory application, Reorder tab:

1. Primary Vendor is an text field 
2. Default Vendor is a check box in Vendors section to select one vendor as default. 

above mentioned both type are separate in Maximo although they seems identical. 

1. Maximo will take the precedence to the Vender entered in Primary Vendor while reordering, (its a process to manually select any vendor for the item ). If and only if the primary vendor is not entered, then it will take default vendor from vendors list attached to this item. Primary vendor is identifier of the primary vendor for the item. 
You will notice that whenever you select any company in primary vendor field and Maximo generates a new row in vendors section in bottom of Reorder Details tab. 

2. Default vendor check box in Vendors Section, you may enable only one default vendor in inventory/reorder details/vendors section but you can add/attach as much vendor as you can with the one item. If the check box is selected, this will be the default vendor used on Work Order Planned Materials and Services lines for direct issue requisitioning.


reference: https://www-01.ibm.com/support/docview.wss?uid=swg21470910

Thursday 14 February 2019

Excel: Increment Numbers Based on Another Column(Criteria) when Value Changes | Windows

apple 1
apple 2
apple 3
mango 1
mango 2
coco 1
coco 2
coco 3
coco 4
vanila 1
vanila 2

=IF(B10<>B9,1,C9+1)
or

=COUNTIF($A$2:A2,A2) 

to under what the $ sign is in excel forumula, please visit this: https://www.quora.com/What-is-the-difference-between-a-2-a2-and-a2-in-Excel 

Result set as alternate of Inbox Assignment | Maximo

Create a result set as an alternate solution of Inbox Assignment; 
A logged in see thoes records which are assigned to him for a specific application.


create a save a query for SR:


ticketuid in (select wfinstance.ownerid from wfinstance join wfassignment on wfinstance.wfid=wfassignment.wfid and wfinstance.active = 1 and wfassignment.assignstatus='ACTIVE' and wfassignment.app='PLUSGSR' and assigncode in (:&USERNAME&))

Save it as Assigned_SR

create a result set on start center and attach this query with SR application, add your desired attributes to display.

and done :)

Wednesday 13 February 2019

Notify requester of MR when Material is received | Maximo

Automatically Send an email to the user when the material is received and inspected in Maximo.


  1. Automation script to send email

Object Launch Point: MATRECTRANS, Attribute: STATUS

from psdi.server import MXServer
if vISSUETYPE == 'RECEIPT' and vstatus == 'COMP':
   # if not mbo.isNull("poline.mrnum"):
        user = mbo.getUserInfo()
        mboServer = mbo.getMboServer()
        commTemplateSet = mboServer.getMboSet("COMMTEMPLATE", user)
        commTemplateSet.setUserWhere("TEMPLATEID = 'RECEIVING' ")
        commTemplate = commTemplateSet.getMbo(0)
        commTemplate.sendMessage(mbo)

  1. Role, who will receive the email
Role: Receiving,  Type: A Set of Data Related to the Record
Object: PO 
Value: :POLINE.person.PRIMARYEMAIL