Purchase Orders

DPO to PSL+ Import

Load DPO File (EZYPO) provides for a fast and efficient import of Purchase Orders (P.O.) by batch from an .xml file.

Jump to a section in this guide:

DPO Book

Setup Requirements

Loading PSL+ CHART OF ACCOUNTS into DPO

Loading PSL+ Vendors (Suppliers) into DPO

String Coding in DPO

> Example 1

> Example 2

Password Reset or Password Issues

> Password Reset Link

> Not receiving password reset email

> Incorrect email address entered on DPO

> Account Locked

Ready to Export from DPO

Locating the File

Ready to Import into PSL+

Edit List

New Vendor Records


DPO Book

Log into DPO via the web and create a P.O.: https://web.digitalpurchaseorder.com 

DPO will prepare a new batch file at midnight PT. This file will contain all the P.O.'s that have completed the approval cycle since the last export. If there are any problems you can revoke the batch, rectify any issues (e.g., currency issues or empty supplier fields) and the batch that was revoked will then be included in the next batch of P.O.’s. To download the session click download under Admin > Export 3rd Party.  Once it’s imported into PSL+ the batch can be marked as complete.

Setup Requirements:

Contact DPO Support to add “Export PSL+” option to the P.O. Book. 

Setup Currency codes in DPO and PSL+ 

SETUP Menu > Currencies > Create Currency Code. 

Currency code in DPO is 3 digits.  Currency in PSL+ is 2 digits.  Utilize the Currency Code Conversion at the time of export. 

Loading PSL+ CHART OF ACCOUNTS into DPO

From DPO: Download the Excel file template from P.O. book.  Go to Admin > Import and download the Excel file. 

There will then be a tab on the Excel file to add in the chart of accounts. 

The Parent Account is optional, but they will need the Account Name and Account Code. 

From PSL+: GL Menu > Chart of accounts List >  

You can then copy and paste the necessary accounts into the DPO template.  Send the updated template to support@sargent-disc.com 


Once this is complete, send this to support@sargent-disc.com and they will be able to load the COA file. 

Loading PSL+ Vendors (Suppliers) into DPO

From DPO: For importing suppliers it is the exact same process.  Download the import document from Admin > Import, fill out the supplier information and send to support@sargent-disc.com

From PSL+: Vendor Menu > Vendor List >  

You can then copy and paste the necessary accounts into the DPO template. 

Please note:

  • When choosing the account number, ensure the number/code is populated and not the account description. 
  • DPO has more than a 30-character description allowance. PSL+ will only load the first 30 characters of the description. 
  • Always ensure your DPO app is up to date. If you log in and some of your DPO books are missing, an app update is likely needed. If the issue persists after updating, contact DPO support.
  • DPO will prepare a batch file nightly at midnight PST. This file will contain all the P.O.'s that have completed the approval cycle since the last export. 

String Coding in DPO

Example 1:

There are two sections in the PSL+ export file. 

If the account mask on PSL+ is xx-xx-xx this will need to be what’s entered in the account code box in DPO. 

E.g.: if the account number was 70-02-00 I would need to type this directly into the account code box shown in the screenshot below.  This will pull through into the Account Number field on PSL+. 

A screenshot of a phone

Description automatically generated

If you want to enter any additional codes IE Set, Ser, F1 etc. then you would need to put a '/' after the account code. 

The order for entering this is as follows: 

  • Set – up to 4 digits long 
  • Series – up to 4 digits long 
  • Insurance – up to 2 digits long 
  • 1099 – up to 2 digits long 
  • Free field 1 – up to 4 digits long 
  • Free Field 2 – up to 4 digits long 
  • Free Field 3 – up to 4 digits long 
  • Free Field 4 – up to 4 digits long 

For example, to enter 001 for the set, 02 for the series and A for free field 1, it would need to be entered as follows: 

70-02-00/001 02    A 

  • 70-02-00/ (This is the account code followed by a / to enter in the rest of the coding) 001, as only 3 digits are being used for the set, enter a space after 001 as the field is up to 4 characters long). 
  • 02 (2 digits are being used for the series, then enter two spaces after 02 as the field is up to 4 characters long). 
  • In the above example both Insurance and 1099 are not being used, as these fields have up to 2 characters long; enter 4 spaces.
  • A (1 character is being used for free field 1, enter three spaces after the A as the field is up to 4 characters long). 

A screenshot of a phone

Description automatically generated

Another example of coding the 2nd part after the account number: 

TTTTRRRRNN991111222233334444 

  • where TTTT is the set RRRR is the series NN is the insurance
  • 99  is the 1099 code
  • 1111 is free field code 1
  • 2222 is free field code 2
  • 3333 is free field code 3
  • 4444 is free field code 4 

E.g.: if the account code is 1234, the series is 000 and the set is 004, you would need to write: 

1234/004 000 

The reason for the space between the 4 and the 0 show above is because the set field is up to 4 digits, if you are only using 3 like shown in the example then you would need to put a space, this is the same for any other fields you are not using so for instance if you had the account as 1234, series as 000 and set as 004 and A in free field 1 then you would enter this into DPO like: 

1234/004 000 A 

Example 2:

How the coding will look in DPO which would line up with PSL+ 

A yellow rectangular sign with black numbers

Description automatically generated

Which will be this coding string: 

ACCOUNT 

SET 

SERIES 

INS 

1099 

FF1 

FF2 

FF3 

FF4 

37-20-00 

0000 

290 

N/A 

07 

SC 

N/A 

N/A 

 

Password Reset or Password Issues

Password Reset Link

Password resets can be requested from through the following: https://web.digitalpurchaseorder.com/newpassword.php 

When requesting a password reset link, enter the email address that was used for setup. 

Not receiving password reset email

If the reset link does not appear in your inbox please check in the junk/spam folder.  Users can also search for the email address: do-not-reply@digitalpurchaseorder.com in case the email has been moved to an alternative folder.  If the email is still not coming through, the project admin can check the email address that was used for setup by going to the Project Admin section of DPO > Users.  

Incorrect email address entered on DPO

If an incorrect email address was used for setup, the project admin will need to re-invite the user with the correct email address. 

https://www.youtube.com/watch?v=nF32bF1uUPo 

Once the user has been re-invited with the correct email address, the old user record can be removed by the project admin. They can do this by going to Admin > Users and clicking the bin icon next to the old user record. 

Please Note: If the bin icon is greyed out this will be because they have an approval level assigned to them. The project admin will need to click onto the pencil icon and remove the approval level first and click save. The bin icon will then appear to delete the old user record. 

Account Locked

If the password is entered unsuccessfully 3 times your DPO account will be locked for 30 minutes. There is no way to bypass the account being locked, the account will automatically unlock after 30 minutes after receiving the email. 

Ready to Export from DPO

  1. Log in to DPO
  2. Click on User Profile Name and select Administration
    A screenshot of a computer

Description automatically generated
  3. Click the Export PSL+ tab
    A grey and white rectangle with text

Description automatically generated
  4. Click Currency Code Conversation - Click here to set the currency code which will match what is set up in PSL+. This will ensure the currency CODE will export in a way PSL+ can recognize. 
    A close up of a sign

Description automatically generated
  5. Click Download and Save (DO NOT OPEN THE FILE)
    A white box with a black text

Description automatically generated

Please Note: Supplier = Vendor 

The supplier code in the DPO book cannot be blank. A supplier code is needed whether 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.  Enter the supplier code for that supplier. 

Locating the File

  • Format*.xml files (PO12345.xml). 
  • Save the files in an easy location like the Desktop or My Documents.  

Ready to Import into PSL+

  1. Log into PSL+: 
  2. Purchase Order Menu > Load DPO File 
    A screenshot of a computer screen

Description automatically generated
  3. Choose the Effective Date, Batch Number, Production code, Bank Code and a Default for the Series, Location and Set codes. Click Preview or Print the Edit. The Edit list will display all the Vendors that will be created and P.O. distribution information that will be imported from this file. 
    undefined-Dec-07-2023-06-47-50-7195-PM
  4. If any errors exist, the report will detail them. 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+, the user will need to add those values to load the file. E.g. account number, free field, series code, etc. 

Edit List

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

undefined-Dec-07-2023-06-48-22-7424-PM

Without Errors: 

undefined-Dec-07-2023-06-48-40-2862-PM

  • Once the files have been reviewed and ready for import, click on ‘Import’. 
  • A printer box will appear, click “Print” to print the Import Register. 
  • If all data has been loaded successfully, you'll see this notification: 
    A screen shot of a message

Description automatically generated

New Vendor Records

AP Menu >Vendor Menu > Vendor Entry 

If the vendor does not exist:
  • The vendor record will be created with vendor name only, any additional information will be blank. The user will need to update the vendor name, etc. 

If you would like to add vendors before loading file AP Menu > Vendor Menu > Vendor Entry 

  • If you have a list of vendors you would like PSL+ support to assist with uploading, contact us and we will send the .xls format for the vendor information. 
  • PSL+ Support can assist with vendor lists to upload. Contact PSL+ Support to receive the .xls format for vendor information. undefined-Dec-07-2023-06-51-10-5241-PM

The DPO to PSL+ Import [EZYPO] process is now complete. 

undefined-Dec-07-2023-06-52-37-5024-PM