Transaction Types are used in Oracle Account Receivables (AR) to define the accounting for the debit memos, credit memos, on-account credits, chargebacks, commitments, and invoices which are created in Oracle Account Receivables (AR) . Transaction types are also used to determine whether transaction(s) updates customers’ balances and if the Account Receivables (AR) posts the transactions to the General Ledger
Oracle Account Receivables (AR) provides the following transaction types:
- Invoice
- Credit Memo ,
- Projects Credit Memo ,
- Projects Invoice ,
- Intercompany
Responsibility: Receivables Manager
Navigation: Setup > Transactions > Transaction Types
Field details for the Transaction Types Setup :
Operating Unit: OU which will use these transaction type
Name : Name of the Transaction Type
Description: Description of the Transaction Type
Class: Invoice, Chargeback, Credit Memo, Debit Memo, Deposit, or Guarantee
Legal Entity: provide the Legal Entity Name
Open Receivables: Select if transactions with the defined type is to be used to update customer balances
Post to GL: Select if transactions with the defined type is to be posted to General Ledger . The check box must be checked if the class is Deposit or Guarantee. If transaction is defined as a ‘void’ transaction type, do not check this box
Create Sign : For Credit Memo , set value as Negative Sign , for others set value as Positive Sign
Printing Option: Default Printing Option for the transaction type
Transaction Status : Open / Closed / Pending / Void
Natural Application: The check box must be checked if the class is Deposit or Guarantee
Allow Freight : To allow freight to be entered for transactions with this transaction type, check the Allow Freight check box
Receivable Account : Provide the Receivable Account for transactions with the transaction type. Receivables uses it with AutoAccounting definition, to determine the receivable accounts for transactions with these transaction types. Receivables creates a receivables transaction record using this account so you can transfer to your general ledger and create a journal entry if Post To GL is Yes for this transaction type.
For guarantee transaction types, provide the Accounting Flexfield for the Unbilled Receivable account
For Guarantee and Deposit transaction types, provide the Accounting Flexfield for the Unearned Revenue account if Allow Freight is set to No
Credit Memo transaction types Receivable Account is not required
SQL Query to get the list of Active Transaction Types in Oracle Apps R12 AR:
SELECT RCTTA.ORG_ID,RCTTA.NAME , RCTTA.DESCRIPTION, RCTTA.POST_TO_GL, RCTTA.STATUS, RCTTA.ACCOUNTING_AFFECT_FLAG, RCTTA.DEFAULT_STATUS , RCTTA.ALLOW_FREIGHT_FLAG, RCTTA.ALLOW_OVERAPPLICATION_FLAG, RCTTA.START_DATE, RCTTA.TAX_CALCULATION_FLAG,RCTTA.SET_OF_BOOKS_ID FROM RA_CUST_TRX_TYPES_ALL RCTTA WHERE RCTTA.STATUS =’A’ |