Enterprise Financial Management System Design and Implementation

[Abstract] for large enterprise groups, the status of Financial Management is very important. According to B / S structure, requirements, combined with the industry's existing hardware and software products and software Development tools, detailing the Financial Management Information system design and design.

[Keywords:] finance; Information system; B / S

I. Introduction

With the Financial Management of the Development of China's market economy in the management of various enterprises play an increasingly important role in the core gradually played an irreplaceable role. For large enterprise groups, the more important Financial Management, Financial Management System will be directly affected by the management of enterprise groups, and directly affect the management efficiency and Economic benefits. how to choose the best under the current operating environment of financial management, using best financial management system, enterprise management objectives to meet the Development needs of enterprise Information is a problem worthy of study and discussion.


Second, analysis of enterprise financial management system requirements

Enterprise network using established public enterprise financial systems, budgeting, charging policy basis, standards and scope, providing access to business and customer revenue and expenditure, provide the workers with wages, subsidy payments, tax withholding and so on. Employees can log on after the adoption of authentication systems, quickly and easily check the required financial Information. financial officers do not have to hand-write receipts, receipts by printing to achieve completion of the process of writing to reduce the workload and improve the professional level. financial officers at any time out to provide Information so that users can check the website at any time to the required financial information. while making financial officers also provide the basis for the leadership to improve enterprise management level, control production costs, and standardize management processes, and enhance response to market changes capacity.


Third, the enterprise financial management system

(A) of the design principles
Enterprise management mode to be selected should be in the overall Development strategy, business case, business type and subsidiaries based on systems analysis, while enterprises should be fully designed according to their own Development needs of financial management. Design should follow the following principles must be :
1. Safety
Security is divided into internal security systems, access security and docking with other security systems. Internal security embodied in the system database for data security, and shielding illegal, through the firewall, by network segment to prevent the destruction of illegal procedure on the database, to plan a database, backup, verification of data entry, the contents of the tips does not meet the conditions change, the data mask illegal. access security is reflected in the various departments, each user's security policy by management to group management, control access to each group, and information flow. connected with other systems, it is necessary to ensure the security of internal data, external information channels in isolation, but also to external information resource for access control. In order to ensure the normal operation of the whole system is bound system information to ensure the absolute safety and reliability.

2. Practicability
Financial information management system is an engineering project, not Research or experimental subjects. The system is to serve the ultimate goal of building the financial management needs and service companies to the extent permitted on the financial information needs. System construction should be application services. Therefore, the system design and construction should be able to meet the needs and run correctly and efficiently.

3. Flexibility
System should be designed with any combination of fuzzy query function, provides a wide range of queries to meet various periods of the report. Of complex data structures to be achieved modify a table of data to automatically amend the relevant data in the table, delete data in a table that automatically delete the data associated with other tables, to ensure that no redundant data in the database.

(B) the comparison and selection of technology system
The late 20th century, early 90 80's traditional client / server (C / S) structure is still the application of mainstream technology used in the system. With the large-scale application systems and user requirements on system performance continues to improve, The traditional two-tier C / S structure of the inherent flaws and shortcomings become increasingly obvious: such as system maintenance difficulties, lack of security, overload and other clients. Therefore, in the design, development system should be used for the current industry's latest technology - browser / server (B / S) structure.

B / S model and the traditional C / S model has the following advantages compared to:
1. B / S is a thin client mode
C / S model often requires the client to run large applications, therefore, the client is "fat"; in B / S mode, the client is "thin", it simply run the operating system and Web browser, by the server performs data processing, query and presentation. B / S is a thin client model, just install the browser client software, application interface, a single, lower client hardware requirements, PC, can be relatively inexpensive alternative.

2. Easy to manage and maintain
Due to the client browser interface style single, which will help improve efficiency, and in the C / S mode, the operator must be familiar with different interfaces, understanding the intent of the programmer, this should be a great deal of operator training; and B / S Just upgrade the version of centrally maintained on the server side code. This kind of Server as the central management significantly reduces costs, reduced maintenance as Client-side burden, and benefit managers, developers will focus on a reasonable the structure of organizational information systems to better provide technical support to the business up.

3. B / S mode only requires a client software
C / S mode must be used according to the client operating system and access to back the application, the installation of different software; and B / S mode, only a client software, Web browser, everything can be completed without the development client software and browser software can be downloaded for free, free upgrade.

4. Development of B / S applications, high efficiency, short, quick
B / S mode on the developer's technical requirements are relatively low. The C / S application development model to be a high level of expertise, and in the Client side and Server-side development and application needs. Because of its complex structure, on the Client side and Server-side application logic is difficult to separate classified version and to continuously update and application maintenance.

(C) Development Platform
According to B / S structure, requirements, combined with the industry's existing hardware and software products and software development tools, on the basis of comprehensive consideration of cost performance, I selected Microsoft Corporation's SQL Server database as the database application service platform system operation; options High-configured PC running Windows 2000 Server operating system; using Gigabit Ethernet as the system is running the network platform. development tools, the main advantage of Microsoft's Visual Studio. Net, using C # language, with ASP.NET, JavaScript, Vb Script, etc. technology to complete the system development.

(D) of the specific design
1. The overall structure of the system
User needs analysis, process analysis based on corporate finance work, based on the principle of division of the module, the system is abstracted as five modules, namely, system management, financial accounting, comprehensive information, the end financial statements, financial indicators. The overall framework of system functions shown in Figure 1.


System overview of each subsystem module functions described as follows:
(1) system management subsystem. First, set the user basic information: including setting account name, user permissions password, name and other basic information about the construction unit. Second, the custom details of subjects: the user according to the needs of specific business units to set their own Details subject. Third, enter the bank account number: Enter or modify infrastructure financing and bank accounts. Fourth, enter the initial balance: new user input at the beginning of accounting data. Fifth, the clean-up data: clear all or some of the data.

(2) financial accounting. First, set the project code: additions and deletions according to the current projects and investment plans for the new project set encoding. Second, set the Incoming unit code: models for the new unit set between coding. Third, a chronological account that month: the month at the beginning of a new accounting, the establishment of a new chronological account table. Fourth, the input / modify the accounting documents: will have been filled in and completed vouchers to the Audit entry or modification. Fifth, the month chronological account print: Print the month chronological account, easy to handle verification of troubleshooting.

(3) comprehensive inquiry. To provide daily accounting services required for various types of queries, such as current models inquiries, general ledger information, and a breakdown of inquiry. Query is frequently used financial management functions, the module provides users with the following query methods: first by document number query. that inquiries by the exact document number, document number entered by the user, the call up this document. The second is query by period. According to the accounting date of the beginning and end user input output query results. III is based on project code information. user input project code, adjustable out of the required data of the project. Fourth, query by unit code. Fifth, by subject query. VI is a custom query. user queries according to their need to combine conditions for the realization of special queries.

Links to Research Papers Download http://www.hi138.com (4) at the end of the financial accounts. To receive and aggregate daily accounting data entry to add the non-accounting data outside the system to generate for the department's annual report the complete set of financial accounts statements, the provision of annual accounts queries and print reports.

(5) Financial Performance. Can be of various financial indicators. Will cure the formula of the indicators in the system, the indicators used for analysis of data from the year-end financial accounts module. The financial accounts of the data can be applied to the calculation formula the results, output to screen or printer.

2. Database Design
(1) data ER diagram. ER diagram by the entities, entity attributes and links between entities formed. According to service data flow, and with reference to relevant information, after processing, to design the ER diagram of the system, as shown in Figure 2 instructions.


(2) the main data dictionary description. Data dictionary is a data flow diagram in the system, based on the data flow for each of them, documents and data items to be defined, is a data flow diagram accurate description of each component. System Data Dictionary defines all the data, that describe the structure of all databases, providing a centralized data description of the database management tools.

3. Main Module
Due to space limitations, the paper selected financial management system, several modules in the core modules - accounting module, described the design process.

(1) Set the project code. To achieve set, enter the project code, while the construction project information input function. For the convenience of users of the project code, design and coding display has a list of the project view. Users can intuitive to learn the location of the currently used numbers to determine the serial number new projects. user input sequence number, the system real-time mandatory verification, if found that the sequence number is in use, will issue an error message and refused to receiving data. project sub-category classification code and identification number is relatively stable, so they solidified in the system will, in the entry provided to the user when the selection operation, thus reducing the workload of keyboard input and increase accuracy.

Information includes an overview of the project: The planned total investment, investment plans this year, plans to invest before the median not yet reached the construction area and the start date of the information these profiles is that the project financial accounting of the important properties, related to output and the end of the financial statements accounts, etc.. system design projects in the set, while the input profile information encoded and stored in 'item code' database base table, the file name: JXMK.DBF. This is to simplify the system, steps to reduce the number of documents, and convenient query, to save disk space and improve the speed of the dual purpose.

(2) the establishment of a chronological account. To establish a chronological account that at the beginning of entry vouchers on the hard disk before the system established under the specified directory empty tables of a database for storing all of the year from January to December vouchers. Accounting occurred by business certificate stored in the table in chronological order, you can say it is a full accounting of the basic data record table, the system automatically transfers the data source and a series of processing. file structure of the data items constitute vouchers all the elements, as shown in Table 1.


(3) input / modify vouchers. Design and implementation of the system input / modify vouchers function, to follow the following principles: First, each data item based on the certificate type, scope for effective control. For example, accounting entries accounts in the chart of accounts must be set already exists and is the bottom of the details of subjects; subjects properties based on the current input to determine whether certain items at the same time, such as projects, exchanges money unit, the borrower number, etc.; borrower must be equal to the amount saved; document number can be automatically continuous; date to limit the order and so on. Second, compared to manual processing of the "clerical error", the keypad is more prone to "misuse" and therefore "entry certificate" in the operating functions should be divided as "input", "Modify", "delete" and other steps to carry out the correctness of control. Third, the "audit" the completed certificate, the system re-examination in the program review the correctness of the certificate.

Conclusion: This paper describes the financial management information system design concept and design, from the construction unit of the characteristics and development trend of information technology, combined with practical work, developed for the actual situation of the financial department of management information systems. From the system applications results, the results of this Research is effective and practical, the basic infrastructure to the norms of financial business processes, improve financial sector management purposes.


[Main references]
[1] Wang Weijing. Financial Management of the company [J]. Introduction and consultation, 2008, (12) :52-53.

[2] Wang Aijun. On the company's financial control [J]. China's collective economy, 2004, (6) :14-16.

[3] Teng Europe. On corporate Some Problems of Financial Management [J]. Hunan Economic Management College, 2004, (5) :49-50.

Links to Research Papers Download http://www.hi138.com