Use the Interface Exceptions window to view all records that failed AutoInvoice validation. Use the Interface Lines window to update these failed records.
Records that pass validation are transferred into Receivables tables. Records that fail validation are called exceptions; these records remain in the AutoInvoice interface tables. Before AutoInvoice can validate these records and create transactions in Receivables, you need to correct any invalid data, and then resubmit AutoInvoice.
Each time you run AutoInvoice, the program prints information about records that fail validation in the AutoInvoice Validation report. Use this report with the Interface Exceptions window to see which transactions failed validation and why. Then, use the Interface Exceptions window's associated drilldown windows to modify records that have errors. You can also use the Interface Lines window and its associated drilldown windows to modify records. After correcting the invalid data, resubmit AutoInvoice to import the data into Receivables tables.
The Interface Exceptions window displays the interface ID, exception type, error message, and the invalid value associated with each error. You cannot edit data in this window, but you can edit data in the drilldown windows by selecting a record and choosing the Details button.
Note: The interface ID is the interface_line_id, interface_distribution_id, or the interface_salescredit_id for this line.
The Interface Lines window displays records of type Line or Charges that exist in the interface tables, indicates which records contain errors, and provides general information about each record. You can edit data in this window as well as drill down to view more detailed information about each record.
Note: The transaction batch source determines whether AutoInvoice will reject or partially create transactions when an error occurs in one or more of the invoice lines.
Records that fail validation have an associated exception type to help you identify and fix invalid data. The Interface Exceptions window displays the exception type for each record.
Valid exception types include: Charges; Freight; Freight Distribution; Line; Line Distribution; Revenue Contingency; Sales Credit; Tax; Tax Distribution.
Navigate to the Interface Lines window.
To display all of the records in the interface tables, choose Run from the Query menu. The Errors Exist check box indicates whether a record contains one or more exceptions.
To view only records in the interface tables that have errors, check the Errors Exist check box, then choose Run from the Query menu.
Select the record to view, then choose the Errors button.
The Line Errors window appears. In the Line Errors window, Receivables displays all of the errors associated with this record.
Review the error(s) for this record, then decide which error you want to fix. Note the error type, message text, and the invalid value (if any).
Note: There might be only one but there could be many errors with various error types for a single record.
Return to the Interface Lines window. If the error type of the error you want to fix is either Line or Charges, enter or update the appropriate information in this window, then go to step 8.
Suggestion: You can use the list of values to enter data for most of the fields in the Interface Lines window. You can also view additional information by placing the cursor in any folder region field, choosing Show Field from the Folder menu, and then selecting the field to view.
If the error type is not Line or Charges, choose the button that corresponds to the error type. For example, if the error type is Sales Credit, choose the Sales Credits button. If the error type is Line Distributions, Freight Distributions, or Tax Distributions, choose the Accounting button.
Update the incorrect values in the Accounting Distributions window, or choose the Errors button to view all of the errors for this distribution line.
Note: You cannot edit data in the Distribution Errors windows. You need to return to the Accounting Distributions window to modify the error for a distribution line.
Repeat step 3-8 for each error. After you fix all of the errors in the AutoInvoice interface tables, resubmit AutoInvoice.
Note: You might have to modify data and submit AutoInvoice several times before all of the records in the interface tables will pass validation.
Navigate to the Interface Exceptions window.
Choose Run from the Query menu. Receivables displays all records and their error types.
Select the record to edit, then choose Details.
Note: The Line Type of the record that you select determines which window appears. For example, if the Line Type is Tax, Receivables displays the Interface Tax Lines window; if the Line Type is Sales Credit, Receivables displays the Sales Credits window; if the Line Type is Line, Receivables displays the Interface Lines window, and so on.
Enter any missing information or update the invalid data for this record. To view all of the errors associated with this record, press the Errors button.
Review the error(s) for this record and return to the previous window to make your changes.
For example, if the Line Type of the record is Sales Credit, then return to the Sales Credits window to update the record.
Save your work.
To fix another error, return to the Interface Exceptions window, then repeat steps 3-5.