Oracle总帐管理系统讲解

1、Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.分析分析处理处理 记录记录复核复核Copyright Oracle Corporation, 1999. All rights reserved.Cop

2、yright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corpor

3、ation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rig

4、hts reserved.纽约纽约巴黎巴黎芝加哥芝加哥CPU硬盘硬盘打印机打印机Copyright Oracle Corporation, 1999. All rights reserved.内华达内华达俄勒冈俄勒冈加利福尼亚加利福尼亚Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Orac

5、le Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999

6、. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserve

7、d.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved. 输入日记帐输入日记帐过帐前过帐前

8、$500日记帐日记帐 2525过帐后过帐后 $525$525帐户余额Copyright Oracle Corporation, 1999. All rights reserved.Dr. 租金租金. 1. 10,000 本位美元本位美元Cr.现金现金 10,000 本位美元本位美元创建冲销帐创建冲销帐Dr. 现金现金 10,000 本位美元本位美元Cr. 租金租金 1010,000 本位美元本位美元Copyright Oracle Corporation, 1999. All rights reserved.结束结束输入和过帐日记帐输入和过帐日记帐复核余额复核余额否否是是 帐户余额正确吗？帐户

9、余额正确吗？Copyright Oracle Corporation, 1999. All rights reserved.帐户查询帐户查询子分类帐明细子分类帐明细细查细查Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Dr.临时劳务支出临时劳务支出 Cr.应付薪金应付薪金 Dr.租车费用租车费用 Cr.应付帐

10、户应付帐户 Dr.租用费租用费 Cr.应付租金应付租金 Copyright Oracle Corporation, 1999. All rights reserved.1/31/31/3Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All

11、 rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.- - 来源来源- - 币种币种- - 日期日期- - 类别类别- - 日记帐名称日记帐名称- - 帐套帐套Copyright Oracle Corporation, 1999. All rights reserved.多个多个Copyright Oracle Corporation, 1999. All rights reserved.G

12、L_INTERFACEGL_INTERFACE 表表加载到接口加载到接口Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All

13、rights reserved.第第 1 1 步：定义预算和预算组织。步：定义预算和预算组织。第第 2 2 步：输入预算金额。步：输入预算金额。第第 3 3 步：复核和更正预算。步：复核和更正预算。第第 4 4 步：冻结预算。步：冻结预算。第第 5 5 步：做预算报表。步：做预算报表。Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.名称：名称：FY96PLANFY96PLANCC100 ?. $3000CC200 ?.

14、$15001994 1994 年年 1 1 月至月至 1994 1994 年年 12 12 月月Copyright Oracle Corporation, 1999. All rights reserved.总：无总：无市场预算市场预算总：公司总：公司销售预算销售预算总：公司总：公司西部预算西部预算总：销售总：销售东部预算东部预算总：销售总：销售公关预算公关预算总：市场总：市场商品展览预算商品展览预算总：市场总：市场Copyright Oracle Corporation, 1999. All rights reserved.公司预算公司预算总：无总：无市场预算市场预算总：公司总：公司销售预算

15、销售预算总：公司总：公司西部预算西部预算总：销售总：销售东部预算东部预算总：销售总：销售公关预算公关预算总：市场总：市场商品展览预算商品展览预算总：市场总：市场Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reser

16、ved.Copyright Oracle Corporation, 1999. All rights reserved.2. 2. 定义栏集。定义栏集。4. 4. 请求财务报表和报表集。请求财务报表和报表集。Copyright Oracle Corporation, 1999. All rights reserved. 损益报表损益报表 公司公司 1 1销售销售退货退货净销售净销售PTDPTDYTDYTD3,0003,0006,2006,2001,0001,0001,0001,0002,0002,0005,2005,200 资产负债表资产负债表 公司公司 1 1现金现金投资投资应收款应收款 本

17、年度本年度 上一年度上一年度 100100 200 200 600 600 400 400 980 980 700 700Copyright Oracle Corporation, 1999. All rights reserved.+-*/%MODEENTERAVERAGESTDDEVMEDIAN加加乘乘百分比百分比列出的值列出的值的模式的模式列出的值列出的值的中间值的中间值减减除除输入值输入值列出的值列出的值的平均值的平均值列出的值列出的值的标准偏差的标准偏差Copyright Oracle Corporation, 1999. All rights reserved.Copyright

18、Oracle Corporation, 1999. All rights reserved.损益报表损益报表 公司公司 1 1销售销售退货退货净销售净销售PTDYTD3,0006,2001,0001,0002,0005,200 资产负债表资产负债表 公司公司 1 1现金现金投资投资应收款应收款 本年度本年度 上一年度上一年度 100100 200 200 600 600 400 400 980 980 700 700Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999

19、. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved. 明细级别明细级别 = = 财务总监财务总监 明细级别明细级别 = = 主主 管管Copyright Oracle Corporation, 1999. All rights reserved.损益报表损益报表 公司公司 1 1销售销售退货退货净销售净销售 本年度本年度 上一年度上一年度 100100 200 200 600 60

20、0 400 400 980 980 700 700 资产负债表资产负债表 公司公司 1 1现金现金投资投资应收款应收款PTDYTD3,0006,2001,0001,0002,0005,200栏集栏集 B BCopyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation,

21、 1999. All rights reserved. 下限下限上限上限显示显示公司公司 01 0101 01T T成本中心成本中心 100 400100 400E E帐户帐户4000 40004000 4000T T 销售销售 9/949/94 10/9410/94 11/9411/94 12/9412/94Fremont (200) 45,505 41,303 44,51848,697Newport (300) 48,821 47,448 48,41546,950Belmont (400) 43,340 46,296 42,54742,998United (100) 46,684 43,8

22、55 46,10344,746Copyright Oracle Corporation, 1999. All rights reserved.显示集显示集报表报表报表集报表集Copyright Oracle Corporation, 1999. All rights reserved.先计算后舍入选项先计算后舍入选项 计算为计算为 显示为显示为现金现金 1,1001,100 1 1帐户应收款帐户应收款 1,2001,200 1 1预付费用预付费用 1,3001,300 1 1当前资产合计当前资产合计 3,7003,700 4 4先舍入后计算选项先舍入后计算选项 计算为计算为 显示为显示为现金现

23、金 1 1 1 1帐户应收款帐户应收款 1 1 1 1预付费用预付费用 1 1 1 1当前资产合计当前资产合计 3 3 3 3Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Ora

24、cle Corporation, 1999. All rights reserved.借项借项 应收帐款应收帐款 10,000 元（外币单位）元（外币单位）贷项贷项 收入收入 10,000 元（外币单位）元（外币单位）借项借项 应收帐款应收帐款 8,000 元（本位币单位）元（本位币单位）贷项贷项 收入收入 8,000 元（本位币单位）元（本位币单位）Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright O

25、racle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1

26、999. All rights reserved.外币外币本位币本位币Copyright Oracle Corporation, 1999. All rights reserved.主帐套主帐套 用主币种输入例行用主币种输入例行日记帐日记帐 过帐日记帐过帐日记帐 余额报表余额报表法郎法郎欧元欧元多报表帐套多报表帐套比利时法郎比利时法郎 过帐日记帐过帐日记帐 余额报表余额报表Copyright Oracle Corporation, 1999. All rights reserved.GL_BALANCES TABLECC_IDCURRENCYPERIOD_NET_DRPERIOD_NET_CR

27、PERIOD_NET_DR_BEQPERIOD_NET_CR_BEQ41357FOREIGN10,0008,00039872FOREIGN10,0008,00041357FUNCTIONAL 8,00039872FUNCTIONAL 8,000注：注：BEQ 指等值（本位币）基准额。指等值（本位币）基准额。Copyright Oracle Corporation, 1999. All rights reserved.期间汇率列表期间汇率列表列出为各个会计期定义的汇率，期间平均汇率、期末汇率列出为各个会计期定义的汇率，期间平均汇率、期末汇率和重估汇率。该信息也可通过联机方式获得。和重估汇率。该信

28、息也可通过联机方式获得。外币列表外币列表名称名称说明说明每日折换率列表每日折换率列表列出为一特定外币和会计期定义的每日折换率。该信息也列出为一特定外币和会计期定义的每日折换率。该信息也可通过联机方式获得。可通过联机方式获得。历史汇率列表历史汇率列表列出所定义的历史折算率和金额。该信息也可通过联机方列出所定义的历史折算率和金额。该信息也可通过联机方式获得。式获得。Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyri

29、ght Oracle Corporation, 1999. All rights reserved.重估外币余额。重估外币余额。冲销重估日记帐。冲销重估日记帐。是否外币应收款是否外币应收款尚未支付？尚未支付？收取外币应收款。收取外币应收款。Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved. 折算的实际金额折算的实

30、际金额 折算的预算金额折算的预算金额 实际余额实际余额 预算余额预算余额本位币本位币美元美元欧元欧元Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.帐户类型帐户类型折算规则折算规则收入和费用收入和费用期初至今期初至今 (PTD) 规则规则PTD (xlt) = 汇率汇率 x PTD (func)资产和负债资产和

31、负债年初至今年初至今 (YTD) 规则规则YTD (xlt) = 汇率汇率 X YTD (func)Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.子帐套子帐套 1： 公司公司 A 公司公司 B子帐套子帐套 2： 公司公司 C子帐套子帐套 3： 公司公司 D 公司公司 E 公司公司 F父帐套：父帐套： 公司公司

32、 A 公司公司 B 公司公司 C 公司公司 D 公司公司 E 公司公司 FCopyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.Copyright Oracle Corporation, 1999. All rights reserved.1 11 12 2Subsidia