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 and multiperiod accrual account 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.
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:
- Navigate to the Setup and Maintenance page.
- Search for the Define Subledger Accounting for Invoicing and Payments task list and then select the Manage Transaction Account Types task.
- 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.
The applicability criteria still apply even while forcing the account derivation.
Deriving Multiperiod Accrual Account Using TAD
For multiperiod accrual accounting, the user must enter either all 3, or none of these multiperiod accounting attributes:
- Start date
- End date
- Multiperiod accrual account
Entering partial values displays an error message to the user. This check ensures that the invoice has the required data to generate multiperiod accrual accounting.
However, this check restricts the use of the TAD to default multiperiod accrual accounts as it always forces the user to enter the account even before the TAD can be called. To allow the use of TAD to default multiperiod accrual accounts, there are changes in the standard behavior of multiperiod accounting as shown here.
These changes are applicable only when the TAD is enabled in the Payables Invoice Options.
Process/Page Name | Changes for Multiperiod Invoice Lines |
---|---|
Invoice Import process |
|
Create Invoice page |
|
Invoice Validation process |
|