Importing Transactions Using AutoInvoice
Run the AutoInvoice Import or Master program to transfer transactions from other systems into Receivables. You can import invoices, credit memos, debit memos, and on-account credits using AutoInvoice. Receivables ensures that the data you import is accurate and valid.
The Submit Requests window lets you process important transactions and leave other transactions for later processing. You can use this window to run several AutoInvoice submissions at the same time.
Run the AutoInvoice Purge program to delete the interface lines that were processed and successfully transferred into Receivables by the AutoInvoice Import program. You do not have to run this program if the Purge Interface Tables option in the system options window is set to Yes; in this case, Receivables deletes the interface lines automatically after you run AutoInvoice. See: Defining Receivables System Options.
You can also import transactions into Receivables using the Transaction API. For more information, see: Importing Transactions Using the Transaction API
Note: You can also export invoices using the Oracle EDI Gateway. EDI (Electronic Data Interchange) lets you exchange information electronically with your business partners using an agreed upon, standard format. For more information, please refer to the Oracle EDI Gateway User's Guide.
The Oracle Order Entry Receivables Interface program transfers order and return information from Oracle Order Entry into the Receivables AutoInvoice tables. For more information, see: Receivables Interface.
Prerequisites
To import transactions into Receivables using AutoInvoice:
1. Navigate to the Run AutoInvoice window.
2. Enter a request Name of AutoInvoice Import Program or AutoInvoice Master Program. To submit more than one instance of the AutoInvoice Import program, use the AutoInvoice Master program. Submitting multiple instances lets you import your transactions into Receivables more quickly.
3. Enter a Transaction Source and Default Date for this submission. If you are submitting the AutoInvoice Master program, enter a Number of Instances.
To limit the transactions AutoInvoice imports, enter selection criteria. For example, enter a Transaction Type, range of Bill to Customer Names, or Transaction Numbers to import only those transactions. Leave a field blank if you do not want to limit this submission to transactions matching that criteria.
5. To print the results of this submission, enter Print Options. Enter the number of Copies to print, a printing Style, and the Printer to use.
6. To save the output to a file, check the Save Output check box.
7. Choose Submit. Receivables displays a concurrent Request ID for this submission and creates the AutoInvoice Execution report. If you have lines that fail validation, AutoInvoice also creates the AutoInvoice Validation report. Use these reports to review the results of your AutoInvoice submission. See: AutoInvoice Reports.
You can view the status of your request in the Concurrent Requests Summary window.
To run the AutoInvoice purge program:
1. Navigate to the Run AutoInvoice window.
2. Enter a request Name of AutoInvoice Purge Program.
3. To print the results of this submission, enter Print Options. Enter the number of Copies to print, a printing Style, and the Printer to use.
4. To save the output to a file, check the Save Output check box.
5. To run this report more than once, enter Run Options. You can enter a Resubmit interval, a date and time To Start the resubmission, and an ending date on which to cease repeating.
6. Choose Submit. Receivables displays a concurrent Request ID for this submission. You can use this number to review the status of your request in the Concurrent Requests Summary window.
See Also
Importing Invoice Information into Receivables Using AutoInvoice
Using AutoInvoice
Importing Invoices with Rules
Invoices with Rules
Importing Credit Memos
Monitoring Requests