Saturday 22 December 2018

Maximo Reorder Formula Redesign | IBM Maximo

Few days ago we had a requirement to alter the default Reordering process used in Maximo. For that we came to a solution which is very simple through Maximo Automation Script but it takes us a lot of research to cater all the impacts and other issues.
In reorder process Maximo uses Reorderpad tables and ReorderMutex to lock other while reordering.



Below is the simple steps to make it done:

Create an Object Automation Script:
Object: REORDERPAD
Event: SAVE , ADD+UPDATE, Before Save (akin preinsert, preupdate)

Script(jython):
ROMMboSet = mbo.getMboSet("ROMMboSet","REORDERMUTEX", " TYPE='STOREROOM' ")
if ROMMboSet.count()>0:
    vReorderQty = mbo.getInt("MINLEVEL") - (mbo.getInt("INVENTORY.AVBLBALANCE") + mbo.getInt("POQTY") + mbo.getInt("PRQTY"))
    vAVGCost = mbo.getFloat("INVCOST.AVGCOST")
    mbo.setValue("REORDERQTY", vReorderQty, 2L);
    mbo.setValue("UNITCOST",vAVGCost,2L);
    mbo.setValue("MANUFACTURER","FROM REORDER",2L);



done :)


2 comments:

  1. Hi Abdul on the same lines if reorder logic to be customized such that items to be groups by commodity , vendor etc. should we look for similar LaunchPoint at reoerderpad object ?

    ReplyDelete
    Replies
    1. sorry for late reply Prashant. but as per my knowledge, answer is NO, we can't.
      by default maximo group items based on Primary Vendor (reorder tab). If primary vendor is not available then default vendor (reorder Tab > vendors).

      We added few vendors with the name of our main commodity codes and attach them as Primary vendors for this grouping.

      Delete