Thursday, May 5th, 2011

General Ledger R12 Alternate Account: Great new functionality

In Release 12 Oracle has introduced new functionality Called ‘Alternate Account’. This new functionality is very usefull when when you have major changes in your account code combinations. Recently we have made major changes in the Accounting Flexfield for a customer and we have end-dated all active code combinations and defined a whole new range of code combinations. The new range was succesfully added to the old disabled range using the alternate account field.

With this great functionality we were able to implement a great and major change fast and at the same time we did not had to change the accounting created on already entered transactions (with old and disabled code combinations) in the subledgers (AP/AR). 

When Transactions in the subledgers are send to GL with old and end-dated code combinations, GL automatically replaces the code combination during Journal import what results into the alternate account when you post the journal. Of course there are some attention points that you have to take into account when implementing this solution but I’m very exited about this functionality!  See below picture the screen where you can use this new field.

Some of the attention points you have to consider are:

  1. Alternate account functionality does not work (yet) for encumbrance accounting.
  2. When you reconcile GL code combination balances with Subledger (AP/AR) balances at period-end you have to include the alternate account functionality because in the Subledger (AP/AR) the Balance is on the disabled account and in GL the Balance is on the Alternate account.

If you’re interested in using this new and great functionality and you want to know the whole story please let me know.

alternate account

 Viewed 6975 times by 1938 visitors


Category: Finance / General
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

6 Responses (last comment shown first)

May 24, 2012
Preethi
avatar

Hi , Im Intrested in knowing more about this functionality. Kindly let me know in detail.

[Reply to this comment]


March 19, 2012
Vivek gupta
avatar

Can you let me know the functionality in details

Thanks,
Vivek g

[Reply to this comment]


February 3, 2012
Dinesh
avatar

I would like to know the detailed information towards replacement of Disable Account Value. Thanks in advance.

[Reply to this comment]


January 27, 2012
Tom Kelly
avatar

Hi, I am just about to implement a major chart of accounts change and I am investigating using the ‘Alternative Account’ functionality. I would be very interested to learn more about your experience in using this functionality.
Regards, Tom

[Reply to this comment]


January 16, 2012
adil syed
avatar

Hi, I am Oracle functional consultant and learning new functionality about GL Alternate account in Oracle R12. I am very interested to learn more about your experience in using this functionality and will greatly appreciate if you can provide me more info. on this.

Very truely
Adil

[Reply to this comment]


November 8, 2011
BHASKAR MALLICK
avatar

Sir,
I have an exposure in Oracle 11i in Fin. Modules only. I have worked over 5 years though right i am not in tough. But i would like to know the special features available in R12 which are not in 11i. Kindly let me know in detail.

[Reply to this comment]