PSL+: How to Import a DPO (.xml) File into PSL+

Load DPO File (EZYPO) provides a fast and efficient way to import purchase orders by batch from an .xml file.

To get started, make sure "Export PSL" is an option in your DPO Book. Contact DPO Support to add this option if needed.

Step 1: Export from DPO

1. Log in to DPO.

2. Click on your name in the top right. 

3. Select Administration. 

Graphical user interface, text, application

Description automatically generated

4. Click Export PSL.

Graphical user interface, text, application

Description automatically generated

5. Click Manage Currency Code Conversion. This is where you will set the currency code to match what is set up in PSL+ and ensure the currency code will export in a way PSL+ can recognize. 

Text

Description automatically generated with medium confidence

6. Click Download and Save. (Do NOT open the file)

Graphical user interface, text, application

Description automatically generated

Note: (Supplier = Vendor) 

The supplier code in the DPO book cannot be blank. A supplier code is needed whether it is an existing or new supplier record. If the record does not exist, then the supplier will be added to the database when imported.

To add the supplier codes, go to Admin > Suppliers > and click on the pencil icon next to the supplier. 

Step 2: Import into PSL+

7. Log into PSL+.

8. From the PO Menu, click Load DPO File. 

A picture containing table

Description automatically generated Graphical user interface, application

Description automatically generated

9. Input the Effective Date, Batch Number, Production Code, Bank Code, and Currency. 

10. Input a Default for the Series, Location, and Set codes.  

11. Click Preview Edit or Print Edit. The Edit list will display all the Vendors that will be created and the P.O. distribution information that will be imported from this file. 

12. If any errors exist, the report will detail them. 

a. For example: If a free field, insurance code, series, location, set, account number, etc. is used in the file but does not exist in PSL+, then you will need to add those values in order to load the file (i.e., account number, free field, series code, etc.). 

Edit List Examples

  • With Errors: Errors will need to be corrected within PSL+ before import can process. 

Graphical user interface, text, application, email

Description automatically generated

  • Without Errors:

Graphical user interface, text, application, email

Description automatically generated

13. Once you have reviewed the edit list and are ready to import the file, click Import.

14. A pop-up window will allow you to print the Import Register. 

15. An “Information” dialog box will display once all data has been loaded successfully. 

Graphical user interface, application

Description automatically generated

Example of a successful import load

Graphical user interface, table

Description automatically generated

Things to keep in mind

  • When choosing the account number, make sure the number/code is populated, not the account description. 
  • While DPO has more than a 30-character description allowance, PSL+ will load the first 30 characters of the description. 
  • Always keep the DPO App updated. If you log in and do not see all your DPO Books, it’s most likely because the APP needs to be updated. Contact DPO support if you’re still experiencing issues. 
  • DPO will prepare a batch file at midnight, nightly. This file will contain all the PO's that have completed the approval cycle since the last export. 

Check out our FAQ to find answers to commonly asked questions.