Apps To Fusion

.......Our Journey from Apps To Fusion

 
  • Increase font size
  • Default font size
  • Decrease font size



HOW TO DEFINE TRANSACTION TYPES IN ORACLE RECEIVABLES

E-mail
User Rating: / 3
PoorBest 
In this article, Mr Ahmad Bilal explains detailed steps to setup transaction type in Oracle Receivables. Define the transaction types that we assign to invoices, debit memos, commitments, chargeback, credit memos, on–account credits, and bills receivable.
Oracle Receivables use transaction types to default payment term, account, tax, freight, creation sign, posting, and receivables information.
Oracle Receivable provides two predefined transaction types:


  1. Invoice

  2. Credit Memo.


We can create receivable transaction type by using following steps


  1. Sign on to the application using Receivables Super user Responsibility.


  1. Navigate to the Transaction Types Form

Setup / Transactions / Transaction Types


  1. In operating Unit field by default current operating unit is populated Vision Operations


  1. Enter a Name and Description for this transaction type.



Name: = XX Credit Memo

Description:-This is a Sample Credit Memo


  1. Enter a Class for this transaction type.


Following are the seeded classes provided by oracle

  1. Invoice

  2. Chargeback

  3. Credit Memo

  4. Debit Memo

  5. Deposit

  6. Guarantee


In credit memo case I select Credit Memo


  1. Open Receivable is set to Yes,

Receivables updates customer balances each time we create a complete debit memo, credit memo, chargeback,
or on-account credit with this transaction type. Receivables also include these transactions in the standard aging and collection processes.



  1. Check the Post to GL box

To be able to post transactions with this type to general ledger.
The default is the value specified for the Open Receivables option. This box must be checked if the class is Deposit or Guarantee.






  1. Choose Print. We can override this value when entering transactions in transaction window.


  1. Choose Transaction Status of Open from open, Closed, Pending, or Void.

Use these statuses to implement our own invoice approval system. Enter 'Void' to void debit memos, on-account
credits or invoices to which we want to assign this transaction type.


  1. Check the Allow Freight box.

Allow freight to be entered for transactions with this transaction type


  1. Check the Tax Calculation box.

Receivables calculate tax for transactions with this transaction type.
If we do not check this box, the Tax Code field in the Lines window will not be required and Receivables
will not perform tax calculations or create tax accounting entries for transactions with this
transaction type (this is also applicable for transactions in Oracle Order Management).


  1. Choose Creation Sign Negative.

The default is Positive Sign for transaction types with a class of either Guarantee or Deposit.
If we are using the Cash Basis accounting method, Transaction's creation sign must be Positive Sign, Negative Sign, or Any Sign.
We cannot update this field after entering transactions with this type.

  1. Select the Natural Application Only check box. We cannot update this option after save this transaction type.

  1. Enter the Receivable Account for transactions with this transaction type.
    Receivables use this information, along with Auto Accounting definition, to determine the receivable accounts
    for transactions with these types.
    Receivables creates a receivables transaction record using this account so we can transfer to general ledger and
    create a journal entry if Post To GL is Yes for this transaction type.

 

  1. Enter receivable account “Accounts Receivable” .
    Receivables does not require entering a Receivable account for Credit Memo transaction types if the profile option Use
    Invoice Accounting for Credit Memos is set to YES otherwise, must enter a Receivable Account.



  1. Enter a Freight Account for transactions with this transaction type.
    Receivable uses this information, along with Auto Accounting definition, to determine the freight account for transactions with this transaction type.



  1. Enter Revenue Account Receivables does not require to enter a Revenue Account for Credit Memo transaction
    types if the profile option Use Invoice Accounting for Credit Memos is set to YES. Otherwise, must enter a Revenue Account.


  1. As this is a credit memo so we need to define UNBILLED RECEIVABLE ACCOUNT.
    Receivable uses this information, along with Auto Accounting definition, to determine the Unbilled Receivable
    account for transactions with this transaction type.
    Receivable only uses the Unbilled Account field to determine the Unbilled Receivable account for invoices with the rule Bill in Arrears.


  1. Enter an Unearned Revenue Account. Receivable uses this information, along with Auto Accounting
    definition, to determine the unearned revenue account for transactions with this transaction type.
    Receivable only uses this account when transaction's invoicing rule is Bill In Advance.


  1. Enter a Tax Account. Receivable uses this information along with Auto Accounting
    definition to determine the tax account for transactions with this transaction type.


  1. Save this credit memo transaction type now.



  1. Navigate to the Transaction Form

Transaction  Transactions




Look in above screen shot I have select XX Credit Memo Type

Comments (20)add
...
written by srikanth , August 08, 2007
thanks for the valuable resources...thank you very much
report abuse
vote down
vote up
Votes: +0
...
written by Giri p , September 07, 2007
thank u ...ur document is very helpful..... can u mail me some more docs related to oracle receivables technical

This e-mail address is being protected from spambots. You need JavaScript enabled to view it
report abuse
vote down
vote up
Votes: +0
...
written by srinivasM , September 15, 2007
it is an excellent screenshot, can u pls help me in creation of grouping rules and line order rules
report abuse
vote down
vote up
Votes: +0
...
written by Dinesh.Jonna , September 16, 2007
Hi Anil Passi U r doing a wonderful job,
as per my view every apps consultant useful this site.
(Ohhh Great i never seend like this much of explanation,
its very useful to me.)

report abuse
vote down
vote up
Votes: +0
...
written by Dinesh.J , September 18, 2007
Hi., Great wishes to anil passi ., to strat this site .
it gives very very useful information to me., i think not only me all oracle apps consultants.
i sinceyarly thnks to anil Passi and his team
Long leave anil passi......
report abuse
vote down
vote up
Votes: +0
...
written by Muralidhar , September 21, 2007
Hi Anil,

I am workig on Billing and Receiopt History Report. I need to raise an On Account Credit Transaction in AR. Can you please let me know whats the navigation.I am stuck here.

Thanx
Murali
report abuse
vote down
vote up
Votes: +0
...
written by Muralidhar , September 21, 2007
Hi Anil,

I am workig on Billing and Receiopt History Report. I need to raise an On Account Credit Transaction in AR. Can you please let me know whats the navigation.I am stuck here.I need to fix a Problem

Thanx
Murali
report abuse
vote down
vote up
Votes: +0
...
written by phili , December 13, 2007
Images are not getting displayed can you please repost the topic, thnks anil the articles u posted are very helpful

thnx,
phili
report abuse
vote down
vote up
Votes: +0
I want to know How the debit note and credit note works in Accounting....
written by Raghavendra PM , December 18, 2007
pls send to my E-Mail ID and Images are not getting displayed
report abuse
vote down
vote up
Votes: +0
functionality of Transaction types
written by arun , December 26, 2007
Hi Anil,

Could you please explain the difference between the transaction types(Invoices,credit memo,debit memo etc) in oracle receivables.

Regards
Arun
report abuse
vote down
vote up
Votes: +0
I wish you a happy new year
written by satish , January 02, 2008

Hi Anil,

I wish you a happy new year to you and your team.

Regards
S.Satish kumar
This e-mail address is being protected from spambots. You need JavaScript enabled to view it


report abuse
vote down
vote up
Votes: +0
What are the common errors to be handled by Financil functional Consultant in the role of customer support job
written by Rajeev Ranjan , January 12, 2008
Hi Al,

Can you please send/scrap me the types of errors that a financial consultant will have to encounter in the role of customer support job...

Thanks,
Rajeev
report abuse
vote down
vote up
Votes: +1
How to convert Account Values from Legacy to Oracle Apps Base Table
written by manikandan , January 25, 2008
While converting Account values from Legacy to Oracle Apps Base Table the segment qualifiers ie.,allow budgeting allow posting,Account Type,Third party control,Reconcile flags are not inserting.Can You please guide how to do this.
report abuse
vote down
vote up
Votes: +0
...
written by Arvind Kumar , November 15, 2008
Hi

I am quite new to oracle financials and interested in OM and AR module. specially order to cash.

Just wondering what is the daily job task of AR functional consultant. Once the organization has implemented oracle 11i financial modules.
And the project is already go-live.

What task a Functional consultant will perform who knows AR, OM (order to cash). What is his role in daily task, month end task, and year end task.

Your valuable suggestion will be appriciated.

thankyou

regards

Arvin
report abuse
vote down
vote up
Votes: +0
...
written by sanal , February 25, 2009
Is there a way to define GL numbers for in Transaction code for debit memo ? I have written an interface program to upload some entries to Accounts Receivables and is working fine. But by defalut it is going to an account 1-000-7405-00. Actually these are all debit write offs so I need to explicitly assign this to another number 1-000-6135-00..I have tried mentioning this in revenue account in transaction code but no luck. As you mentuioned earlier I think auto account definition is overiding this number. How do I check the the auto account definition ?

report abuse
vote down
vote up
Votes: +0
Accounts Receivables
written by srinivasa , August 30, 2009
Pls send me articles related to OM and AR
report abuse
vote down
vote up
Votes: +0
Prepayments
written by shwalk , October 11, 2010
How do you define Prepayment Application Type?
report abuse
vote down
vote up
Votes: +0
Duplicate Transaction Types
written by KD , November 12, 2010
We're trying to duplicate a current transaction type. When we click Edit, Duplicate, the options Record Above or Record Below are not highlighted to choose. We have been able to do it in the past. What could have changed? We have used the same transaction type as a template for two previous stores. We have a new one and want to duplicate a current transaction type for this one. Why won't it let us now?
report abuse
vote down
vote up
Votes: +0
ORACLE RECEIVABLES
written by Wade Henderson , June 08, 2011
Several of our clients use this system and are pleased with it.

http://immfinancial.com
report abuse
vote down
vote up
Votes: +0
respond this post
written by WeeksHerminia , July 19, 2011
All people deserve wealthy life time and home loans or financial loan can make it better. Because freedom is grounded on money state.
report abuse
vote down
vote up
Votes: +0
Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger

security image
Write the displayed characters


busy
Last Updated ( Friday, 27 July 2007 16:36 )  

Search apps2fusion