Creating accounts for a new CC based on a current CC is shown below:
Here you will find Oracle bits and pieces of info teased from the net and consolidated in a single location. Everything from how to's to info bites about the Oracle EBS domain.
Showing posts with label GL. Show all posts
Showing posts with label GL. Show all posts
Wednesday, February 19, 2014
Document Sequencing in General Ledger
You can assign only one active document sequence scheme to each unique
combination of:
General Ledger automatically creates journal entries for actual transactions when you perform the following tasks:- Application, Category
- Set of Books
- Method (Auto or Manual entry)
Monday, January 27, 2014
Consolidation Example
This one is for the Parent Consolidation shown fully.
The one below is for the Parent/Sub who consolidates its two subs.
Here is the full list of initiating entries for all 4 companies
Friday, February 22, 2013
Mass Allocations
To Allocate down do:
A =Source or SUM or Summary Acct
B/C =CC-SQFT(LOOP)/TOTAL-SQFT(SUM-unless Summary Acct)
T =Target(LOOP)
O = Same as source
To Clear accounts to one account (T becomes the offset and O becomes the Target)
A =Loop the CC's
B/C =-1/1 (to create the opposite of the balance on account)
T =Loop the CC's
O =Destination of all the balances
Note: Don't use a SUM on a summary value.
A =Source or SUM or Summary Acct
B/C =CC-SQFT(LOOP)/TOTAL-SQFT(SUM-unless Summary Acct)
T =Target(LOOP)
O = Same as source
To Clear accounts to one account (T becomes the offset and O becomes the Target)
A =Loop the CC's
B/C =-1/1 (to create the opposite of the balance on account)
T =Loop the CC's
O =Destination of all the balances
Note: Don't use a SUM on a summary value.
Saturday, February 16, 2013
Thursday, February 14, 2013
Consolidations Equity method
Purchase price - (RE + equity) Equals the differential.
Differential gets adjust to zero by one of the following:
FV differences (increase or decrease underlying assets)
Goodwill (goes to BS and gets amortized over years)
Bargain (goes to RE)
Differential gets adjust to zero by one of the following:
Cost or Market Method Investor acquires < 20% of investee's voting stock (insignificant influence)
|
---|
Equity Method Investor acquires 20% – 50% of investee's voting stock (significant influence)
|
---|
Consolidation Method Investor acquires > 50% of investee's voting stock (legal control).
|
---|
Subscribe to:
Posts (Atom)