台湾大学 OracleGeneralLedgerRel.11i for foundation.ppt

Oracle General Ledger Rel.11i Presenter：電算中心 羅元佳 chia@it.shu.edu.tw 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 現金 2124 500 General ledger overview General ledger overview General ledger overview 政府會計年度:1/1~12/31 General ledger overview Elements Required for a Set of Books Set of Books Defining Chart of Account 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 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. * * 總帳系統 客戶訂單 主生產排程 MPS 要徑產能 模擬 RCCP 物料需求 計劃 MRP 請購作業 採購