AutoInvoice validates your data for compatibility with Receivables. It ensures that the columns in Receivables' Interface tables reference the appropriate values and columns in Receivables. To learn more about the validation AutoInvoice performs for each column in the AutoInvoice tables, see: AutoInvoice Table and Column Descriptions.
For some columns, AutoInvoice ensures that the values are already defined in Receivables or in other Oracle applications.
You use transaction batch sources that have a type of 'Imported' when importing transactions into Receivables. See: Transaction Batch Sources.
You do not have to pass values for all of the fields that are referenced in the Transaction Sources window into Receivables. If you do not want AutoInvoice to pass certain data into Receivables for a specific batch source, then you can set the related field to 'None' in the Transaction Sources window.
Note: Even if you set a field on a batch source to 'None' because you do not want to import this information into Receivables tables, AutoInvoice might still validate the data and could reject the containing line(s) if that data is invalid.
AutoInvoice ensures that the invoice number you supply is unique within a given batch source and the document number you supply is unique within the associated sequence type.
AutoInvoice also ensures that the Transaction Flexfield you supply is unique. For more information, refer to Transaction Flexfields.
Precision is the number of digits to the right of the decimal point that are used in regular currency transactions. AutoInvoice ensures that the amount and the accounted amount you supply have the correct precision for a given currency.
AutoInvoice ensures that certain column values agree with each other. These values can be within an interface table or multiple interface tables.
For example, if you specify in your batch source that you do not want to use accounting rules, AutoInvoice ignores any values you supply for invoicing rule, accounting rule, and accounting rule duration. However, if you do import transactions that use accounting rules, AutoInvoice requires that these transactions also include an invoicing rule.
Besides validating dates, AutoInvoice also validates and rejects lines if:
The accounting rule has overlapping periods
All of the accounting periods do not exist for the duration of your accounting rule
For more information, see: Importing Invoices with Rules.
You can specify whether AutoInvoice will reject or partially create transactions that have an invalid line, invalid tax rate, or a GL date in a closed period. For example, you import an invoice with three invoice lines and one of the lines is invalid. If the value of the Invalid Line option for this batch source is set to 'Create Invoice,' AutoInvoice will create the invoice with only the two valid lines. You can then use the Transaction window to add the line that was rejected. If Invalid Line is set to 'Reject Invoice,' AutoInvoice will not import this transaction or any of its lines into the interface tables. Transactions that fail validation appear in the AutoInvoice Validation report.
The values you enter in the AutoInvoice Processing Options tabbed region of the Transaction Sources window determine how AutoInvoice will process transactions with invalid data. See: Transaction Batch Sources.
AutoInvoice validates lines with receipt distributions and performs the following actions:
Merges lines with separate receipt distributions into a transaction with a single receipt distribution, provided the lines share the same account (CODE_COMBINATION_ID).
Rejects a transaction, if the receipt distributions of its lines have different accounts.
Separates a transaction into two or more transactions when the receipt distributions of its lines have different accounts, if you added Receivables account (CODE_COMBINATION_ID) as an optional grouping column for the grouping rule for the batch source.
AutoInvoice validates credit memos by reviewing the automatic receipt handling setting on the submission's transaction batch source.
If you enabled automatic receipt handling, then AutoInvoice automatically reviews each credit memo and associated invoice to determine its eligibility for receipt handling. See: Automatic Receipt Handling for Credits.
If you did not enable automatic receipt handling, then AutoInvoice evaluates credit memos using standard invoice validation:
If the invoice's transaction type allows natural application only, then AutoInvoice rejects the credit memo.
You must unapply the receipt from the credited invoice and rerun AutoInvoice to successfully import the credit memo.
If the invoice's transaction type allows overapplication, then AutoInvoice imports the credit memo and the invoice is overapplied until you unapply the receipt from the credited invoice.
See: Transaction Types.