AutoInvoice Reports
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. 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, use the AutoInvoice Processing report.
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.
- 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. Likewise, 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. Lastly, AutoInvoice prints a Summary of Transactions Rejected section at the end of the report.
You can view the AutoInvoice Execution and Validation reports by navigating to the Completed Requests window, selecting the report to view, and then choosing Report.
See Also
Importing Transactions Using AutoInvoice
Running Standard Reports and Listings
Common Report Parameters
Importing Transactions Using the Transaction API