Maximo Open Forum

Back to discussions
Expand all | Collapse all

Custom table in application of Receiving

  • 1.  Custom table in application of Receiving

    Posted 18 days ago
    Hello,

    I have application Receiving (PO) in Maximo. I wanted to add custom table in for record packgages like how many plastic we get with this order or how many cartridges in kilos and so one.

    I created new object in database with name MYCUSTOMOBJECT picture 1, where I also created attributes like at picture 2.

    PICTURE1

    PICTURE2

    After that I went to Application designer where I created custom table, but when I open one PO(order) I see this



    I just want that user could add new row and insert of which material it is like plastic paper and so on, and save it to this PONUM this order in table of my new object MYCUSTOMOBJECT, but I get this errors and I dont know how to solve it. Any suggestions?
    #Customizations

    ------------------------------
    Blaz Rakar
    Slovenske Zeleznice d.o.o.
    ------------------------------


  • 2.  RE: Custom table in application of Receiving

    Maximo Certified
    Posted 11 days ago

    Binding errors typically means that you're not on the dataset that you want. In this case, did you create a relationship from PO to MYCUSTOMOBJECT? If you're not sure what this is, inside of the Database Configuration application open the PO object. On the relationships tab is where you define how to get from one object (in this case PO) to another object (in this case MYCUSTOMOBJECT). Based on the attributes you have defined, you don't plan to handle revisioning so your where clause should look like:

    ponum=:ponum and siteid=:siteid 


    Then in Application Designer, on your table ensure you set the Relationship to be MYCUSTOMOBJECT.

    From there, you need some sort of automation in place to get the PONUM + SITEID set on these records as they are created. If you're not already doing this, I would do this by creating an Automation Script with the name of MYCUSTOMOBJECT.NEW (no launch points). Your script would then look like:

    owner=mbo.getOwner()
    if owner and owner.isBasedOn("PO"):
        mbo.setValue("PONUM",owner.getString("PONUM"))
        mbo.setValue("SITEID",owner.getString("SITEID"))

    There's a lot of other things you potentially need to write for this (such as restricting when it can be deleted, whether or not attributes should be modifiable after it's saved, etc.). But hopefully this at least helps you get started. 



    ------------------------------
    Steven Shull
    Projetech Inc.
    ------------------------------

    Original Message