Maximo Open Forum

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?

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!

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?