Import Auto Invoice Functionality

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.

Steps 1: Download FBDI for auto invoice and generate zipped data file:

https://docs.oracle.com/en/cloud/saas/financials/19a/oefbf/AutoInvoice-Import-313322827-fbdi-1.html

Fill the data in Excel Template Format and don’t change the sequencing of the column.

Click on Generate CSV and save the zipped file

Step 2: Upload the zipped data file in interface tables:

 

How Imported Data Is Processed

The AutoInvoice import process contains three phases: validation, grouping, and transfer.

In the validation phase, AutoInvoice validates all line-level data in the interface tables, and validates additional data that is not dependent upon a successful grouping. Additional data validations include, for example, validating transaction types and validating that only one freight account exists for each freight line passed.

In the grouping phase, AutoInvoice groups the validated lines in the interface tables according to the settings of the active AutoInvoice grouping rule and AutoInvoice line ordering rule, and validates header-level data needed for a successful grouping.

In the transfer phase, AutoInvoice transfers the grouped transactions to the Receivables tables and validates the transferred data.

Step 3: Run the Import Auto Invoice program:

Processing Freight Lines and Late Charges

AutoInvoice ensures that there is at most one freight line for an imported invoice, or at most one freight line per transaction line, but not both. If you import multiple header freight lines for one invoice, AutoInvoice validates that all of the freight lines apply to the same freight account and consolidates them into one line. This consolidated freight line is the only freight line for this invoice that is passed to the Receivables tables. If all of the freight lines don't apply to the same freight account, then AutoInvoice rejects the invoice.

If AutoAccounting for Freight is based on Standard Lines, then you can't import invoices with header level freight. All freight lines in this case must be associated with a standard line in order for AutoAccounting to determine the account. If the transaction has a line type of LINE with an inventory item of freight, AutoAccounting uses the revenue scheduling rules for the freight account rather than the revenue account.

AutoInvoice processes both debit memos with late charge lines and credit memos that are against debit memos with late charge lines. If LINE_TYPE = CHARGES, AutoInvoice doesn't calculate tax, freight, or sales credits on this line. If you pass a late charges distribution in RA_INTERFACE_DISTRIBUTIONS_ALL, then the ACCOUNT_CLASS must equal CHARGES.

Purging of records from interface:

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.