1. Using Receivables Credit to Cash
  2. AutoInvoice Import and Transaction Distributions

AutoInvoice Import and Transaction Distributions

You can assign distributions to transactions during AutoInvoice import.

You can assign distributions in either of two ways:

  • Using the AutoInvoice Interface Tables

  • Using AutoAccounting

The values that you can pass to AutoInvoice for the accounting flexfield are either accounting segment values or account code combination IDs. Use the Accounting Flexfield option in the Accounting section of the Import Information section of the transaction source assigned to transactions to set the value that you plan to use.

Assign Distributions Using the AutoInvoice Interface Tables

If you pass accounting flexfield segment values, you must assign values to the SEGMENT1-30 columns of the RA_INTERFACE_DISTRIBUTIONS_ALL table. You can only assign values to enabled segments. For example, if you enable six accounting flexfield segments, then assign values to SEGMENT1-6 only.

If you pass accounting flexfield code combination IDs, you must enter the code combination IDs in the CODE_COMBINATION_ID column of the RA_INTERFACE_DISTRIBUTIONS_ALL table.

Note: If you want to use the option of AutoInvoice dynamically inserting code combinations, you must pass segment values.

If you're using event-based revenue management to automatically defer or recognize revenue for imported transactions, and you want to pass code combination IDs for the applicable transaction lines, then you must ensure that the OVERRIDE_AUTO_ACCOUNTING_FLAG column of the RA_INTERFACE_LINES_ALL table is set to Yes.

Assign Distributions Using AutoAccounting

If you want AutoAccounting to determine your transaction distributions, don't enter values in the RA_INTERFACE_DISTRIBUTIONS_ALL table. Use the AutoAccounting pages to define your revenue, receivables, tax, freight, clearing, unbilled receivable, and unearned revenue accounts.

After you define AutoAccounting, AutoInvoice determines all of your distributions using the account information that you pass for each transaction line.

If AutoAccounting for the freight account is based on Standard Lines, you can't import invoices with header level freight. If the transaction has a line type of LINE and an inventory item of freight (FRT), AutoAccounting uses the rules for the freight type account rather than the revenue type account.

If AutoAccounting is based on Salesperson, then you must pass rows in the RA_INTERFACE_SALESCREDITS_ALL table for each invoice line in the RA_INTERFACE_LINES_ALL table. This is true even if the Require salesperson Receivables system option isn't enabled.