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.
See: Importing Transaction Information Using AutoInvoice.
Note: You cannot use AutoInvoice to update existing invoices in Receivables. You can, however, create credit memos and apply them to existing invoices if the invoices are still open (or if the Allow Overapplication check box is checked for that transaction type).
You can submit the AutoInvoice Import, Master, and Purge programs from the Submit Request window. However, you can only submit the AutoInvoice Master and Purge programs from the Run AutoInvoice window. The Master program lets you run several instances of AutoInvoice to improve system performance and import transactions more quickly.
Suggestion: To cancel a submission of the AutoInvoice Master program, you should cancel each child program individually. Do not cancel the Master program itself.
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.
Note: You can also export invoices using the Oracle e-Commerce Gateway. The e-Commerce Gateway lets you exchange information electronically with your business partners using an agreed upon, standard format. For more information, please refer to the Oracle e-Commerce Gateway User Guide.
Prerequisites
Navigate to the Run AutoInvoice window.
Enter a request Name of AutoInvoice Master Program.
Enter the Number of Instances to submit.
An instance refers to how AutoInvoice groups and processes your transactions. Submitting a greater number of instances lets you import transactions into Receivables more quickly. You can submit a maximum of 15 instances.
Suggestion: Enter a number of instances based on how many CPUs are available. Use the following formula to determine the number of instances to enter:
(Number of Available CPUs) - 1 = Number of Instances
For example, if you have five CPUs, submit four instances of the AutoInvoice Master program.
Select an Organization. Receivables lets you select either any one operating unit from among the operating units to which you have access or All as the value for the Organization parameter.
Your choice of the Organization parameter affects the Invoice Source parameter. When you select a single operating unit, you can select only the batch sources for that operating unit as value for the Invoice Source parameter.
When you select All as the value for the Organization parameter, the list of values of batch sources includes all batch sources across all operating units to which you have access. If the value of the Organization parameter is All, when you submit the AutoInvoice Master program, the program runs one or more separate import processes for each organization containing batch source records. For example, assume that you have access to four organizations and you select All as the value for the Organization parameter while submitting the AutoInvoice Master program and select ORDER ENTRY batch source as the value for the Invoice Source parameter. If there are transaction records only in three of the organizations bearing the ORDER ENTRY batch source name then three separate import processes are run, one for each operating unit.
Note: When you submit the AutoInvoice Master program for All organizations, some of the other AutoInvoice Master program parameters may not work as effectively. For example, sales order numbers may not be relevant or contiguous across multiple organizations, and customers may or may not be present in each so parameters at that level of granularity may not bring the desired results if used in conjunction with All organizations.
Enter a Transaction Source and Default Date for this submission. These parameters are required. The Default Date must be in an open or future enterable period.
Depending on how you defined your transaction batch source and if the invoice uses rules, AutoInvoice uses the Default Date if the GL date is not provided or if the date provided is in a closed period. See: Determining Dates.
To limit the transactions AutoInvoice imports, enter selection criteria. For example, enter a Transaction Type, range of Bill to Customer Names, GL Dates, Ship Dates, 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. Use the Transaction Flexfield parameter to specify which lines you want to import.
Choose whether to Base the Due Date on Transaction Date.
If you enter Yes, then AutoInvoice derives the due date for each transaction based on the transaction date.
If you enter No, then AutoInvoice looks at the setting of the Derive Date option for the transaction's batch source to derive the due date:
If Derive Date is No, then AutoInvoice uses either the rule start date, the transaction date, or the Default Date that you specified for this submission.
If Derive Date is Yes, then AutoInvoice uses the same derivation logic that it uses to determine the GL date. See: Determining Dates.
Enter a number of Due Date Adjustment Days (optional).
If Base Due Date on Transaction Date is Yes, then AutoInvoice ignores this parameter.
If Base Due Date on Transaction Date is No, then AutoInvoice compares the due date that was derived in the previous step against the transaction date plus the number of days that you enter here. AutoInvoice uses whichever date is later as the final due date.
If you do not enter any adjustment days, then AutoInvoice uses the due date that was derived in the previous step.
Choose OK.
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.
To save the output to a file, check the Save Output check box.
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 Requests window.
Navigate to the Run AutoInvoice window.
Enter a request Name of AutoInvoice Purge Program.
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.
To save the output to a file, check the Save Output check box.
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.
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.