IMPORT ERROR LOG DUPLICATE "PPAY" INVOICE RESEARCH

Amber Schmitz
|
11 steps

In Oracle, click "Payables"

Click Invoices

Click the task manager

Click "Manage Invoices"

Click " Supplier or Party" and type in the Supplier name and click Search

Click the desired supplier then click OK

Click the desired supplier

Click the drop down to the right of the "Invoice Date" field. Select "Between."

Mirror the dates on the Import Error Log to pull a list of invoices for the chosen Supplier.

Click "Search"

Click "Export to Excel". Once exported, use a VLOOKUP formula on the import error log and compare what's on my doc to what is on your doc to identify items already posted in oracle. Repeat steps above and return results for all of the suppliers assigned to you on the import error log.