The localization of the ERP accounting engine ERP is an integrated information system, and the main tool integrating the ERP internal logistics module and the financial module is the accounting engine. Through the powerful accounting engine, ERP realizes the integration of financial services and the diversification of financial analysis, so explores the function of the accounting engine in ERP, the method of transformation, and the integration of the ERP internal financial module and the localization of foreign excellent ERP software, etc. Provide beneficial reference references. 1. The Connotation Engine (Accounting Engines) of the Accounting Engine in ERP is a data processor for acquisition, processing output accounting related information. It sets the parameters in the entire application system operation module based on the database language. In addition to adding, deleting, changing directories, files, fields, etc., also handles filtration, conversion, checking, correction fields and The connection between the file, the display error, etc., and actively guides the entire design process. For example, the accounting document automatically generated by the logistics process is completed via the accounting engine computation, and then transferred into other systems, and all changes to other systems are transferred to other engines, the processor allows the entire system to be updated synchronously. The accounting engine and the user are an interactive relationship and have high autonomy that protects the system from improper design. By it can establish a downstream procurement or supply system, the link, real-time reaction system, synchronous backup, etc. of each subsystem are achieved. The accounting engine can be divided into two types of financial accounting engines and management accounting engines in accordance with the accounting nature. Financial Accounting Engine Operates Financial Accounting Related Information in ERP Business Activities, which will automatically handle account, post business, and provide relevant report data for reporting systems. The management accounting engine is mainly information related to the management accounting business, recording into the database, providing data support to the appropriate management accounting system by processing analysis. The management accounting engine is often embedded in intelligent analysis tools for extracting, modifying updates, and processing data from the database, generating various reports, reports, etc. required for decision making. In-depth application of management accounting depends on a strong business intelligence analysis engine, analyzing the business status and historical operations from different management latitudes and depths, and provides accurate and timely data on future operations for future operations. information. For example, Kingdee Business Intelligent Analysis Engine provides a variety of viable applications analysis methods for different analytical objectives for customers, and different analytical objectives (including structural analysis, trend analysis, ratio analysis, sensitivity analysis, regression analysis, etc.) and powerful data. Mining, drilling analysis tools to extract basic data, used to achieve asset liability analysis, financial revenue analysis, cash flow analysis, etc. The accounting engine in the different ERP is basically the same, while the difference is more embodied in the additional function thereof. The accounting engine in ERP describes its functional characteristics by examining some key features such as supporting the flexibility of supporting business, accounting transfers, report generation, availability, and other characteristics. Second, COMPIERE ERP & CRM COMPIERE ERP & CRM is an internationally renowned OLP software that has both complete ERP basic functions, and is an open ERP system platform that provides companies with a reliable and flexible information implementation tool. After the software is open, there are tens of thousands of users around the world, and they get help from many open source software developers. This software is based on J2EE architecture, Oracle database, pure Java, has strong information integration. The accounting information generated by the business processing in this system such as the accounting of orders, the invoice accounting, etc., will automatically import the row project table in the record accounting database in the JBoss middleware, thereby completing Integrated operation of internal financial services. Since Compiere ERP & CRM is developed based on the Western management accounting system, it has a great difference between my country's existing accounting system. Therefore, in my country's enterprises, this open source software must be used, and the accounting engine of Compiere ERP & CRM must be appropriately transformed. .
The design of the Western ERP system (such as SAPR / 3 system, Compiere ERP & CRM system, etc.) is mainly for processes, focusing on the undertaking and matching relationship between the various processes; and domestic ERP design ideas mainly facing functional, paying attention to It is the implementation of the specific functional module. Therefore, in the domestic ERP, there is usually more specific cost accounting modules, cost report modules, budget management modules, etc., usually in this case, make the system uncomfortable integration, may result in repetition of the interruption and code of the process. . These are rarely embodied in the Western ERP, which integrates the contents of the management accounting into each business process, and there is no independent management accounting module. Their management accounting module is different from the ERP other modules, and does not emphasize the automation of the enterprise trading program, but only the information needed to analyze from the ERP other modules, such as the cost information it is first passed by the financial accounting module. The management accounting content involved in ERP is an important part of very dispersed and extensive, and penetrates into ERP. His hierarchical system can be simplified in Figure 2. Therefore, it is learned that the management accounting system in ERP will be beneficial to the management of accounting engines. Third, the accounting engine for transforming Compiere ERP & CRM to implement the transformation of the management accounting engine in ERP requires redefine and processing of many basic financial content, including the following aspects: (1) The rules of basic financial data The main purpose. For example, studying the design idea of Western management accounting system; understands the basic data of the basic data defines the booklets and various line project tables for the underlying financial database, and the maintenance of the maintenance of the maintenance of Western accounting and Chinese accounting; The budget sets, actual accounts, statistic accounts, and the functional role of the account set, and the relationship between the account sets; analyzes the corresponding rules of automatic account and actual business and implement the flexible maintenance of the rules. Wait. Among them, the study of the role of the accounting engine, the processing logic content of multi-dimensional accounting cubes will support the transformation of the entire accounting engine. (2) Analysis of system financial business processes. The business process in the system can be analyzed according to the event drive flow chain (Event-Driven-Process Chain, EPC) in the SAP R / 3 Reference Model. (3) Optimization and reconstruction of the entire management accounting system process. Based on the understanding and analysis of the management accounting engine, it redefines some rules that meet the rules of China's business handling habits and the financial system of China Accounting Standards in the original technical framework, and truly realize financial security under the original technical framework. Business integration, management accounting and financial accounting integration, localization and customization of the system implementation. Based on the understanding and transformation of the above issues, the main key links of the management accounting engine transformation in ERP are in the following questions: (1) The corresponding and unified issues of the Western management accounting subjects in the ERP system. (2) The budget sets, actual accounts, statistical accounts, and the functional role of the account set, and the relationship between the accounts. The budget management system in ERP provides the function of budgeting, budget control, and budget implementation, and supports companies from sales plan → production plan → procurement plan → fee plan → investment plan → fund plan → profit or loss plan → asset liability plan Budget preparation process. (3) Automatically record the corresponding rules of actual business and implement the flexible maintenance of the rules. Deep understanding and understanding the accounting rules corresponding to the Automatic Record System of Compiere ERP & CRM, such as the next label "General Ledger", which is automatically generated by the accounting entry. In addition, it is necessary to enhance accounting and transfers on accounting and regulations, cash account regulations, enhance accounting rules, optional accounting rules, etc., etc.
These rules are critical to the correctness and accuracy of the system underlying accounting records. (4) Problems in a single conversion and the end of the month. The single rotation of the system is automatically generated by the accounting engine to collect business information, which is processed from the way of cost, and of course, the specific cost rotation method can also be in this process. It is used in it. For the maintenance of the system, the maintenance of the time, including management costs, sales costs, financial expenses, etc. related to the time related costs. (5) The problem of embedded management accounting engine. The route for this study is mainly from the Similarities and Differences of the Central and Western Financial Accounting, then examines the business and financial processes within the system and draws the process analysis map (EPC process chain) in the system, and finally reconstructs the management accounting engine in the entire ERP. Therefore, the essence of the main ideology of the system is to provide the most valuable solution for the information needs of my country's SMEs. In particular, the target decomposition of the management accounting engine reconstruction is different into different specific sub-objectives, and the operative results are analyzed by continuous practice to obtain the operability of the most operability. Good identification. Embedded reconstruction of the management accounting engine can fill a blank in the management of accounting applications in my country, which is more important. The accounting engine implements the perfect unity of ERP business and technology. On the one hand, it obtains relevant accounting information from the actual business process of the enterprise, and on the other hand, it uses database technology, data mining technology, business intelligence technology, etc. in ERP to provide powerful business analysis. From these two aspects, the construction of accounting engine tools requires at least two expertise in business processes and information technology. Therefore, the transformation of the accounting engine is not a simple thing, and we also need us to pay attention, go to analyze, go to research, so that it will really establish an ERP system that is stable and in line with localization needs. Source: CCW Date: 2004-09-08
