Importing Invoices to ERP

Makenzy Cervantez
17 steps
2 minutes

Tylerhost

After your spreadsheet is created and the amounts are distributed to their org/obj codes, save the spreadsheet in .csv format. Go to File > Save As and select the file location you would like to save to.

Select the dropdown "Save as type:" and choose CSV (Comma delimited). Save file.

From ERP Hub, navigate to Invoice Import

Click the "Define" skittle

Click the magnifying glass in the "Input file" field and select or drop your .csv import file.

For Import format, select "Custom"

Leave the rest of the fields blank. If all of your invoices are going to be entered for a single department, you can enter the department code.

Use the "Form" dropdown menu and select AP Multi Line Import w Date

Tab through to prepopulate necessary fields. Check the "Include decimals" box.

Select "Default from vendor" next to Flag imported invoices as

Once all of your settings are defined, select "Pre-Edit" to run a report that will check for errors and warnings.

You will receive a popup stating there are errors/warnings. Click "OK" and display or generate a PDF of the report.

Check over the report. There will be warnings like "vendor already exists" and "payment method not selected" that can be ignored. You need to review all lines and look for anything reporting a Detail or Header Error. Check the spreadsheet for the field the report references and make any corrections as needed.

Return to the Invoice Import screen. If you needed to make changes to your spreadsheet, you can upload your revised spreadsheet and run Pre-Edit until there are no more errors. Once all errors are cleared and you are only seeing the expected warnings, return to Invoice Import and select "Import."

Click "Yes"

Verify the number of invoices on this popup matches what you have on your spreadsheet. Take note of the batch number. Then click OK.

Navigate to Invoice Entry and search for the batch you have just created. You can now move forward with preparing the invoices for processing.