Maximo Open Forum

 View Only
  • 1.  GL Accounts for Capital Project Work in Maximo (Maximo - Oracle Projects integration)

    Posted 09-04-2023 19:25

    Looking for some information around how GL accounts have been handled in Maximo for Capital projects work?

    We have Maximo integrated with Oracle Projects and we are using Cost Management application to get the Projects and Project tasks information from Oracle.The project related work and purchases happening from Maximo are expected to be charged to a Project related GL accounts which are different from regular GL accounts that Maximo would default. Based on the project task which could be Capital or Expense, different GL accounts would be applicable.  Cost Management also does not have any standard GL related fields to assign partial GL specific to tasks in Cost Management itself (For ex. a Capital task can have a value assigned for a account segment in GL for that task and same is for expense task).

    Anyone has any information to share on how this was handled?  Should the GL selection in work order be done completely manually by user OR any way to derive/default GL automatically?


    #Assets
    #MaximoApplicationSuite
    #MaximoUserGroups
    #WorkManagement


  • 2.  RE: GL Accounts for Capital Project Work in Maximo (Maximo - Oracle Projects integration)

    Posted 09-05-2023 11:16

    I've worked with the Cost Management application integrated with various Project systems (Oracle, SAP, SalesForce).   Typically GLs are applied to Work Orders by the Project Team as the out-of-box Cost Management application does not have GL accounts.   

    As for automation,  I worked with an instance where Location records contained both Expense and Capital (custom) GL attributes.  Automation was built to cross over the correct account to the work orders based on the Work Type --- pre-automation scripts.    With automation scripting, there are probably a couple of good ways to handle this.



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



  • 3.  RE: GL Accounts for Capital Project Work in Maximo (Maximo - Oracle Projects integration)

    Posted 09-05-2023 19:07

    Thanks for the response! Yes, this makes sense. It would require maintaining expense and capital GL at location level and automation scripting (or something else) to make it work though. But, this can be an option. Thanks again. 



    ------------------------------
    Tejaskumar Soni
    IBM
    ------------------------------



  • 4.  RE: GL Accounts for Capital Project Work in Maximo (Maximo - Oracle Projects integration)

    Posted 09-05-2023 13:20

    I had that issue as well.  To solve it, I added a GL Account field to the Cost Management application.  When the Cost Management record is set up, the user can therefore populate the correct GL account for the task.

    I then set up a cross-over field, which is triggered when the Project ID and Task ID are entered into the work order.  This arrangement is working quite well.  I can provide details if needed.



    ------------------------------
    Shannon Rotz
    InComm Solutions Inc.
    ------------------------------



  • 5.  RE: GL Accounts for Capital Project Work in Maximo (Maximo - Oracle Projects integration)

    Posted 09-05-2023 19:09

    Yes, this makes sense. Having a new attribute to capture GL applicable would allow us to associate Project task to GL account. Then we can cross over that account based on project and task selection. Thanks for the suggestion.



    ------------------------------
    Tejaskumar Soni
    IBM
    ------------------------------



  • 6.  RE: GL Accounts for Capital Project Work in Maximo (Maximo - Oracle Projects integration)

    Posted 10-15-2023 23:05

    Depending on the Asset, location, finance can assist to set up Gl Accounts for your specific Projects. We do this on various asset/location scenarios. Works well 



    ------------------------------
    Jacqui Insley
    utilities
    ------------------------------