Maximo Open Forum

Hello,
I added a field to the ISSUECURRENTITEM dialog window. I want to show the last cost value in the invcost table in this field. For this, I created a relationship in the ISSUECURRENTITEM table.

Relationship name:  LASTCOST
Relation:itemnum = :itemnum and location=:location and siteid=:siteid

I set the attribute as LASTCOST.LASTCOST on the dialog screen.
But it doesn't show lastcost value?

Attached is a picture of the lastcost.

Can you help with the matter?
#Customizations

------------------------------
Aliriza Canakci
Is Merkezleri Yönetim ve İşletim A.S
------------------------------

Try using below expression

lastcost in (select max(lastcost) from lastcost where itemnum = :itemnum and location=:location and siteid=:siteid)

------------------------------
PAVAN KUMAR
Maximo Consultant
------------------------------

Hello ,
Thank you for your support Pavan.

I tried what you said. The relation name is Lastcost.Lastcost value is in the invcost table. I corrected the relation accordingly, but the data is not show.


I created the relationship in the ISSUECURRENTITEM table.Where am I doing wrong?
invcost in (select max(lastcost) from invcost where itemnum = :itemnum and location=:location and siteid=:siteid)



------------------------------
Aliriza Canakci
Is Merkezleri Yönetim ve İşletim A.S
------------------------------

Original Message:
Sent: 06-08-2022 10:21
From: pavan Kumar
Subject: IssueCurrentItem Dialog in Showing Lastcost

Try using below expression

lastcost in (select max(lastcost) from lastcost where itemnum = :itemnum and location=:location and siteid=:siteid)

------------------------------
PAVAN KUMAR
Maximo Consultant
------------------------------

Hello Paven,
Thank you for your support.

The parent is ISSUCURRENTITEM table.The child is INVCOST table.The lastcost field in INVCOST.
I want to show the field at the stock output in the ISSUE dialog window inside the INVENTOR application.

Attached are the pictures.

------------------------------
Aliriza Canakci
Is Merkezleri Yönetim ve İşletim A.S
------------------------------

Original Message:
Sent: 06-08-2022 10:21
From: pavan Kumar
Subject: IssueCurrentItem Dialog in Showing Lastcost

Try using below expression

lastcost in (select max(lastcost) from lastcost where itemnum = :itemnum and location=:location and siteid=:siteid)

------------------------------
PAVAN KUMAR
Maximo Consultant
------------------------------

It should get the output as per your requirement. I has tried the query in squirrel it showing the lastcost

------------------------------
PAVAN KUMAR
Maximo Consultant
------------------------------

Original Message:
Sent: 06-08-2022 11:52
From: Aliriza Canakci
Subject: IssueCurrentItem Dialog in Showing Lastcost

Hello Paven,
Thank you for your support.

The parent is ISSUCURRENTITEM table.The child is INVCOST table.The lastcost field in INVCOST.
I want to show the field at the stock output in the ISSUE dialog window inside the INVENTOR application.

Attached are the pictures.

------------------------------
Aliriza Canakci
Is Merkezleri Yönetim ve İşletim A.S
------------------------------


Original Message:
Sent: 06-08-2022 10:21
From: pavan Kumar
Subject: IssueCurrentItem Dialog in Showing Lastcost

Try using below expression

lastcost in (select max(lastcost) from lastcost where itemnum = :itemnum and location=:location and siteid=:siteid)

------------------------------
PAVAN KUMAR
Maximo Consultant

Small change has been done, Now you can try this, I guess it will work fine.

lastcost in (select max(lastcost) from invcost where itemnum = :itemnum and itemsetid=:itemsetid and location=:storeloc and siteid=:siteid)

------------------------------
PAVAN KUMAR
Maximo Consultant
------------------------------

You want to display the latest lastcost . if my understanding is right, then try below relation ship

LASTCOST in (select max(LASTCOST ) from LASTCOST where itemnum = :itemnum and location=:location and siteid=:siteid)



------------------------------
pavan Kumar
Envision enterprise solutions
------------------------------