Wednesday, June 25, 2008

GL Flow


GENERAL LEDGER
1. Creating Journal ( Batch, Header and Lines).
2. Creating Code Combination,
3. Creating Journal Source
4. Creating Journal Category
5. Understanding Accounting Period,
6. Understanding Key Flexfileds,
7. Understanding Descriptive Flexfields
8. Understanding SetUp of General Ledger
9. Understanding Account Inquiry form
10. Understanding GL Interface Program - Journal Import
11. Understanding Chart of Accounts.
12. Understanding Set of Books
Once you create a journal look for the data in below mentioned tables
Journal countains a Batch - GL_JE_BATCHES,
Header -GL_JE_HEADERS
Lines - GL_JE_LINES,
Once you create a Code Combination look for the data in GL_CODE_COMBINATIONS
Once you understand Account Inquiry Form look for the data in
GL_BALANCES
Once you create a Journal Source look for the data in
GL_JE_SOURCES
Once you create a Journal Category look for the data in GL_JE_CATEGORIES
Once you understand Accounting Period then check the data in
GL_PERIODS,
- GL_PERIOD_STATUSES,Once you understand Chart of Accounts structure then look for the data in,- GL_CHART_OF_ACCOUNTS
Once you understand Set of Books structure then look for the data in
- GL_SETS_OF_BOOKS
Once you understand GL Interface program then check tables
- GL_INTERFACE
- GL_IMPORT_REFERENCES
Go through the all the above tables again and again and be conversant about the joins.

1 comment:

Unknown said...
This comment has been removed by the author.