What is a Transaction?
Transactions are created when documents are posted to the general ledger
. Some documents are posted manually by users, but other types of document, such as cash matching journals, are posted automatically.
The Transactions tab displays a home page that lets you
quickly locate your transactions. You can also sort and filter your transactions
using standard and custom list views. In addition, this tab lets you view
detailed information on each transaction.
The Transactions Line Items tab displays a home page that lets you
quickly locate your transaction line items. You can also sort and filter your transaction line items
using standard and custom list views. In addition, this tab lets you view
detailed information on each transaction.
A transaction generated from a document comprises a transaction header and multiple transaction line
items. In the case of an invoice or credit note
, there are three types of transaction line item:
- Account – identifies the customer or vendor account.
- Analysis – identifies the product or service.
- Tax – summarizes the tax by each tax code that is specified on the originating invoice or credit note.
Lines are created in the sequence – Account, Analysis, and then Tax.
A single invoice or credit note will generate two or more transaction line items, each of which is posted to the general ledger. The sum of these transaction line items is zero.
Currency Conversion and Exchange Rates
During the manual posting of a document in a multi-currency org, its values are converted from
the currency recorded on the document (its document currency
) to the following
other currencies:
- the company's home currency
- its dual currency
- its reporting currency
(if the feature is enabled)
- all other dimension currencies: account (customer or vendor), general ledger account, bank account and all four custom analysis dimension currencies.
The exchange rates used are those specified on the company detail page. The date used to select the appropriate rate is the document date.
In the case of a cash matching journal, its discount, write-off and currency write-off, and auxiliary GLA values are stated in matching currency. These are converted at the time of posting to home, dual, reporting, and account currency. The conversion to general ledger account and dimension 1-4 currency is from home currency using the exchange rate applicable on the matching date.
Match Statuses
A transaction line item can be in one of the following match statuses:
Match Status | Description |
---|---|
Available | Line is available for matching. |
Matched | Line has been matched. |
Not Matchable | Line is unsuitable for matching. An example of this is the tax line from an invoice. |
Proposed | Line has been included in a payment proposal. It is not available for manual matching nor is it available for inclusion in subsequent payment proposals. |
When the match status or outstanding value of a transaction account line is updated, the following related values are also updated:
- The account line summary on the transaction.
- The payment details on the related document.
The Transaction object is a company-owned object. New transactions and associated line items are assigned to the company queue
that represents your current company
.
Withholding Tax Transaction Lines
A transaction line showing the value of Withholding Tax is created when a payable Invoice or payable credit note is posted that contains one or more lines that is withheld from tax. The type for these lines is set to Tax.
One summarized withholding tax transaction line is created per payable invoice or payable credit note that contains Withholding Tax. The Withholding Tax amount is displayed as a transaction line with a negative value.
For more information, see Withholding Tax on Payable Invoices.