Use the AutoInvoice Execution report to review the results of your AutoInvoice request. This report lists summary information telling you how many revenue and credit transactions are selected, accepted, and rejected for each currency. The AutoInvoice Execution report also shows the total invoice amount for each transaction type for all transactions processed.
This report also includes receipts that were processed according to policy, as well as receipts that were put on account because a refund was not possible. See: Automated Receipt Handling for Credits.
AutoInvoice automatically produces this report each time you run AutoInvoice.
Use this report to match Receivables revenue and credit transaction counts to those from your other financial systems. You can also use the AutoInvoice Execution report to reconcile with other Receivables reports, such as the Transaction Register. See: Transaction Register.
Note: If AutoInvoice calculates tax, the invoice totals on the AutoInvoice Execution report and Transaction Register will not be equal. This is because the AutoInvoice Execution report only shows tax imported from RA_INTERFACE_LINES. See: Importing Tax Lines.
Use the AutoInvoice Validation report to review lines that have failed different phases of validation and the error messages associated with these lines. Receivables only generates this report when you run AutoInvoice and have lines that fail validation. To review records that were successfully imported, refer to the AutoInvoice Execution report.
Attention: You can use the Interface Lines window to modify records that fail AutoInvoice validation. See: Correcting AutoInvoice Exceptions.
AutoInvoice can be divided into three major phases, pre-grouping, grouping and transfer.
Pre-grouping: In this phase, AutoInvoice validates all of the line-level data and any other data that is not dependent upon successful grouping. Some examples include validating that a transaction type is valid, and validating that only one freight account exist for each freight line passed.
Grouping: In this phase, AutoInvoice groups lines based on the grouping rules and validates header-level data that is dependent on how your lines are grouped. Some examples include validating the over application rules specified for your batch source and validating that the general ledger date of an invoice against a commitment is not before the general ledger date of the commitment. If AutoInvoice groups transactions incorrectly, check the grouping rule that you are using and confirm that your transactions properly conform to the grouping rule. For more information, see Using Grouping Rules to Create Transactions.
Transfer: In this phase, AutoInvoice validates information that exists in Receivables tables such as tax defaulting and AutoAccounting data.
For each line, AutoInvoice can only display error messages for the phase the line is in when it fails. For example, if a line fails validation in the pre-grouping phase, AutoInvoice will display all error messages encountered in the pre-grouping phase. Additionally, if a line is already in the transfer phase when it fails, AutoInvoice will display all error messages encountered in the transfer phase. If you encounter sales credit or distribution errors, AutoInvoice prints them in a separate section below each line. AutoInvoice also prints a Summary of Transactions Rejected section at the end of the report.
You can view the AutoInvoice Execution and Validation reports online by navigating to the Requests window, selecting the report to view, and then choosing View Output.