GL2006.ppt

Oracle General Ledger會計總帳 Outline Overview Set of books Journals Oracle ERP Overview Outline Overview Set of books Journals Elements Required for a Set of Books Set of Books Defining Chart of Account Creating Accounting Flexfields Perform the five steps necessary to create an Accounting Flexfield. 1. Define a value set. 2. Define an Accounting Flexfield structure. 3. Define valid segment values. 4. Optionally, create account combinations. 5. Define security rules. Defining Value Sets Segment Values Validation Type Independent Dependent Table Accounting Flexfields Segements Value Set Segment Values Using Dynamic Insertion Dynamically create new account combinations. Dynamic insertion can be enabled or disabled at any time. All new combinations must satisfy all defined cross-validation rules before they are accepted. Defining Flexfield Security Rules Restrict data entry and online inquiry to specific values by using flexfield security rules. Defining Cross-Validation Rules Prohibit creation of invalid account combinations using cross-validation rules. Use cross-validation rules in combination with dynamic insertion. Define cross-validation rules before entering a chart of accounts. Journal Account Scenario Defining the Accounting Calendar Create a calendar to define an accounting year and the periods that it contains. Periods Period Type Calendar Fiscal Period Open/Close Accounting Calendar Defining Currencies Create New Currencies Predefined Daily Conversion Rate Type Spot Corporate User European Monetary Union (EMU) Fixed Custom Rate Type Defining Daily Rates between any two non-EMU currencies Currencies Defining Shorthand Aliases A simple code that represents a partial or complete account combination. Reduce account-entry keystrokes Maximize productivity and accuracy. Outline Overview Set of books Journals Journal Entry Types Journal Creation Methods Journal Accounting Calendar Accounting period 5 statuses Accounting period 5 statuses Posting Jour