1 / 28

Oracle General Ledger 會計總帳

Oracle General Ledger 會計總帳. Outline. Overview Set of books Journals. Oracle ERP Overview. 付款作業 payment. 會 計 總 帳 GL. 會 計 總 帳 GL. 粗略產能規劃 RCCP. 採購訂單 PO. 收料作業 receive. 銷售預測 FCST. 採購需求 PR. 應付帳款 AP. 主需求排程 MDS. 主生產排程 MPS. 物料需求規劃 MRP. 倉儲管理 inventory. 發料作業 issue.

jason-forbes
Télécharger la présentation

Oracle General Ledger 會計總帳

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle General Ledger會計總帳

  2. Outline • Overview • Set of books • Journals

  3. Oracle ERP Overview 付款作業 payment 會 計 總 帳 GL 會 計 總 帳 GL 粗略產能規劃 RCCP 採購訂單 PO 收料作業 receive 銷售預測 FCST 採購需求 PR 應付帳款 AP 主需求排程 MDS 主生產排程 MPS 物料需求規劃 MRP 倉儲管理 inventory 發料作業 issue 顧客訂單 orders 生產排程 schedule 在製品管理 WIP 收款作業 receipt 產能需求規劃 CRP 出貨作業 shipping 應收帳款 AR

  4. GL相關作業流程 外幣重估 Oracle其他系統轉入 重新評價 人工輸入 合併報表 開啟會計期間 開放介面轉入 迴轉分錄 定義企業作業模式 分錄/傳票登錄 科目調整作業 結帳 預算作業 會計科目結構 建立預算 資訊擷取模式 多幣別作業 核准 多公司合併作業 報表產生器 修訂.整理預算資料 查詢 行事曆 過帳 資料群模式化 報表需求分析 分派/收集預算資料 明細帳反查稽核

  5. Outline • Overview • Set of books • Journals

  6. Set of books • 交易事項： • 3月1日公司成立收取股款1,000,000元 • 3月2日向銀行借入100,000元 • 3月3日購入機器設備一台，價值400,000元

  7. Define a chart of accounts Define an accounting calendar Define currencies Elements Required for a Set of Books

  8. Set of Books

  9. Defining Chart of Account Application Flexfield Security Rules Cross-Validation Rules Accounting Accounting Flexfield Flexfield Segment Segment Segment Segment Value Set Value Set Value Set Value Set Value Value Value Value Value Value Value Value

  10. 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. Example : XX XXX XXXX XXXX XXX Company Department Account Sub-Account Product

  11. Value Set

  12. Defining Value Sets & Segment Values • Validation Type • Independent • Dependent • Table Value_Set 1 Value_Set 2 Value_Set 3 Format: Char Maximum size: 2 Validation: Independent Format: Number Maximum size: 3 Validation: Independent Format: Char Maximum size: 4 Validation: Independent Qualifiers Natural Account Balancing Segment Cost Center 01 02 100 101 1000 1001 Values

  13. Accounting Flexfields

  14. Segment Values

  15. 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.

  16. #’s 0000 to 9999 Include: #’s 1000 to 3999 Exclude: Defining Flexfield Security Rules • Restrict data entry and online inquiry to specific values by using flexfield security rules. Account Segment Security Rule Flexfield Security Rule: Compay00 not valid for this Responsibility

  17. 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. Security Rule Cross-Validation Rule: Department 730 can only be used with Company 01

  18. Journal & Account Scenario Combinations 01-510-7740-0000-110 02-460-7695-1300-000 . . 01-510-7750-0000-110 01-510-7740-0000-110 Journal 01-510-7750-0000-110 02-460-7695-1300-000 . . 01-510-7750-0000-110 01-510-7740-0000-110 Not Found ：ERROR Found ：OK Not Found ：CREATE Found ：OK Not Allow Dynamic Insertion Allow Dynamic Insertion

  19. 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

  20. Accounting Calendar • Accounting period 5 statuses Future Enterable Never Opened Permanently Closed Period Closed Period Open Period

  21. 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

  22. Shorthand Alias Account Combination 01-110-000-1110-000-0000 -320- - - - 01 - -420-4110- - - - - -310- 01-320-420-4110-310-0000 Cash01 NY Sales Computer Monitors NY Monitor Sales = Defining Shorthand Aliases • A simple code that represents a partial or complete account combination. • Reduce account-entry keystrokes • Maximize productivity and accuracy.

  23. Outline • Overview • Set of books • Journals

  24. Basic Journal Entry Reversing Journal Entry Recurring Entries Journal Entry Types Mass Allocations

  25. Journal Creation Methods • Manual Entry • Reversals • Recurring • MassAllocations Journal Import Journal Wizard

  26. Enter journal Posting Journals • Update balances by posting journals. • Un-post Journal • Control total violations • Posting to unopened periods • Unbalanced journal entries Account Balance Prepost $500 Journal 25 After post $525 Post journal

  27. Reviewing and Correcting Balances Enter and post journals Review balances No Are the account balances correct? Yes End

  28. Oracle General Ledger會計總帳 完 2008/07

More Related