Tuesday, January 25, 2011

GL Topices

Journal source and categories

Journal source and categories is used to differentiate journal entries and to enhance your audit trail.

Journal entry source indicates where your journal entries originate

Journal categories help you differentiate entries by purchase or type.

Examples for Sources:
Assets
Purchasing
Payables
Manual
Budget …...Etc.
Examples For Categories:
Accruals
Adjustment
Receipts
Revaluation
Payments..Etc..

Oracle applications provided required source and categories with default. But you can define with your sauce and categories by using the following navigation:
GL:Setup->Journal->Source
Setup->journal-.Categories

With Journal Source you can:

Define inter company and suspense accounts for specific sources.
Run auto post program for specific source
Import journals by source
Freeze journals imported from sub ledgers to prevent users from making changes.
If you have journal approval enabled for your set of books, you can use journal source to enforce management approval of journal before they are posted.

With Journal Categories you can:

Define inter company and suspense accounts for specific category.
Use document sequence to sequentially number journals by categories.

Use Of Automatic Offset Method In Payable Options

If you enter an invoice for expenses or asset purchases for more than one balancing segment, you might want to use automatic offset method to keep your payables transaction accounting entries balanced.
If we enable balancing as a automatic offset, payable builds the offset GL account by taking the balancing segment value from the invoice distribution and overlaying it on to the appropriate GL account, i.e liability account from the supplier site.
If we enable account as automatic offset, it takes the opposite approach with one segment being retained from the default GL account and all other segments being retained from the invoice distribution
Secondary Tracking Segment is a Flex field qualified added in the 11.5.10 release. The secondary tracking segment is used in the revaluation, translation, and fiscal year-end close processes. The system will automatically maintain unrealized gain/loss, retained earnings, and cumulative translation adjustments by unique pairs of balancing segment and secondary tracking segment values. you can assign Secondary tracking segment flex field qualifier to an segment which haven’t assigned Natural account, balensing Segment and inter company.

No comments:

Post a Comment