Importing Purchase Orders

Follow

This article shows you, a Certify AP Administrator, how to import purchase orders.

Step 1: On your Certify homepage, click the waffle icon next to the question mark then click AP.

Screen_Shot_2023-02-27_at_4.09.23_PM.png

Step 2: First, you need to enable the ability to import purchase orders. Click the gear icon on your Certify AP Dashboard.

Screen_Shot_2023-02-27_at_4.26.18_PM.png

Step 3: Next, click your company name.

importing_po_4.jpg

Step 4: Click the Company Preferences tab.

importing_po_5.jpg

Step 5: Scroll down to PO Export Settings and click the checkbox next to Enable PO Import.

importing_po_6.jpg

Step 6: A new set of fields will appear. Here, enter a Default UserDefault CategoryDefault GL AccountEmails to Notify, and Emails Filter.

importing_po_7.jpg

Step 7: When complete, click Save.

importing_po_8.jpg

Editing User Permissions

Step 1: Now that you've enabled the PO import, you'll need to edit the permissions of the user you chose above. This is what will allow that user to see the Import Purchase Orders link under the Invoices section. Click Users.

import_1.png

Step 2: Click the user you chose above.

import_2.png

Step 3: Click the Permissions tab.

import_3.png

Step 4: Click the checkbox next to Manage PO Import. This is what will allow that user to see the Import Purchase Orders link under the Invoices section.

import_4.png

Step 5: Click Update Permissions.

import_5.png

Importing Purchase Orders

Step 1: Now that this is enabled, you'll be able to import purchase orders. On your Certify AP Dashboard scroll down to the Exports section.

Screen_Shot_2023-02-28_at_9.50.38_AM.png

Step 2: Click Purchase Orders Import.

Screen_Shot_2023-02-28_at_9.51.14_AM.png

Step 3: Click New Template to create a new template for importing purchase order data.

po_import_2.jpg

Step 4: After giving the PO Import template a name and description select the import file format and choose whether or not the first row is a header. Then browse for the file you wish to upload.

mceclip0.png

Step 5: After uploading the file Certify AP will read its contents. The File Field column are the fields that were read from the file that was uploaded. The Certify Field column is where Certify will map the field on the file to the applicable data field within Certify AP.

mceclip1.png

Step 6: Click Edit and choose the data field that corresponds to the column on your upload file from the drop down list.

mceclip2.png

Step 7: There are a number of required fields when creating your PO import template. Note that the below fields are for importing PO’s without receiving data:

  • Allocation Percentage (in the Allocation Detail section)
    • Note: Values accepted are 1-100.
  • Department Number (in the Allocation Detail section)
    • Note: Must match your Department ERP ID's.
  • Bill-To Department ID (in the Order section)
    • Note: Must match your Department ERP ID's.
  • Closed (in the Order Detail section)
    • Note: Values accepted are Y or N.
  • Description (in the Product section)
  • Line ID (in the Order Detail section)
    • Note: Each PO will start with a Line ID of 1 and increase by 1 for each new line item. Each new PO will reset back to 1.
  • PO Date (in the Order section)
    • Note: Format is MM/DD/YY
  • PO Number (in the Order section)
  • Price (in the Order Detail section)
    • Note: Price refers to the price of the item on the PO.
  • Product Price (in the Product section)
    • Note: Product Price refers to the price of the product in your company's Product Catalog. Product Price may or may not be the same as Price.
  • Quantity Ordered (in the Order Detail section)
  • Ship-To Department ID (in the Order Detail section)
    • Note: Must match your Department ERP ID's.
  • SKU (in the Product section)
  • Unit Value (in the Product section)
  • Vendor ID (in the Vendor section)

In addition to the fields above, if importing receiving data the below fields will be required:

  • Packing List Date (in the Packing List section)
    • Note: Format is MM/DD/YY
  • Packing List Qty Received (in the Packing List Item section)
    • Note: Does not accept values of 0.

Step 8: After saving, click Preview.

preview.png

Step 9: Drag the actual file with data onto the chosen file section. Lastly, click Import.

image_98.png

Step 10: Finally, validate imported purchase order data in the archives.

po_import_5.jpg

po_import_6.jpg

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request