Hi @Stevie Holloway!
This query will give you data from polines, po and workorder and start in POLINE. if you need to start with workorder, it should be different.
In the first relationship (first join) you can search for some status of the PO, some specific type of PO (like open POs or another different type of PO). If you give me more information, I can try to create here a object structure and then send you my progress.
Regards!
select po.ponum, po.revisionnum, po.siteid, po.status, poline.itemnum, poline.storeloc, poline.orderqty, poline.orderunit, poline.receivedqty, poline.enterdate, poline.enterby, poline.description, poline.refwo wo, workorder.description, workorder.status
from poline
left join po on poline.ponum = po.ponum and poline.revisionnum = po.revisionnum and po.siteid = poline.siteid
left join workorder on poline.refwo = workorder.wonum
where poline.refwo is not null
------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
------------------------------
Original Message:
Sent: 12-01-2022 09:10
From: Stevie Holloway
Subject: Object Structure for Ad-Hoc Report
I'm seeking directions on how to configure an object structure and needed relationships to show work orders that have open purchase order records. Looking at fields like WONUM, DESCRIPTION, STATUS, PONUM, POSTATUS, etc.
I appreciate all your help.
#Administration
#Customizations
#EverythingMaximo
#Reporting
------------------------------
Stevie Holloway
U.S. Bureau of Reclamation
------------------------------