【正文】 本科畢業(yè)設(shè)計(jì)（論文） 題 目： ERP 之財(cái)務(wù)管理系統(tǒng) Financial Management System of Enterprise Resource Planning 學(xué) 院： 信息科技學(xué)院 專 業(yè)： 計(jì)算機(jī)科學(xué)與技術(shù) 學(xué) 號(hào)： 學(xué)生姓名： 指導(dǎo)教師： 職 稱： 摘 要 近年來(lái)，隨著我國(guó)信息技術(shù)的飛速發(fā)展，計(jì)算機(jī)應(yīng)用已逐漸滲透到各個(gè)領(lǐng)域。在企業(yè)管理領(lǐng)域內(nèi)，計(jì)算機(jī)的應(yīng)用已經(jīng)十分廣泛，各種管理機(jī)制與企業(yè)運(yùn)作流程都與計(jì)算機(jī)緊密結(jié)合在一起，計(jì)算機(jī)的應(yīng)用進(jìn)一步完善了企業(yè)的管理，提高了企業(yè)的現(xiàn)代化管理形象。 ERP 之財(cái)務(wù) 管理系統(tǒng) 是適應(yīng)現(xiàn)代企業(yè)制度要求、推動(dòng)企業(yè)財(cái)務(wù)管理走向科學(xué)化、規(guī)范化的必要條件， 為 企業(yè) 建立起信息高速公路，促使 企業(yè) 逐步形成方便、科學(xué)、合理的管理模式。 ERP 之財(cái)務(wù)管理系統(tǒng)屬于企業(yè)資源計(jì)劃模塊之一，同時(shí)它也是企業(yè)管理系統(tǒng)中非常重要 的一部分，該系統(tǒng)通過(guò)對(duì)財(cái)務(wù)信息進(jìn)行數(shù)字化管理， 加快信息 處理 速度 ，提高管理效率，從而促進(jìn)企業(yè)的發(fā)展。 本系統(tǒng)是利用 PowerBuilder 數(shù)據(jù)庫(kù)技術(shù)并結(jié)合中國(guó)企業(yè)管理制度而建立起來(lái)的一個(gè)信息系統(tǒng)，主要包括應(yīng)收管理、應(yīng)付管理、資金管理和總帳管理等模塊，實(shí)現(xiàn)了個(gè)模塊的錄入、查找和生成報(bào)表等功能。 關(guān)鍵字： 財(cái)務(wù)管理系統(tǒng)， PowerBuilder ， ERP—— 企業(yè)資源計(jì)劃 Abstract In recent years, the application of puter gradually seeped to each domain along with the rapid development of the information technology of our country. In the business management domain, the application of puter already widespread extremely, Each kind of management mechanism and enterprise operation flow all with puter in close integration with in together, the application of puter further consummated enterprise39。s management and enhanced the image of enterprise39。s modern management. Financial management system of ERP adapts the modern enterprise system request, the essential condition of impelling enterprise financial control moves towards scientific and standardized， it establishes the information superhighway for the enterprise, urges the enterprise to form conveniently, scientific and the reasonable management pattern gradually. Financial management system the ERP belongs to one of the enterprise resources plan modules. At the same time it is also one of the extremely important part of the business management system. This system uses the digitized management to deal with the financial information, accordingly, speeds up the information processing speed, enhances the management efficiency and promotes the development of the enterprise. This is an information system that established by using the PowerBuilder data bank technologies and unifies the China business management system, Mainly management, cost accounting, fund management and general ledger management module and so on. It includes the receivable of management, deal of management, realized the function of inputting module, search and production report form, etc. Key Words: Financial Management System, PowerBuilder ， ERP —— Enterprise Resources Planning南京林業(yè)大學(xué)本科畢業(yè)設(shè)計(jì) —— ERP 之財(cái)務(wù)管理系統(tǒng) 目 錄 前 言 .............................................................. 1 第一章 ERP（企業(yè)資源計(jì)劃）原理 ......................................... 2 ERP理論的形成 ...................................................... 2 基本 MRP ...................................................... 2 閉環(huán) MRP ...................................................... 2 制造資源計(jì)劃（ MEPII） ........................................ 2 企業(yè)資源計(jì)劃 (Enterprise Resource Planning ERP) ............... 2 ERP基本模塊 ........................................................ 3 制造管理部分 .................................................. 3 財(cái)務(wù)管理部分 .................................................. 3 人力資源管理部分 .............................................. 3 第二章 開(kāi)發(fā)工具簡(jiǎn)介 ................................................... 4 PowerBuilder 簡(jiǎn)介 ............................................... 4 的特點(diǎn) .............................................. 4 專業(yè)的客戶 /服務(wù)器開(kāi)發(fā)工具 ..................................... 4 面向?qū)ο蟮木幊? ................................................ 4 支持多種關(guān)系數(shù)據(jù)庫(kù)管理系統(tǒng) .................................... 5 豐富的數(shù)據(jù)表現(xiàn)風(fēng)格 ............................................ 5 靈活快捷的數(shù)據(jù)轉(zhuǎn)移方法 ........................................ 5 功能強(qiáng)大的調(diào)試器和多種調(diào)試方式 ................................ 6 PowerBuilder 的事務(wù)對(duì)象 ............................................. 6 用數(shù)據(jù)庫(kù)的事務(wù)管理指令實(shí)現(xiàn)完全控制 ............................ 6 PowerBuilder 中的事務(wù)管理 .................................... 6 創(chuàng)建與刪除自定義的事務(wù)對(duì)象 .................................... 8 第三章 系統(tǒng)分析 ...................................................... 9 系統(tǒng)目標(biāo) ........................................................... 9 系統(tǒng)需求分析 ....................................................... 9 開(kāi)發(fā)設(shè)計(jì)思想 ...................................................... 10 系統(tǒng)開(kāi)發(fā)運(yùn)行環(huán)境設(shè)置 ............................................... 10 第四 章 系統(tǒng)設(shè)計(jì) ..................................................... 11 系統(tǒng)功能結(jié)構(gòu)設(shè)計(jì) ................................................... 11 ................................................... 13 數(shù)據(jù)庫(kù)需求分析 ............................................... 13 數(shù)據(jù)庫(kù)設(shè)計(jì) ................................................... 14 數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì)與實(shí)現(xiàn) ..................................... 14 數(shù)據(jù)庫(kù)的連接 ................................................. 18 第五章 關(guān)鍵模塊及代碼設(shè)計(jì) ............................................. 20 應(yīng)用程序?qū)ο笤O(shè)計(jì) ................................................... 20 登陸界面設(shè)計(jì) ...................................................... 20 主界面設(shè)計(jì) ........................................................ 21 系統(tǒng)管理界面設(shè)計(jì) ................................................... 22 參數(shù)設(shè)置界面設(shè)計(jì) ................................................... 23 南京林業(yè)大學(xué)本科畢業(yè)設(shè)計(jì) —— ERP 之財(cái)務(wù)管理系統(tǒng) 科目設(shè)置界面設(shè)置 ............................................. 23 會(huì)計(jì)期間設(shè)置界面設(shè)置 ......................................... 25 兌換率設(shè)置界面設(shè)置 ........................................... 25 應(yīng)收管理子系統(tǒng)界面設(shè)計(jì) ............................................. 25 應(yīng)收結(jié)帳單管理界面設(shè)置 ....................................... 26 應(yīng)收結(jié)帳單查找界面設(shè)置 ....................................... 26 應(yīng)收結(jié)帳單報(bào)表界面設(shè)置 ....................................... 28 收款單管理界面設(shè)置 ........................................... 28 收款單查找界面設(shè)置 ........................................... 2