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.