Maximo Open Forum

 View Only
  • 1.  How to automatically populate asset with work orders?

    Posted 6 days ago
    Edited by gursev bajwa 6 days ago

    Hello,

    I have created an custom application called Asset to Workorders and the main objective is that a user can see work orders to assets including the GL accounts(project, cost categories) etc.  What I want to be able to do is that when I click on new ASSET, it should automatically populate the other fields such as work order, description, GL Account, Project code.  Here is what it looks like:


    #Administration

    ------------------------------
    GB
    ------------------------------



  • 2.  RE: How to automatically populate asset with work orders?

    Posted 5 days ago

    Hi GB,

    This application just does not make sense to me.  Is the objective of the application to create new assets or new work orders?  In either case, you already can:

    Create new assets

    1. Use the Assets application
    2. Use Asset Manager application
    3. Use Asset Templates
    4. Receive a rotating item
    5. etc...

    Create new work orders and relate to an asset

    1. Work order tracking
    2. Quick reporting
    3. Technician
    4. SR - Create work order
    5. Asset - Create work order
    6. etc...

    What is the main Maximo object that underlies the application?  Are you better off cloning one of the work order applications and changing the screen?  This way you get what you want.

    Regards, Craig



    ------------------------------
    Craig Kokay
    Principal Consultant
    COSOL

    email: craig.kokay@cosol.global
    #IBMChampion
    ------------------------------



  • 3.  RE: How to automatically populate asset with work orders?

    Posted 4 days ago

    Hello Craig,

    Thank you for the help.  My main objective in this custom application is that whenever I create a new asset, I am hoping that the workorder, GL Account, Project cost and status will automatically populate.



    ------------------------------
    GB
    ------------------------------



  • 4.  RE: How to automatically populate asset with work orders?

    Posted 4 days ago

    Hi GB,

    That I understood, but it does not make sense, so let me explain.

    Requirement:

    1. I must be able to create a new asset
    2. The following fields must be automatically populated:
      1. Work order number
      2. GL Account
      3. Project Cost
      4. Status

    All the fields can be automatically populated, but you need to establish the rules and behaviour.

    Let's break that down.

    Create an asset

    I'm going to assume that this application will be a Single Page App.  I see in the supplied picture that it fits that style rather than a Power App.  Is that correct?  It is unusual, but okay, go for it.  You will need the summary row also to have an expanded section.  I cannot see that in your current design. I'll assume that you've based this application on the asset object and therefore the asset number will be automatically set, provided the field is defined in that manner.

    Defaulted fields

    For all defaulted fields, where do you expect to get the data?  Is it set at the database level, through the UI, or via an automation script?

    I these fields are to come from a work order, then which work order because an asset can be linked to multiple work orders.  Let me assume that you select the work order.  This means that the GL account, project code, project cost, and description are in fact from that work order and can be displayed using a relationship.

    Additional fields not yet mentioned

    Status

    I'm going to assume that you intended that this is the status field of the asset and therefore...wait a minute, you have it shown as read-only, please confirm as my answer will differ.  If asset, then why read-only unless you never intend to change it from this application, or if work order, then just display it using a relationship.

    Classification

    Very similar question to the status.

    Owner

    Very similar question to the status.



    ------------------------------
    Craig Kokay
    Principal Consultant
    COSOL

    email: craig.kokay@cosol.global
    #IBMChampion
    ------------------------------



  • 5.  RE: How to automatically populate asset with work orders?

    Posted 2 days ago

    Hello Craig,

    Thank you for the update.  Here are the answers to your questions:

    Create an asset

    I'm going to assume that this application will be a Single Page App.  I see in the supplied picture that it fits that style rather than a Power App.  Is that correct?  It is unusual, but okay, go for it.  You will need the summary row also to have an expanded section.  I cannot see that in your current design. I'll assume that you've based this application on the asset object and therefore the asset number will be automatically set, provided the field is defined in that manner.

    • Actually, when I started designing the app in application designer, I did use Power app.  When you say Summary Row, is that this field:  

    Defaulted fields

    For all defaulted fields, where do you expect to get the data?  Is it set at the database level, through the UI, or via an automation script? -This will be from the database level as I don't believe that the UI can provide that information.

    I these fields are to come from a work order, then which work order because an asset can be linked to multiple work orders.  Let me assume that you select the work order.  This means that the GL account, project code, project cost, and description are in fact from that work order and can be displayed using a relationship.

    Additional fields not yet mentioned

    Status

    I'm going to assume that you intended that this is the status field of the asset and therefore...wait a minute, you have it shown as read-only, please confirm as my answer will differ.  If asset, then why read-only unless you never intend to change it from this application, or if work order, then just display it using a relationship. - Yes i intend to show the status of the asset in this field,  if it is a work order, then what relationship should I be looking at?

    Classification

    Very similar question to the status.

    Owner

    Very similar question to the status.



    ------------------------------
    GB
    ------------------------------



  • 6.  RE: How to automatically populate asset with work orders?

    Posted 12 hours ago
    Edited by sun kim 12 hours ago

    May I suggest, you just create a tab in Assets instead or expand the current Work Tab?



    There is a work tab already as well. You could potentially look into expanding the child table in the modal to bring in more fields that you want to include. Seems a lot easier add fields to an existing function than create an entirely new app.

    There's a relationship in ASSET called ALLWO (and an index on ASSETNUM) and WORKORDER should have an index for WONUM and WORKORDERID already. It won't affect retrieval performance at all other than adding a few more fields if what you need is in the workorder table only.



    ------------------------------
    sun kim
    ------------------------------



  • 7.  RE: How to automatically populate asset with work orders?

    Posted 12 hours ago

    Thank you fore the suggestion but this is a new application that I was requested to make,  to learn the application designer tool.   



    ------------------------------
    GB
    ------------------------------