Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Receivables
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

×

Warning

JUser: :_load: Unable to load user with ID: 859

HOW TO DEFINE TRANSACTION TYPES IN ORACLE RECEIVABLES

 

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   

0 #1 srikanth 2007-08-08 06:06
thanks for the valuable resources...tha nk you very much
Quote
0 #2 Giri p 2007-09-07 07:30
thank u ...ur document is very helpful..... can u mail me some more docs related to oracle receivables technical

Quote
0 #3 srinivasM 2007-09-15 15:41
it is an excellent screenshot, can u pls help me in creation of grouping rules and line order rules
Quote
0 #4 Dinesh.Jonna 2007-09-16 02:28
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,
it s very useful to me.)
Quote
0 #5 Dinesh.J 2007-09-18 11:13
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......
Quote
-1 #6 Muralidhar 2007-09-21 16:14
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
Mu rali
Quote
0 #7 Muralidhar 2007-09-21 16:19
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
Quote
0 #8 phili 2007-12-13 21:15
Images are not getting displayed can you please repost the topic, thnks anil the articles u posted are very helpful

thnx,
phili
Quote
0 #9 Raghavendra PM 2007-12-18 11:17
pls send to my E-Mail ID and Images are not getting displayed
Quote
0 #10 arun 2007-12-26 08:59
Hi Anil,

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

Regards
Arun
Quote
0 #11 SAMEER BERRY 2008-01-02 04:21
Hi Anil,

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

Regards
S.Satish kumar
Quote
0 #12 Rajeev Ranjan 2008-01-12 15:30
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
Quote
0 #13 venkat 2008-01-25 11:56
While converting Account values from Legacy to Oracle Apps Base Table the segment qualifiers ie.,allow budgeting allow posting,Account Type,Third party control,Reconci le flags are not inserting.Can You please guide how to do this.
Quote
0 #14 Arvind Kumar 2008-11-15 03:53
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.

t hankyou

regard s

Arvin
Quote
0 #15 sanal 2009-02-25 21:54
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 ?
Quote
0 #16 srinivasa 2009-08-30 12:58
Pls send me articles related to OM and AR
Quote
0 #17 shwalk 2010-10-11 01:22
How do you define Prepayment Application Type?
Quote
0 #18 KD 2010-11-12 10:14
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?
Quote
0 #19 Wade Henderson 2011-06-08 20:24
Several of our clients use this system and are pleased with it.

immfinancial.com
Quote
0 #20 WeeksHerminia 2011-07-19 20:39
All people deserve wealthy life time and home loans or financial loan can make it better. Because freedom is grounded on money state.
Quote
0 #21 slot 633 2022-05-22 06:48
Hello there! I know this is kinda off topic but I was wondering which blog
platform are you using for this website? I'm getting tired of Wordpress because I've had problems with hackers and I'm looking at alternatives for
another platform. I would be awesome if you could point me
in the direction of a good platform.
Quote
0 #22 Julie 2022-05-30 20:06
For most recent news you have to pay a visit internet and on the web I
found this web site as a finest site for newest updates.
Quote
0 #23 สล็อต xo 2022-07-06 10:40
Currently it appears like Wordpress is the preferred blogging platform
out there right now. (from what I've read) Is that what
you are using on your blog?
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
22232425262728
2930     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner