How You Correct AutoInvoice Errors

During AutoInvoice import, records that pass validation are transferred to the Receivables tables. Records that fail validation remain in the AutoInvoice interface tables. Before AutoInvoice can validate these records and create transactions, you must correct invalid data and run AutoInvoice again.

Each time you run AutoInvoice, the process generates a list of records that failed validation. You can display these AutoInvoice errors as an Excel workbook in either of two ways:

• Click the Manage AutoInvoice Lines link to open a workbook with all error records.

• Navigate to the Import Exceptions infotile and click a Number of Exceptions numbered link to open a workbook for these specific error records.

AutoInvoice Errors Workbook

Every workbook has three tabbed worksheets. You can use the tools available in the workbook to manage the review and update of information.

The workbook is populated with information from the AutoInvoice tables:

• RA_INTERFACE_LINES_ALL: Transaction header and line information.

• RA_INTERFACE_SALESCREDITS_ALL: Sales credit information for transactions.

• RA_INTERFACE_DISTRIBUTIONS_ALL: Distributions linked to the appropriate transaction lines in the ra_interface_lines table from the Line Transaction Flexfield.

• RA_INTERFACE_CONTS_ALL: Revenue contingencies that impact revenue recognition for imported transactions.

• RA_INTERFACE_ERRORS_ALL: All interface lines that failed validation and weren't imported into Receivables tables.

The three tabbed worksheets arrange AutoInvoice information in this way:

• AutoInvoice lines and line distributions

• Tax and freight distributions

• Sales credits and revenue contingencies

A workbook presents existing records for update or deletion only. You can't enter new transaction information into a workbook. Each column in a given worksheet corresponds to the columns in the respective interface tables. Five additional columns manage the processing of your updates:

• Changed: Tracks changes made to a given row. The upload only processes rows marked in this column.

• Flagged for Deletion: Indicates rows marked for deletion. When a row is flagged for deletion, all the corresponding lines in all the related tables are also deleted.

• Update Status: Displays the results of each update to the interface tables.

• Number: Displays the row number.

• Import Errors: Displays the import rejection reason.

You can change or delete records in the workbook and click the Save button at any time. When you save, this updates the corresponding records in the AutoInvoice interface tables.

Tip: To save changes to a workbook without uploading them to the AutoInvoice tables, use the native Excel Save and Save As features.

When you have finished updating a workbook, click the Save and Run AutoInvoice button to display the parameters for AutoInvoice submission. Once the process is successfully submitted, AutoInvoice provides a concurrent request ID.