Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Tuesday, June 21, 2011

General Ledger in Oracle

Revaluation -
To bring up the current assets and liabilities at the current exchange rate as on the date on which you run the revaluation.

This has to be run before you report your TB to appropriate authorities.

Eg.
AP Invoice - Entry - 24-Dec-09 Rate USD/AUD = 0.8
AUD (entered) USD (Functional)
Expnses A/C (Dr.) 10,000 8,000
To Liability (Cr.) 10,000 8,000

On 31-Dec-09, prepare your TB - Rate USD/AUD = 0.9
Revaluation Process-

AUD (entered) USD (Functional)
Revaluation Profit/Loss A/C (Dr.) 0 1,000
To Liability (Cr.) 0 1,000

Liability balance on 31-Dec-09 is 9,000 USD

Reversed on 01-Apr-09

On 30-Dec-09, paid the invoice Rate USD/AUD = 0.9
AUD (entered) USD (Functional)
Liability A/c (Dr.) 10,000 8,000
Exchange Profit/Loss A/C (Dr.) 0 1,000
Cash/Bank (Cr.) 10,000 9,000

Translation -
Translation is converting your balances (trial balance) from one currency to another.

1st step - Define you Period end rates
?????

Run 'Translation'
After completiong of this

Run 'Trial Balance - Translation'

To compare the output
Run 'Trial Balance'

Daily Rate - Are used in all your transactions (AP Invoice, AR Invoice, payemnt, rcpt)
Period Rate - Transalation (Assets & Liab)
Average Rates - Transalation (Expenses & Revenue)
Historic Rates - It shows record of rates in one form

01-15 Mar 2005 - 10 -Daily Rates
16-30 MAr 2005 - 20 -Daily Rates
01-15 Mar 2005 - 15 -Avg Rates

CONSOLIDATION -
This is used for reporting many ledgers put together into one ledgers.

N > Consolidation > Define > Consolidation

Target source
ccc.account
360.1000 300 401.10000 100
403.10000 200

Elimination -
N > GL > Consilidaiton > Elimination > Define

N > GL > Consilidaiton > Elimination > Generate
Generate - This will a elimination journal in Consolidateed Ledger/SOB

Co.02 owing 10000 USd to Co.01

Individula TB for Co. 01 -
Co02.12000 10000 (Cr)

Individula TB for Co. 02 -
Co01.13000 10000 (Dr)

Final TB both these balances should be eliminated. Intercompany owings should be eliminated.

Elimination journal -
Source Targert
T-T-12000-0000-000 02----

Co.02.12000 10000 (Dr) - Elimination

Co.02.12000 10000 (Cr) - Coming TB

Transfer you data from Subsidiary to Parent Ledger-
N > GL > Consilidaiton > Transfer > Data

BUDGETING -

Budgeting is tool to control your future expenses and do the varaince analysis in future for the variation between 'Actual exp' and 'budgeted Exp'.

Define Budget -
N > GL > Budgets > Define > Budget

After defining budget, click on 'Open Next Year'

Define Budget Organization -
N > GL > Budgets > Define > Budget
After giving details, click on Ranges
The account range for which you are setting up your budget.

To enter the budget amount -
N > GL > Budget > Enter > Amount

FSG - FINANCIAL STATEMENT GENERATOR -

N > Reports > Define > Report

- FSG will diplay data only from GL
- This report works in combination of 1) Row Set and 2) Column Set

Row Set - (Balance Sheet)
Row by row you will either assign account range or calculation.
N > Reports > Define > Row Set

Column Set - (B/S-I/S-Current Month Actuals)
N > Reports > Define > Column Set

USEFUL REPORTS IN GL -

1) Trial Balance
2) Account Analysis (180 char)
3) Chart of Accounts - Detail Listing
4) Journal - Day Book
5) General Ledger (180 Char)

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect