Maximo Open Forum

 View Only

Related Content

  • 1.  Modify selectreserveditems Dialog

    Posted 07-25-2024 11:22

    We would like to add a column to the selectreserveditems dialog in the Inventory Usage application to show the current balance of the item in the "from" storeroom.

        <dialog beanclass="psdi.webclient.beans.invusage.InvUseLineSelectReservedItems" id="selectreserveditems" label="Select Reserved Items" parentdatasrc="MAINRECORD" relationship="INVRESERVE">
            <helpgrid id="selectreserveditems_help1" innerhtml="You can add multiple reserved items to the current usage line."/>
            <table id="selectreserveditems_invreserve_Table" label="Reserved Items" selectmode="multiple" width="900">
                <tablebody displayrowsperpage="15" filterable="true" id="selectreserveditems_invreserve_Table_tablebody">
                    <tablecol filterable="false" id="selectreserveditems_invreserve_Table_tablebody_1" mxevent="toggleselectrow" sortable="false" type="event"/>
                    <tablecol dataattribute="itemnum" id="selectreserveditems_invreserve_Table_tablebody_2" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="item.itemtype" id="selectreserveditems_invreserve_Table_tablebody_21" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="item.description" id="selectreserveditems_invreserve_Table_tablebody_3" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="conditioncode" id="selectreserveditems_invreserve_Table_tablebody_4" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="reservedqty" id="selectreserveditems_invreserve_Table_tablebody_5" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="actualqty" id="selectreserveditems_invreserve_Table_tablebody_6" inputmode="readonly" sortable="true"/>
    LIKE THIS-->    <tablecol dataattribute="invbalances.curbal" id="selectreserveditems_invreserve_Table_tablebody_20" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="pendingqty" id="selectreserveditems_invreserve_Table_tablebody_7" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="stagedqty" id="selectreserveditems_invreserve_Table_tablebody_8" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="shippedqty" id="selectreserveditems_invreserve_Table_tablebody_9" inputmode="readonly" sortable="true"/>
                    <tablecol applink="wotrack" dataattribute="workorder.wogroup" id="selectreserveditems_invreserve_Table_tablebody_10" inputmode="readonly" label="Work Order" menutype="hyperlink" showfilterfield="true" sortable="true"/>
                    <tablecol dataattribute="workorder.taskid" id="selectreserveditems_invreserve_Table_tablebody_11" inputmode="readonly" showfilterfield="true" sortable="true"/>
                    <tablecol dataattribute="assetnum" id="selectreserveditems_invreserve_Table_tablebody_12" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="tostoreloc" id="selectreserveditems_invreserve_Table_tablebody_14" inputmode="readonly" sortable="true"/>
                    <tablecol applink="viewdr" dataattribute="mrnum" id="selectreserveditems_invreserve_Table_tablebody_15" menutype="hyperlink" sortable="true"/>
                    <tablecol applink="po" dataattribute="ponum" id="selectreserveditems_invreserve_Table_tablebody_16" inputmode="readonly" menutype="normal" sortable="true"/>
                    <tablecol dataattribute="polinenum" id="selectreserveditems_invreserve_Table_tablebody_17" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="requestedby" id="selectreserveditems_invreserve_Table_tablebody_18" inputmode="readonly" sortable="true"/>
                    <tablecol dataattribute="requireddate" id="selectreserveditems_invreserve_Table_tablebody_19" inputmode="readonly" sortable="true"/>
                </tablebody>
            </table>
            <section id="selectreserveditems_mainsection_2">
                <checkbox dataattribute="showallreservation" id="selectreserveditems_showallreservation_11" ondatachange="resetchildren"/>
            </section>
            <buttongroup id="selectreserveditems_2">
                <pushbutton default="true" id="selectreserveditems_2_1" label="OK" mxevent="dialogok"/>
                <pushbutton id="selectreserveditems_2_2" label="Cancel" mxevent="dialogcancel"/>
            </buttongroup>
        </dialog>

    As you can see, there are four columns using dot notation to load information from workorder and item, although there are no corresponding relationships in the INVUSE object - I presume these relationships are implemented in the InvUseLineSelectReservedItems bean. I've tried using the INVCURBALANCESOUT relationship and the bare name of the INVCURBALANCES object; both result in "Invalid Binding".

    Is there a way (without modifying the bean) to do what we need?


    #Administration
    #EndUser

    ------------------------------
    Robert Goff
    Xanterra Travel Collection
    ------------------------------


  • 2.  RE: Modify selectreserveditems Dialog
    Best Answer

    Posted 07-27-2024 11:36

    Hi @Robert Goff!

    I solved this in a different way.

    "Select Reserved ITEMS" in Inventory Usage APP works on INVRESERVE Object. 

    INVRESERVE object has a relationship with INVENTORY objetct called "INVENTORY". This is very important because INVENTORY has a field called CURBALTOTAL and this is what I want to use to solve this

    Then, in the application editor, above INVUSAGE, I edit (in the dialog editor) "selectedreserveditems".

    Open the window where I add a new column and In the attribute field, I choose INVENTORY.CURBALTOTAL

    The result would be this one below

    Regards!



    ------------------------------
    Martin Fabra
    ARSAT S.A. - Actively seeking employment
    ------------------------------



  • 3.  RE: Modify selectreserveditems Dialog

    Posted 07-29-2024 09:58

    Excellent! I had not looked for such a relationship since item and workorder were not relationships. This will meet the minimum requirement, I think, although sorting and filtering don't seem to be possible.

    Thank you.



    ------------------------------
    Robert Goff
    Xanterra Travel Collection
    ------------------------------

    Original Message