1  续言

最初本着尽可能完成ERP的各项功能的原则，将物料控制到只在需要的时候向需要的部门按需要的数量，提供所需要的物料，也就是说，它既要防止物料供应滞后于对他们的要求，也要防止物料过早地出产和进货，以免增加库存，造成物资和资金的积压，设计了这套管理软件，但在设计的过程中发现许多实际问题非常复杂，软件很难控制，本着能自动化的尽量自动化，不容易实现自动化的则人为操作，由于能力有限和时间的限制，系统的设计难免会存在不足之处，敬请各位同学、老师不吝赐教。

2  系统分析

2.1 问题的提出

本公司目前存在的问题是：信息化不足，计算机使用率低，大量的日常工作皆是手工处理，因此工作效率低落，企业内部沟通不良等等问题很难克服，仓库管理很不合理，不能及时根据需要调整库存。

公司希望解决的问题是：缺少一个集成的信息平台和信息系统，而各个业务部门之间缺少信息沟通（即重复劳动）和共享是传统库存管理中资金占用过大的主要原因之一。解决企业内部统一的物料编码管理，物流管理中的信息流通。库存积压与物料的配套问题。完善质量检验，对生产过程中的质量信息进行全面管理，包括原材料、外购外协件、半成品、成品各道工序的质量控制，用户反馈，售后服务，并对各种数据进行统计分析。生产管理，对车间作业进行管理，对施工通知单、设计更改通知单进行制订与查询。销售部门能方便地根据预测信息、各仓库的库存信息和客户的要货情况做出货物的调拨计划和改制计划。随时了解供应商的供货（原材料和外协加工）执行情况、制造车间的加工（合格、报废、返工等）执行情况及公司的各仓库库存情况，以便随时协调或采取合适的补救措施管理供应商，在供应到货的到期日前，主动与供应商联系，检查及时到货的可能性；同时在物流和信息流上允许供应商的部分零件直接发货到客户处。对供应商的考核从质量、交货及时程度和价格上给出统计数据。计划过程不太理想，无物料清单，凭经验办事；对计划的执行率未作统计。现有量、在制品、再途库存和历史记录等多方位查询需求。库存信息与供应和生产等各部门的及时反馈和共享问题信息查询与决策，对公司的各种资源与信息进行查询，包括销售、采购、生产、质量、人事、财务等信息数据进行查询、统计与分析，对根据信息作出快速合理的经营决策，增强应变反应能力。

2.2 分析问题

本公司是以订单为依据进行生产的实业公司，公司的主要流程是：接到一张销售订单，由销售部门转化为内部订单，转给生产部门，生产部门根据订单上的产品、数量，技术部已经配好的物料清单，及各车间半成品储存量，汇总材料需求，然后根据库存情况决定请购及预约情况，采购部门根据请购单下采购单，然后材料入库，在手工操作的条件下，各个部门之间的沟通困难，比如，当采购部下完采购订单之后，仓库是否如期到货，必须去仓库询问，而且即使询问了，有时候因为订单较多材料有可能重复，而无法确定是哪一张采购单到货，哪一张没有到货，再例如，销售部门下过内部订单之后，就容易了解到这个单子上的这批货物到底处于什么状态，是已发完，还是未发，生产是否完毕等，要无数次的询问仓库和生产部门才能了解到部分情况，等等，这一系列的问题迫待解决，随着经济的全球化以及中国经济改革的逐渐深化，制造业面临着越来越激烈的竞争，改善企业内部以及整个供应链各个环节的管理、调度及资源配置，迅速适应客户的新需求和市场新机遇的能力，是中国企业赢得竞争胜利的决定性因素，如何快速有效地实现跟单，如何有效的控制库存，这一切都是本管理系统所力求实现的功能。

从根本上说，企业就是一个利用资源（人、财、物、时间），为客户创造价值的组织，企业资源计划就是对这些资源进行计划、调度、控制、衡量、改进的管理技术和信息系统。现今的企业并不只是人力资源、资金和产品的组合，它还应该包括供应、销售、市场营销、客户服务、需求预测，以及其他更多的东西。如果一个企业资源计划系统真正想要最大限度地提高其生产能力，它必须能够非常融洽地和其他关键性的商务领域进行交流。

2.3 系统设计目标

2.3.1 系统设计的长远目标：实现ERP系统

1．系统运行集成化：

这是ERP应用成功在技术解决方案方面最基本的表现。ERP系统是对企业物流、资金流、信息流进行一体化管理的软件系统，其核心管理思想就是实现对“供应链（Supply Chain）”的管理。软件的应用将跨越多个部门甚至多个企业。为了达到预期设定的应用目标，最基本的要求是系统能够运行起来，实现集成化应用，建立企业决策完善的数据体系和信息共享机制。一般来说，如果ERP系统仅在财务部门应用，只能实现财务管理规范化、改善应收帐款和资金管理；仅在销售部门应用，只能加强和改善营销管理；仅在库存管理部门应用，只能帮助掌握存货信息；仅在生产部门应用只能辅助制定生产计划和物资需求计划。只有集成一体化运行起来，才有可能达到：降低库存，提高资金利用率和控制经营风险；控制产品生产成本，缩短产品生产周期；提高产品质量和合格率；减少财务坏帐、呆帐金额等。这些目标能否真正达到，还要取决于企业业务流程重组的实施效果。　　

2．业务流程合理化：　　

这是ERP应用成功在改善管理效率方面的体现。ERP应用成功的前提是必须对企业实施业务流程重组，因此，ERP应用成功也即意味着企业业务处理流程趋于合理化，并实现了ERP应用的以下几个最终目标：企业竞争力得到大幅度提升；企业面对市场的响应速度大大加快；客户满意度显著改善。

3．绩效监控动态化：

ERP的应用，将为企业提供丰富的管理信息。如何用好这些信息并在企业管理和决策过程中真正起到作用，是衡量ERP应用成功的另一个标志。在ERP系统完全投入实际运行后，企业应根据管理需要，利用ERP系统提供的信息资源设计出一套动态监控管理绩效变化的报表体系，以期即时反馈和纠正管理中存在的问题。这项工作，一般是在ERP系统实施完成后由企业设计完成。企业如未能利用ERP系统提供的信息资源建立起自己的绩效监控系统，将意味着ERP系统应用没有完全成功。

4．理改善持续化：

随着ERP系统的应用和企业业务流程的合理化，企业管理水平将会明显提高。为了衡量企业管理水平的改善程度，可以依据管理咨询公司提供的企业管理评价指标体系对企业管理水平进行综合评价。评价过程本身并不是目的，为企业建立一个可以不断进行自我评价和不断改善管理的机制，才是真正目的。这也是ERP应用成功的一个经常不被人们重视的标志。

2.3.2 系统设计近期

（1）建立基本资料信息库，规范所有资料信息。

（2）物料控制半自动化，加强了各个部门之间的联系。

（3）高库存管理的服务水平，最大限度地降低库存量，包括中间库存和在制品的库存，以减少在库存上的资金积压。

（4）最大限度的保证订货任务的按期完成。

（5）提高计划的可能性，实现均衡生产：

（6）集成管理职能，提高管理效率。

Invoicing Management System


  

A preliminary analysis of the current business management problems that exist in connection with the actual situation in order to control designed and implemented a logistics-based management software. The system realizes some ERP functions, to strive for lower implementation costs, reduce implementation risk, accelerate the progress in the implementation and increase return on investment.

Company material supply management is often very complicated and cumbersome, because of the many types of material to master, ordering, management, and distribution channels vary in various business management systems vary among the various kinds of statistical plans many reports, so Materials management must be computerized, and must be based on the specific situation of business development will improve work efficiency.

Based on the current business management system, general material supply management system, always based on available materials category is divided into several sections for the appropriate program materials, ordering, checking storage, according to business needs of different sectors to send materials and equipment, and Recent Inventory at any time for the accounting, according to business leaders and their own management needs monthly, quarterly and annual statistical analysis, to produce reports, in order to strengthen key materials, equipment, management, and to grasp its reserves consumption on a regular basis, according to plans and actual consumption of fixed quotas compared to quota management. Therefore, a complete enterprise material supply management system should include project management, contract collection management, warehouse management, quota management, statistics management, financial management until the module. One warehouse management is the entire material supply management system core.

Using Microsoft Visual Basic 6.0 and Microsoft Office Access 2003 as a development tool, using object-oriented structures and top-down program design method, basically the daily management of the warehouse and purchase shipping inquiries.

  

Keywords: enterprise resource planning, inventory, database, object-oriented

  



Abstract
The first step analyzes the current business company to manage the problem of the aspect existence, contact actual circumstance the design carried out a take controling the logistics as lord of management software.That system carried out the function of parts of ERPs, making an effort to attain to lower the implement cost, reducing to carry out the risk, speeding implement degree of progress, increasing the investment repay.

The supplies supply management of the business enterprise is usually very complex, tedious, because the supplies category that control is numerous, order, manage, the outlet that issue is each to have the difference, the management system between each business enterprise does not fulfil same alike, each kind of covariance plan statement is numerous.

According to the current business enterprise management system, the general supplies supply management system, always according to the supplies category control, correspond to be divided into the plan that a few section rooms carry on the supplies, order, check to store in warehouse, according to the demand of the business enterprise each section to send out the supplies equipments, and at any time in the near future carry on the stock stocktaking, make the pedestal debt, according to the business enterprise leads to manage with oneself of demand is by the month, quarter, the year carry on statisticsing the analysis, the creation correspond the statement, for strengthenning the key supplies, the management of the equipments, want to periodically control it store the depletion circumstance, settling the sum according to the plan and consuming to settle the sum physically of comparison, carry on settling the sum to manage.So an integrity of the business enterprise supplies supply management the system should include the plan management, the contract collection management, warehouse management, settle sum management, statistics the management, finance management wait until the mold piece.Among them, the warehouse management is the core of the whole supplies supply management system.

Use the Microsoft Visual Basic 6.0 and the Microsoft Office Access 2003 conduct and actionses development tool, make use of the structure of face to the object and from top to bottom of program design method, basic carried out the usual management of the warehouse and enter the search of the goods shipment.

  

Keywords: ERP, Stock, Database, Face to the object

Directory


 


Summary I

Abstract II

A renewal of words 1

2 Analysis

2.1 of the problem 4

2.2 analyze problems 4

2.3 System Design Goals 5

2.3.1 System Design for long-term goal: achieving ERP system 5

2.3.2 System Design recently 6

3 System Design

3.1 The data flow diagram 7

3.2 part of the data dictionary 11

3.3 E-R diagram 12

3.4 Functional Module 14

3.4.1 Procedure-level 14

3.4.2 Module Function Description 15

  
 
3.4.3 System data sheet 15

The detailed design of the system 4 17

5 Coding and Testing

5.1 Coding Summary 21

5.2 Program Interface 28

6 Summary and Outlook

6.1 Summary 34

6.2 experience Experience 35

Thanks 37

References 38

  

  
 
  




A renewal of a statement
According to the instructor, corporate and customer requirements, this graduation design is entitled Invoicing Management System, asked management platform using Visual Basic to complete the design, construction of the library used; the use of Access database to store data, limited to stand-alone use.

Company material supply management is often very complicated and cumbersome, because of the many types of material to master, ordering, management, and distribution channels vary in various business management systems vary among the various kinds of statistical plans many reports, so Materials management must be computerized, and must be based on the specific situation of business development will improve work efficiency,

Based on the current business management system, general material supply management system, always based on available materials category is divided into several sections for the appropriate program materials, ordering, checking storage, according to business needs of different sectors to send materials and equipment, and Recent Inventory at any time for the accounting, according to business leaders and their own management needs monthly, quarterly and annual statistical analysis, to produce reports, in order to strengthen key materials, equipment, management, and to grasp its reserves consumption on a regular basis, according to plans and actual consumption of fixed quotas compared to quota management.

Therefore, a complete enterprise material supply management system should include project management, contract collection management, warehouse management, quota management, statistics management, financial management until the module. One warehouse management is the entire material supply management system core.

As science and technology, especially information engineering, computer technology, high technology, rapid development and popularization of the world today has entered into the information age. Businesses and organizations require increasingly large amounts of information processing speed Yuelai super fast. In order for managers timely and accurate, and reliable information, as well as after the implementation of the feedback constitutes a real need to establish a fully functional and efficient information management system. Information management system to adopt a computer-based technology and equipment, through the automation of communication networks, and variety of information terminals connected to the use of sound communication networks, communication links in all aspects to ensure fast, accurate and timely collection and issued a命令.

The company (now the domestic industry''s most representative) problems: lack of information technology, computer usage is low, a lot of day to day operations are handled manually, so the efficiency is low, internal miscommunication, and so the problem difficult to overcome. To enhance the competitiveness of enterprises, corporate internal information technology is an indispensable step. The implementation of advanced office automation systems, enterprise internal information management, sharing and exchange, in order to allow enterprises in the competitive 21st century opportunities.

With economic globalization and the gradual deepening of China''s economic reforms, the manufacturing industry is facing increasingly fierce competition, improving internal and throughout the supply chain management, scheduling and resource allocation, to adapt quickly to changing customer demand and market ability of new opportunities is the victory of Chinese enterprises won the decisive factor in competition, while the rapid and effective implementation of enterprise resource planning (ERP) system is proven by practice to improve the competitiveness of enterprises of the most effective methods. Fundamentally speaking, business is a use of resources (human, financial, material, time), the organization create value for customers, ERP is the planning of these resources, scheduling, control, measurement, improved management techniques and information systems. Today''s enterprise is not just human resources, capital and product portfolio, it should also include the supply, sale, marketing, customer service, demand forecasting, and many more things. If an ERP system, really want to maximize their production capacity, it must be a very harmonious and in other critical areas of business communication.

Enterprise Resource Planning (ERP) applications will be many business process automation and integration, thus helping enterprises to maintain a competitive advantage; digital content management applications to effectively control the storage, retrieval and reuse of resources, thereby streamlining the various kinds of operations, help to avoid redundancy; supply chain management is the supply chain of goods and services, information, and money by electronic means for planning and implementation of flow control, improve the system''s intelligence level of production, supply, marketing, Finance to form a unified whole. Full control of the enterprise in the state, compressed the scale of investment, speed up around the capital, reflected in real time, based on amendments to enterprises in the ordinary course of business, all aspects of production on the bias, reduce product cost and unnecessary backlog of raw materials and products. ERP and supply chain management will be (SCM), Customer Relationship Management (CRM), business functions (BI), knowledge management (KM) and e-commerce completely together. These systems will be the same as a team to work regularly and customer contact, so as to provide them with services, advice and suggestions and to ensure the normal operation of the system.

Industries for the current domestic problems, this paper designed a material stream processing mainly has certain characteristics of intelligent features and network management systems. The system can not only control of intelligent enterprise''s logistics situation, but also has easy to operate, easy error correction features.

To sum up the advantages of the system are as follows:

(1) basic information the user to establish a one-time, easy to standardize control.

(2) material control semi-automatic, strengthening the linkages between various sectors.

(3) to improve inventory management of service levels, minimize inventory levels, including intermediate products in stock and in stock in order to reduce the backlog of inventory capital.

(4) The maximum guarantee of ordering tasks on schedule.

(5) the possibility of enhancing the scheme to achieve a balanced production.

(6) integrated management functions, improve management efficiency.

This paper describes Invoicing management system design goals, system requirements, overall design, detailed design, testing and so on. Finally, a summary of this graduation design and experience.

With the completion of the original as much as possible the principles of the various functions of ERP will be material to control it when it was needed only in the needs of the number of departments as necessary, to provide the required materials, that is, both to prevent supplies lag of their demands, but also to prevent premature to produce and purchase of materials, to avoid increasing the inventory, resulting in the backlog of material and financial resources designed set of management software, but in the design process found in many practical problems are very complex, software is difficult to control, can be automated as far as possible the spirit of automation, while not easy to automate manual intervention, due to limited capacity and time constraints, the system will inevitably exist in the design inadequacies, I would urge students and teachers to hearing.

2 Analysis
2.1 of the problem
The company''s current problems are: lack of information, computer usage is low, a lot of day to day operations are handled manually, so the efficiency is low, poor communication within the enterprise and so on is difficult to overcome, and warehouse management is very unreasonable and can not be timely need to be adjusted according to stock.

Company wants to solve the problem is: the lack of an integrated information platform and information system, a lack of information among the various business units of communication (that is, duplication of effort), and sharing is a traditional inventory management in the amount of funds used too much one of the main. Solve the internal unity of the material coding management, logistics management information flow. Overstock problems with the supporting materials. Perfect quality inspection, production process of the overall management of the quality of information, including raw materials, purchased and spare parts, semi-finished and finished products quality control of each working procedure, user feedback, service, and a variety of data for statistical analysis. Production management, job shop management, notice of construction, design change notice to the formulation and query. Sales department can be easily predicted that information, the warehouse inventory information and the customer to make a track of the delivery of goods allocation plans and restructuring plans. To keep abreast of suppliers (of raw materials and Subcontractor) implementation of manufacturing plant processing (qualified, scrap, rework, etc.) implementation and the company''s various warehouses inventory, and to facilitate co-ordination at any time or to take appropriate remedial measures to manage the supply of operators in the supply arrival of the due date, take the initiative to contact the vendor to check the possibility of the timely arrival; the same time, logistics and information flow allowed on spare parts suppliers shipping directly to the client office. Assessment of suppliers of quality, delivery timeliness and price, given statistical data. The planning process is not ideal, no bill of materials, use their experience to law; rate of implementation of the plan have not been statistical. Current volume, in the products, re-transit inventory and historical records, multi-dimensional query requirements. Inventory information and supply and production of various sectors of timely feedback and sharing information query and decision-making, the company''s various resources and information inquiries, including sales, purchasing, production, quality, personnel, financial and other information data, query, statistics and analysis, based on information to make rational business decisions quickly to enhance emergency response capabilities.

2.2 analyze problems
The Company is engaged in production orders based industrial company, the company''s main processes are: receipt of a sales order from the sales department into the internal order, transferred to the production department, production department in accordance with orders on the products, quantity, technical The Department has allocated a good bill of materials, semi-finished products and the plant capacity, aggregate material requirements, and then decided to request the purchase of inventory and reservations, purchasing departments for the next purchase order requisitions, and material storage, in the conditions of manual Under the communication difficulties between the various departments, for example, when the men finished the procurement purchase orders, the warehouse is scheduled arrival, you must go to warehouses ask, and even asked, and sometimes because the orders are more likely to repeat material, but can not be determined Which one purchase orders arrive, which one did not arrive, then, for example, sales orders within the next over, after it is easy to understand that this list is in the end on what the status of the shipment is sent end, or not hair, the production is finished, etc., to numerous inquiries warehouse and production departments in order to understand that some circumstances, and so on, this series of problems forced to be resolved, along with economic globalization and the gradual deepening of China''s economic reforms, the manufacturing industry faced with increasing competition, improving internal and throughout the supply chain management, scheduling and resource allocation, to adapt quickly to changing customer demands and new market opportunities, ability is the victory of Chinese enterprises won the decisive factor in competition, how to quickly and efficiently to achieve with the single, how to effectively control inventory, all are striving for in this management system functions.

Fundamentally speaking, business is a use of resources (human, financial, material, time), the organization create value for customers, enterprise resource planning is the right of these resources planning, scheduling, control, measurement, improved management techniques and information systems . Today''s enterprise is not just human resources, capital and product portfolio, it should also include the supply, sale, marketing, customer service, demand forecasting, and many more things. If an enterprise resource planning system really want to maximize their production capacity, it must be a very harmonious and in other critical areas of business communication.

2.3 System design goals
2.3.1 System Design for long-term goal: achieving ERP system
1. Integrated system is running:

This is the ERP application of technology solutions for the success of the most basic performance. ERP systems are enterprise logistics, capital flow, information flow for integrated management software system at its core management philosophy is to achieve the right "supply chain (Supply Chain)" management. Software applications will span multiple departments or multiple enterprises. In order to achieve the desired application set goals, the most basic requirement is that the system be able to run up and realize the integrated applications and to establish a sound business decision data systems and information-sharing mechanism. In general, if the ERP system is only applied in the financial sector can only achieve the financial management standardization, to improve the accounts receivable and financial management; only in the sales application, only strengthen and improve the marketing management; only in the inventory management application, can only help control inventory information; only applied in the production sector can only be assisted to develop production plans and material requirements planning. Only the integration of the integration up and running, will it be possible to: reduce inventory, improve capital utilization and control of business risks; control production costs, shorten production cycle; improve product quality and pass rates; to reduce the financial bad debts, bad loans, etc. . These objectives can really be achieved, but also depends on the implementation of enterprise business process reengineering results.

2. Business Process Rationalization:

This is the success of ERP applications to improve management efficiency is all about. Prerequisite for the success of ERP applications is the need for enterprises to implement Business Process Reengineering, therefore, ERP application success would mean that the rationalization of enterprise business processes and realize the following ERP applications, the ultimate goal: to enhance the competitiveness of enterprises have been substantially ; businesses in dealing with the market response to greatly accelerate the speed; customer satisfaction improved significantly.

3. Dynamic performance monitoring:

ERP applications, will provide companies with a wealth of management information. How to make good use of this information, and in the enterprise management and decision-making process in a real role to play, is a measure of the success of ERP applications is another sign. In the ERP system is fully put into practical operation, the enterprise should be based on management needs, using information provided by the ERP system resources to design a set of dynamic monitoring of changes in management performance reporting system, with a view to immediate feedback and correct the management problems. This work is generally completed in the ERP system implementation design has been completed by the enterprises. Enterprises, such as failure to use information resources provided by the ERP system, set up their own performance monitoring system, will mean ERP system applications is not entirely successful.

4. Improve the continuum of reasons:

With the ERP system, applications and rationalization of business processes, enterprise management level will be significantly improved. In order to measure the level of enterprise management to improve the level could be based management consulting firm providing enterprise management evaluation index system for comprehensive evaluation of the level of enterprise management. Evaluation process, not an end in itself, for enterprises to establish an ongoing self-evaluation and continuous improvement of management systems, is the real purpose. This is also the success of an ERP application is not always a sign of people''s attention.

2.3.2 System Design recently
(1) the establishment of basic data and information database, standardize all the data and information.

(2) material control semi-automatic, strengthening the linkages between various sectors.

(3) high level of service inventory management to minimize inventory levels, including intermediate products in stock and in stock in order to reduce the backlog of inventory capital.

(4) The maximum guarantee of ordering tasks on schedule.

(5) the possibility of enhancing the scheme to achieve a balanced production:

(6) integrated management functions, improve management efficiency