Modify selectreserveditems Dialog

Back to discussions

Expand all | Collapse all

Modify selectreserveditems Dialog

Jump to Best Answer

1. Modify selectreserveditems Dialog

Like
Robert Goff
Posted 07-25-2024 11:22

Reply Reply Privately
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

Like
Martin Fabra
Posted 07-27-2024 11:36

Reply Reply Privately
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

Like
Robert Goff
Posted 07-29-2024 09:58

Reply Reply Privately
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