1 Reply Latest reply on Apr 24, 2017 3:23 PM by Srini Chavali-Oracle

    How to get Previous Revision Amount Total of PO

    866841

      Hi Guru,

       

      Need the query logic how to get Previous Revision Amount Total of PO.

       

      Requirement is: Need to display the previous Revision Amount Total of PO in custom Report.

      eg. Like if PO having 8 max revision then display 7 revision amount total in the report.

       

      There is print document revision field in Purchase order revision history pages where we can generate the report based on revision.

      In my case, unable to build the query for last previous revision amount total.

       

      Any Help is really appreciated.

       

       

      With Regard's

      Alam.