Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This document provides instructions on how to manually import an e-invoice into Purchasing & Receiving.

\uD83D\uDCD8 Instructions

Info

E-Invoices is invoices are available only available for PIDB Supplierssuppliers. If the supplier you are looking for is not listed in the dropdown in Purchasing & Receiving, that supplier needs to be mapped to PIDB. If it’s not available in PIDB, contact PIDB support with the suppliers supplier's name, and contact information and that supplier can then be setup set up for you.

Note

Most suppliers can send the e-invoice directly to PIDB. In this scenario, the e-invoice gets normalized and loaded automatically for you. You can then start this process from step 14.

...

  1. If your E-Invoice is in an email, save your eE-invoice onto your computers filesystemcomputer's file system.

  2. Confirm your E-Invoice has a single-row header record for each column. This is a requirement for the system to be able to identify the file , and give you the ability to map it’s columnsits columns. The E-invoice to be imported must have the following information in columns:

Barcode/UPC, Supplier SKU, Description, Cost, and Shipped Quantity.

  1. Open Purchasing & Receiving.

  2. Go to the E-Invoices section.

    Image Modified

  3. Click on Import.

    Image Modified

  1. Select the Supplier the E-Invoice is for from the Supplier dropdown.

    Image Modified

  1. Optionally, select the original PO in the next dropdown.

...

  1. Click on

...

  1. ‘Select File’ and browse your computer

...

  1. until you find the

...

  1. E-invoice file.

...

  1. If you

...

  1. receive the message “The Selected File Format is not Recognized. Map the Fields to the Associated Types to

...

  1. Continue”. This means the file format is not recognized. You will need to continue through steps 10-15. If you

...

  1. do not get this message, then you can

...

  1. proceed to step 11.

...

  1. Map each of the fields under step two to the correct column in the uploaded file. The dropdowns will show you the header record (1st row) from the uploaded file for you to match against.

...

  1. Press the Submit button. You will receive back a message that the “Import File has been accepted. It may take a few minutes before it will

...

  1. appear”.

...

...

  1. The E-Invoice will show with Pending under the E-Inv Created On field until the processing has been completed. This generally takes a minute or two

...

  1. but can take longer at times.

...

  1. The Pending status under E-Inv Created On will change to the date once processing has been completed.

  2. Open the E-Invoice

  3. Select the PO #, if applicable

    Image Modified

  1. Select any lines that say New Product, and click

...

  1. ‘Add’

    Image Modified

  1. Update any information from PIDB that you might want changed. Make sure you fill in a Markup or Price on the product (1), and then press Save (2). If you select multiple products like in this example, you can see which product number you are on by looking in the top right corner of the screen (3).

    Image Modified

  1. Continue adding new

...

  1. products until all records show “Product in POS”. At that point, you are ready to click on “Send to Receiving”.

    Image Modified

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@a00
sortmodified
showSpacefalse
reversetrue
typepage
labelskb-how-to-article
cqllabel = "kb-how-to-article" and type = "page" and space = "PP"