Secondary Ledger R12

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
chaitu_apps
Posts: 64
Joined: Thu Jul 19, 2007 1:02 am
Location: India

Secondary Ledger R12

Post by chaitu_apps »

Can any one help me on the below issue.

We have two ledgers (primary and secondary ledger) Primary ledger using with US GAAP and Secondary Ledger using with China GAAP.

Issue as below...

Primary ledger with USGAAP for AP and FA Module

I attach Secondary ledger for China GAAP(AP and FA Module) so that Accounting entries from above will come here also.

For FA I have following requirement for Assets =5000USD

In Primary ledger:

For assets =5000USD we expenses it with accounting entry in AP module

AP distribution expense a/c Dr
TO AP Liability a/c



In Secondary Ledger:

I want the same entry to be capitalized as China GAAP has different treatment like

Asset cost A/c Dr
TO Asset Clearing A/C


When I do Create accounting for AP the following entry Should occur.

I know that using mapping sets and making changes to ADR and AMB and attaching The SLAM to secondary ledger I can achieve this.

Please confirm should I make ADR Changes for Assets or Payables to achieve this result for Secondary Ledger.

Appreciate your early response on this.
chaitu_apps
Posts: 64
Joined: Thu Jul 19, 2007 1:02 am
Location: India

Post by chaitu_apps »

Hi admin and friends,

Please give your thoughts on this....
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

Ok in short,
for one ledger your asset purchase transaction must be treated as EXPENSED ASSET and for another ledger it must be treated as CAPITALISED ASSET and taken to fixed asset module for maintaing it as an asset.

In order to transfer an asset from payables to Asset module, we need to have our Asset clearing account entered in the payables distribution as charge account.

For Primary ledger, you enter your expense account as a charge account and track it as an expensed asset.

For secondary ledger, even if you change or place an condition in AAD , it will use that account only for accounting purpose and that does not change any details in your distribution account.....

As this thread was unattended, just sprayed my thoughts....
will check and revert back, if i get any workaround.
panuturi
Posts: 1
Joined: Mon Mar 22, 2010 5:33 am
Location: Indonesia

Post by panuturi »

Hi all,

I do have the same issue as above. Any one has a solution or workaround ?

Highly appreciate for any solution and workaround.

Thanks
anjan123
Posts: 151
Joined: Tue Jun 26, 2007 1:06 am
Location: India

Post by anjan123 »

Hi Folks,

As per my understanding as follow, you Ledger "A" and ledger "B".


A is primary and B is secondary.

you treated in as a expense item in Ledger "A" the entry is as follow.

Asset clearing Account Dr

to AP liability Account. Cr

when you transfer this asset to ( here we need to define 2 assets books so Asset Book "A" and Asset Book "B")Asset book "A" here the entry as follow.

Asset cost account dr

Asset clearing Cr.

now go to secondary ledger create an asset in Asset book "B".

Asset Cost Dr
and Asset clearing Cr

so the entry will be double if this is the case, how you restrict this through SLA?

regards
Anjan
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests