Maximo Open Forum

 View Only
  • 1.  Change Lot Type on Items

    Posted 05-25-2022 12:52
    Hi All,
    We have few items in Maximo with Lot type as LOT1.The lot type value is populated by mistake and the users want to change the lot type to NOLOT.
    I am aware that it is not possible to change the lottype via front end once the positive balance is created for that item in any of the store room.
    As the users are keen to change the lottype anyway we are looking at options to update the value via backend using sql commands.

    As part of this, I am interested to know which all tables will affect if lottype on item table is changed so that those tables are also taken care of via the same db script.

    Can anyone help me on this?

    Thanks
    #Inventory

    ------------------------------
    Meghana Siriveli
    ------------------------------


  • 2.  RE: Change Lot Type on Items

    Posted 05-25-2022 16:35
    Hi! 
    If all the inventory storeroom balances are zero (0), the LOTTYPE attribute should be editable and changed to NOLOT.   If you have inventory balances, you need to get to a 0 balance inventory (maybe issue them to an administrative type work order). You may have to look to see if the item is referenced on an open purchase order, etc.

    https://www.ibm.com/support/pages/change-item-lot-nolot

    ------------------------------
    Julie Shaw
    Projetech Inc.
    ------------------------------



  • 3.  RE: Change Lot Type on Items

    Posted 05-26-2022 03:37
    Hi Julie,

    Thanks for the response .

    We have already tried this , made the inventory balances to 0 but still the field was not editable which is why we have opted to update via back end.


    ------------------------------
    Meghana Siriveli
    ------------------------------



  • 4.  RE: Change Lot Type on Items

    Posted 05-26-2022 07:54
    That is strange behavior.  I recommend confirming that there are not any open PR, PO or Inventory Usage lines and /or reservations.

    ------------------------------
    Julie Shaw
    Projetech Inc.
    ------------------------------



  • 5.  RE: Change Lot Type on Items

    Posted 05-31-2022 08:57
    Edited by Mark Eaton 05-31-2022 08:57
    Hi Meghana,
    You will need to delete all of the inventory balance records, after reconciling and zeroing out the inventory current balance.   Once all the inventory balance records are gone, you will be able to refetch the item and change the lot type.

    ------------------------------
    Mark Eaton
    Projetech Inc.
    ------------------------------



  • 6.  RE: Change Lot Type on Items

    Posted 06-06-2022 11:08
    Adjust and reconcile the current balance to Zero for the item in EACH STOREROOM. Then DELETE all the BINS if any., from the inventory to break the link from the inventory balances table. 
    After that, you will be able to change the lotting type on Item master. 


    ------------------------------
    Abdul Qadeer
    MACC
    ------------------------------