Maximo Open Forum

 View Only

Related Content

  • 1.  Understand what all we need to do when we change the GL Code on a store

    Posted 06-13-2023 06:18

    Hello All,

    Maximo does not appear to change the GL on items when we change the GL on a store. Only the new items added to the store take up the updated GL account and all the existing ones have reference to the old GL account. Wanted to understand if there was any logic to keep it this way and how we could handle this limitation as our customer has requested to update and check all the transactions and develop a data fix /workaround solution to fix this and we are not sure of how many tables we would need to update and what all could be the side effect of this exercise as we are doing it through the back end.

    Any suggestions or help would be greatly appreciated.

    Thank you,

    Mahadevan


    #Administration
    #EverythingMaximo
    #HSE/OilandGas
    #Inventory

    ------------------------------
    Mahadevan Ramakrishnan
    ------------------------------


  • 2.  RE: Understand what all we need to do when we change the GL Code on a store

    Posted 06-14-2023 01:30

    Hi Mahadev,

    There is a select action option available in Chart of Account application to achieve the same. Please explore.

    The select action name is "Update Database" in Chart of Account application. 

    Below is the IBM article link. 

    https://www.ibm.com/support/pages/update-database-option-chart-accounts



    ------------------------------
    Subhransu Sekhar Sahoo
    Tata Consultancy Services
    ------------------------------



  • 3.  RE: Understand what all we need to do when we change the GL Code on a store

    Posted 06-14-2023 03:25

    Subhransu,

    We are not very confident of using the option available in the chart of accounts application as none of us have used that option and not sure what all could be the impact of that update.

    Is there any possibility of understanding what all tables will be affected by this operation.

    Thank you,

    Mahadevan



    ------------------------------
    Mahadevan Ramakrishnan
    ------------------------------

    Original Message


  • 4.  RE: Understand what all we need to do when we change the GL Code on a store

    Posted 06-21-2023 11:46

    Hello All,

    We are not very confident of using the option - select action option available in Chart of Account application to achieve the same. Could you please let us know if it will solve if we run the below 2 queries from the backend for each of the store in all the sites

    1. update inventory set controlacc= 
      (select controlacc from locations where type='STOREROOM' and siteid='ABC' and location='ABC')
      where location='ABC' and siteid='ABC' and (controlacc is null or controlacc
      not in (select controlacc from locations where type='STOREROOM' and siteid='ABC' and location='ABC'));
    2.  
      update invcost set controlacc= 
      (select controlacc from locations where type='STOREROOM' and siteid='ABC' and location='ABC')
      where location='ABC' and siteid='ABC' and (controlacc is null or controlacc
      not in (select controlacc from locations where type='STOREROOM' and siteid='ABC' and location='ABC'));


    ------------------------------
    Mahadevan Ramakrishnan
    ------------------------------