Oracle General Ledger Rel.11i

Oracle General Ledger Rel.11i Presenter：電算中心羅元佳 chia@it.shu.edu.tw

料品管理,產品結構,生產製程,客戶,供應商,品保料品管理,產品結構,生產製程,客戶,供應商,品保固定資產管理要徑產能模擬 RCCP 請購作業採購作業收料作業應付帳款立帳付款作業銷售預測 FCST 主需求排程 MDS 物料需求計劃 MRP 總帳系統細部產能模擬 CRP 主生產排程 MPS 成本管理統一發票管理票據管理生產發料客戶訂單供應鍊管理最佳化排程生產指示 Discrete Repetitive Flow Project Process 生產入庫生產控制製程移轉應收帳款立帳收款作業出貨作業彈性企業組織架構彈性管理法則管理決策支援 EDI/XML 開放界面

Outline • General Ledger Overview • Set of Books • Journals • Oracle JInitiator • Practice Overview • Creating a Set of Books • Creating Journal Batches

General ledger overview [ 買進 ] [ 賣出 ]

General ledger overview [ 月底 ] [ 賺錢 ] 收入 > = < 支出

General ledger overview • 買一個麵包機500元 • 買一輛車10000元 • 買一個果汁機600元 • 賣給客人一杯果汁40元 • 賣給客人一個麵包30元 • 賣給客人一個火腿30元

General ledger overview 買:500+10000+600=11100元賣:40+30+30=100元 11100-100=11000元收入:100 支出:11100 虧損:11000元

General ledger overview • 機械設備 • 餐飲設備 • 冷藏設備 • 文書設備 • 家具設備 • 餐飲家具 • 衛生家具 • 作息家具

General ledger overview [買入麵包機] 會計科目借方貸方機械餐飲設備1367 500 現金 2124500

General ledger overview [ Record] [ Transactions] [ Analyze] [ Oracle GL] [ Financial Reports]

Account Debit Credit 1367 100 NT 機械餐飲設備 2124 100 NT 現金 General ledger overview [ Journal ] $ 500 NT Date:92/3/1 No.01 [ Set of Books] Date No Account Debit Credit 92/04/01 01 機械餐飲設備 100 NT 92/04/01 01 現金 100 NT 92/04/01 02 機械電腦 500 NT 92/04/01 02 現金 500 NT 92/04/01 02 機械運輸設備 350 NT 92/04/01 03 現金350 NT

General ledger overview • 政府會計年度:1/1~12/31 損益表保留盈餘資產負債表現金流量表一月二月 ……………………

General ledger overview [ Taiwan ] [ HK ] [ America ] 公司-機械-餐飲設備 01-1367 02-1367 03-1367

Elements Required for a Set of Books [ Define a chart of accounts ] [ Define an accounting calendar ] [ Define currencies ]

Set of Books

Defining Chart of Account Flexfild Security Rules Cross-Validation Rules

Defining Accounting Calendar • Period Type • Accounting Calendar • Open/Close period • Never opened • Future Enterable • Open • Closed • Permanently

Defining Currencies • New currencies • Conversion Rate Type • Daily Conversion Rate

Defining a Set of Books • Assign a Chart of Account • Assign a Calendar • Assign a functional currency

Defining a Set of Books

Journal Batch Journal Header Line Journal Entry Journal • Journal Components

Grouping Journals into Batches You can organize journal entries with common attributes into batches.E.g • Journal Type • Journal Date

Journal Batch Information • Batch Name (optionally defaults) • Batch Period (defaults to latest open) • Batch Control Total and Description (optional)

Journal Entry Header Information • Journal Name • Journal Category • Change Document Number • Change Currency • Reversal Period • Journal Control Total and Description

Journal Entry Line Information • Account • Line Debit or Credit • Statistical Values and Description

Oralce JInitiator • JInitiator is an Oracle implementation of Sun’s JavaSoft Plug-in for Solaris. It is used for connectivity between a Windows based client and Oracle Application Forms.

Oracle General Ledger Rel.11i