TRY: SELECT TOP 1 POSTATUS.PONUM ,POSTATUS.CHANGEBY ,POSTATUS.CHANGEDATE APPR DATE FROM POSTATUS WHERE POSTATUS.PONUM = 'PO1234' AND REVISIONNUM = '0' AND POSTATUS.STATUS = 'APPR' ORDER BY POSTATUS.CHANGEDATE
Hi @Adam Olson! I give you this query that may solve your need. SELECT po.ponum, po.revisionnum, po.orgid, po.siteid, po.status, po.changedate, po.changeby, (SELECT MAX(pst.changedate) FROM postatus pst WHERE pst.ponum = po.ponum AND pst.orgid = po.orgid AND pst.siteid = po.siteid AND pst.status...
I'm having difficulty getting a sql statement written that will allow me to return the Minimum Date from the PO Status Table. I'm trying to return the First Approval Date of a PO and also return the CHANGEBY user that is associated with that specific approval. I'm able to successfully get the...
IBM indicates this is a known issue with Maximo Asset Management 7.6.1.3 with IFIX018 installed: IJ51002: When attepting to set a Contract Ref Num on Purchase Requesition for a Contract that has been revised. Has anybody found a workaround for this? I've poked around the base code a bit and find...
3815 Harrison AvenueCincinnati, OH 45211contact@moremaximo.com
Join CommunityInvite ColleaguesLearn MoreAbout UsTerms of Use