Supplier List Export from DPO

Supplier List Export from DPO

Export your data and open it in Excel as usual, to export the data the admin will need to go to Admin > Export and download the .csv file.

Delete all of Columns A to Y (Project ID to Creator Position)

After that delete from Column O onwards (ExtraField1)

Highlight all (Ctrl-A) and click on Filter in the Data tab, sort column A (Supplier) alphabetically

Ctrl-A again and click Remove Duplicates in the data tab. Leave all the boxes ticked and click OK

You will be left with a list of suppliers. Some suppliers will be in there twice if you have the POs with the same supplier name but different details. 

You can highlight these duplicates by selecting the whole of the Supplier column going to the Home tab, clicking Conditional Formatting > Highlight Cells Rules > Duplicate Values > OK

 

 

 

 

 

 


    • Related Articles

    • DPO to Global Vista

      If your DPO project would like the export function to be enabled so you can import from DPO to Global Vista then you will need to email Sargent-Disc (support@sargent-disc.com) with the DPO project name and the currency codes you are using within GV ...

    • DPO to PSL

      If your DPO project would like the export function to be enabled so you can import from DPO to Global Vista then you will need to email Sargent-Disc (support@sargent-disc.com) with the DPO project name and the currency codes you are using within GV ...

    • How to export data from DPO to Excel

      The export from DPO will export all of the data from the DPO project, from there you can then filter out what is needed. In order to get the export, the admin will need to go to Admin > Export Once on the export tab there will be a .csv file that the ...

    • Time zone of PSL/ Global Vista Export

      The PSL/ Global Vista exports will by default run at midnight - that is midnight based on the timezone of the user enabling the export. The export is enabled by going to admin > Export PSL or Export Global Vista and ticking the checkbox enabled like ...

    • Extra Fields on DPO

      If you would like additional text fields when creating a Purchase Order then then the admin can set this up by following the steps below. Go into Admin > Extra Fields DPO will allow you to have 3 extra fields, in order to set up an extra field click ...