How to Sort Purchase Orders by Supplier

To sort POs by supplier, it is required to download the file and open it using Microsoft Excel.

This article provides a step-by-step guide on how to sort Purchase Orders by Supplier.



1. Click Purchasing (dropdown icon)

 

 

2. Select Purchase Orders

 

 

3. Click "Export"

 

 

4. Then open the downloaded file (.xls) using Microsoft Excel.

 

 

5. Press [Cmd] + [a] for MacOS or [Ctrl] + [a] for Windows

6. Press [Cmd] + [t] for MacOS or [Ctrl] + [t] for Windows

7. Create a table using the data provided.

 

 

8. Click the dropdown arrow beside any of the table headers to sort accordingly. In this example we will select "Supplier".

 

 

9. You may "Select All" if you wish to see all Suppliers listed.

 

 

10. Alternatively, you can choose any listed Supplier to restrict the display on the table. As we are merely sorting, this action will not remove the information/rows; rather, Excel will simply conceal the details.