Go to Purchase Orders then from the drop down menu select Lines





Click on the drop down arrow to the right of the column called Status, then go to Text Filters and select Begins With...



In the 'Status begins with' box type Issued then click OK.




This will apply a filter so that the only purchase order lines that are displayed are those at a status of Issued or Issued (Invoiced) ie awaiting delivery from the supplier.



To export the data displayed on the screen into excel click on the Actions button.


For instructions on how to download data into excel click on the following link:


https://datatecnix.freshdesk.com/solution/articles/11000029206-how-to-download-data-from-opex-into-excel