Overview of Transaction Account Definition

You can configure rules in Subledger Accounting (SLA) to automatically derive account combinations. You can also enter the account combinations directly in the UI, or derive them by starting the invoice account coding workflow. However, both of these approaches involve manual intervention which ends up slowing the invoice processing.

Transaction Account Definition (TAD) can be used for any product feature that has accounting implications, and accesses the chart of accounts component while creating transactions.

Transaction Account Definition for Payables

Oracle Payables leverages the Transaction Account Definition (TAD) from SLA to automatically derive expense accounts on item, freight, and miscellaneous invoice lines on invoice creation. This applies to the invoices created either automatically by the import process or manually through the UI.

You can use TAD to configure a set of rules to derive accounts based on attributes (also called sources) from multiple objects. For example, you can check the attributes from Invoice header, lines, distributions, Payables setups, Projects, and so on, to build your own rules. You can use TAD to do either of the following.

  • Derive all segment values of the accounting flexfield separately, and then build the full account combination.
  • Derive (and overwrite) only some segment values, while still using the base account combination.
Note: You can't define your own sources to derive accounts. You must use the sources predefined by Oracle.

To review the available sources for configuring rules:

  1. Navigate to the Setup and Maintenance page.
  2. Search for the Define Subledger Accounting for Invoicing and Payments task list and then select the Manage Transaction Account Types task.
  3. Click any of the listed transaction account types.

All the assigned sources are listed in detail.

Applicability

To derive account combination details for Payables invoice lines using TAD, you must ensure that these conditions are fulfilled.

  • Account derivation through TAD is enabled in Manage Invoice Options setup.
  • Invoice type is Standard, Debit Memo, or Credit Memo. It isn't applicable for Payment Request, or Prepayment.
  • Invoice line type is Item, Freight or Miscellaneous.
  • Invoice line isn't matched to a purchase order.
  • Distributions aren't yet generated for the invoice line.
  • Invoice line isn't canceled, and doesn't have account combination details or a distribution set either provided by the user or defaulted from any setups (Supplier configuration or Payables options).
  • Invoice isn't in incomplete status.

Deriving Accounts Using TAD

If the invoice meets the applicability criteria, invoice expense accounts are automatically derived through TAD for the eligible invoice lines when these events happen:

  • When invoices are created through the Payables Invoice Import process
  • When invoices are validated either online or through the Validate Payables Invoice process

You can manually force TAD-based account derivation from the UI by selecting the invoice line and clicking Derive Account. You can select multiple invoice lines for this operation. The application clears away any existing account combination or distribution set for the selected lines and begins the account derivation process.

Important: The applicability criteria still apply even while forcing the account derivation.