TW533362B - Method for integrating bill of material with computer software - Google Patents

Abstract

A method for integrating bill of material with computer software, which is applied for a computer system with computer aided graphic system and enterprise resource planning system. The method includes the following steps: executing the graphic producing procedure, and loading the data into the computer aided graphic system to form the graphs of the designed object; executing the searching and matching procedure to compare if each component data in the graphs is identical with the component data in the database of the enterprise resource planning system; if so, the corresponding component data stored in the enterprise resource planning system is loaded into the computer aided graphics system; otherwise, executing the user interface procedure, inputting the component data into the computer aided graphic system according to the user's operation; after completion, automatically transferring into the database of the enterprise resource planning system; executing the generation procedure of the bill of material; and, using the component data in the graph of the designed object from the computer aided graphic system to generate a data file for the bill of material.

Description

533362 V. Description of the invention (1) Field of the invention The present invention relates to a method of data integration, and in particular to a method of integrating bill of materials implemented by computer software. BACKGROUND OF THE INVENTION Any industrial product, from the research and development stage to mass production, involves personnel from all aspects of the manufacturer's company (such as internal design engineers, manufacturing engineers, procurement personnel, quality control personnel, R & D project managers, and external suppliers). Engineers, etc.), which need to be repeatedly revised, and the Bill of Materials (BOM) of this product also changes with the continuous modification of the product. The content of its bill of materials has been re-drafted and written many times. Increase production costs, and greatly increase the probability of incorrect BOM content. At present, the parts bill of materials for general design objects is created and managed with a worksheet such as a document application software such as Excel. Such methods cannot display the relationship between each combined part, nor can it be linked with an enterprise resource planning system (ERP). ) Effective integration. The method for establishing the traditional bill of materials is shown in Figure 1A and Figure 1B. Figure 1A shows a method of creating a bill of materials by combining design objects in a computer-aided drawing system. When the design department of step 10 completes the combination diagram

Fifth invention description (2) After the construction, step u needs to include the information on the combination chart, standard parts information, etc. _ J enters the new parts information, enters all the parts information, and then the company needs to perform step 19 for product data management. ⑽: Chinese, product information. That is, in the above production but costing Π :: content must be manually entered up to five times m —R phase _ probability of error 0 θ Β ',,,, and pages are not assisted by computer-assisted negotiation to establish a bill of materials,' aThe design objects in the system are zero, and the part data is private. In step 100, the design department completes the zero-four combination diagram, and enters a frame in the combination diagram t. In step 110, the part drawing is grouped into the standard part information. Step = Do n’t enter new parts information, old parts turn in all parts information; Step == list, you need to re-enter at this time: The content of the list must be described in the process, the probability of adding errors to the product during the production process, also reached four times It is not only expensive, but also the invention of the inventor. · "Here, after continuous research and testing, the old parts and secondary labor must be in the frame again, there are many processes, no drawings, set the group data, I manual 3 again, and the material is cleared, also & have This 533362 V. Description of the invention (3) An object of the present invention is to provide a method that can increase product design and development to automation of production processes. Another object of the present invention is to provide a method for integrating product design and enterprise resource system integration. In order to achieve the above object of the present invention, the present invention proposes a method for implementing bill of materials integration by computer software, which is suitable for a computer system having a computer-aided drawing system and an enterprise resource planning system, including steps; executing a drawing production program, Load data into the computer-aided drawing system to form a drawing of a design object; execute a search and comparison process to compare whether the component data in the drawing is the same as the part data in the ERP database, If so, load the corresponding part data stored in the enterprise resource planning system into the computer-aided drawing system, otherwise execute a user interface program and enter the part data into the computer-aided drawing system according to user operations, that is, It can be added by comparing with the database of the enterprise resource planning system database; it can execute a bill of materials generation process and use the component data of the design object surface in the computer-aided drawing system to generate a bill of materials data file. In order to make those skilled in the art understand the purpose, features and functions of the present invention, the following specific embodiments are given in conjunction with the accompanying drawings to explain the present invention in detail, as described later:

533362

Detailed Description of the Invention In order to fully disclose the present invention, detailed descriptions are given below with reference to the drawings. FIG. 2 shows a block diagram of an application environment according to the method of the present invention. Hold ^, / 丨, the team put a% π mouth, brother figure. The implementation of the BOM integration system 2 3 is suitable for a computer system equipped with the Emperor and Enterprise Resource Planning System 25, so that: . Interworking Figure 3 shows the steps for integrating the bill of materials according to the method of the present invention. Step = execute-drawing program "It is used to load data into the computer-assisted system, to form a drawing of a design object. The loaded data includes at least the constituent elements constituting the design object. And the identification information corresponding to each component, and the loading data is stored in a specific data structure, so that the component data in the drawing can be compared with the -part data of the enterprise resource planning system database ^. Correct. Step 33 is to perform a search and comparison procedure, which is used to compare whether the component data in the drawing is the same as the part data in the enterprise resource planning system database based on the identification information. If they are the same, load the corresponding part data in the ERP system into the computer-assisted = map system, otherwise proceed to the next step 35. Step 35 is to execute a user program; it is used to process the user's operation on the user interface, and according to the user operation, input the part data into the computer-assisted system and execute a The user interface program loads part data into the enterprise resource planning system database so that the input part data corresponds to those in the drawing that do not correspond to the part data. Step 37 is to perform a BOM production

Page 7 533362 Elements of the design object drawing 5. Description of the invention (5) The production process uses the lean material in the computer-aided drawing system to generate a bill of materials data file. In the above method, the design object of the drawing is a two-dimensional (2D) or three-dimensional (3D) three-dimensional assembly drawing that is a mechanical continuous body, or an exploded view of a mechanical entity. The identification information of the component is the part material number, and the part data in the enterprise resource planning system database can include its attribute information (such as part specifications and plastic numbers), and it can also include its inventory information (such as · · Inventory amount, etc.), and can also include related production resources (such as project name and responsible person, etc.). Among them, the stop of the material list data coffin can be determined according to the needs of the user, and it can include any data in the design object part information. The method of the invention is described below with reference to several embodiments. ^ Fourth Figure A is a schematic diagram of a method for integrating a bill of materials from a design object combination diagram according to the present invention. Step 4 丨 Complete the design of the combined drawing, that is, the user loads data into the computer-aided drawing system to form a drawing surface of a design object. Step 43 is inputting part data, which is performed by performing a search ratio 璧 Shiliang 1 ancestor; ^ ΐ, whether the data of each component in the drawing and the enterprise resource planning system resources are identical today. If it is the same, go to step 47, and upload the corresponding part data in the planning system database to the private monthly self-assisted drawing system. If no, Tt material Step 4 5 is to create a bill of materials. Use the user to enter the part data. . The component data of the object surface are generated, and the design and Figure 4C in the μ% brain-assisted drawing system are actually the material list data file of the above method. Figure 4B The object combination chart is automatically disassembled to zero% T, Then. This method can also take the design ^ 仵 picture as step 49, automatically disassemble to generate zero 产生 · $ 8 pages

533362

V. Description of the invention ⑹ When drawing a part drawing, the BOM automatically generated on the combination drawing will complete the corresponding part drawing, automatically fill all the part data into the drawing frame, and write it into the product data management system (PDM) to complete the part drawing. PDM automatic drawing number management application corresponding to the part drawing method.

Figure 4B shows a design object assembly diagram of a computer-aided drawing system order. Figure 4C shows the design object combination diagram of Figure 4a. After the operation of the bill of materials integration method of the present invention, the bill of materials report, which includes the drawing layer name, part product name, model, specification, English product name, drawing And product description fields, among which the block can be determined according to the user ^ to be determined. Figure 5A is displayed according to the combined bill of materials. Step 5 1 will bring the completed design of the moving collar drawing number into the data or contain Enter the computer-aided drawing chart 'Teaware chart frame to form a design object. By performing a search and comparison of the industry resource planning system data, step 57 is performed to load the stored data into the computer-aided data. Step 55 is to create a file of the design object surface. Figure 5B and Figure 5c are the intention of the present invention. The parts are collected by manual system and the materials are cleared. Program, the enterprise drawing in the library is the material clearing step of material and material. Step 50 brings the material into the input zone and compares the information of step 53 with the information of the part. It is the part drawing frame and the input data. If there is a part drawing, it is automatically saved as the input. If the materials in the drawing are drawn in the system, it is required to use the computer to generate an actual example and not to complete the design of the part drawing. It is possible to combine and synthesize the data in the combination chart for the PDM user. The data is the same as the data of the company. If yes, < the corresponding part, user input part, Zhuo Fuzhu drawing system # 凊 单 数据

533362 V. Description of the invention (7) Figure 5B shows a part menu of a design object in a computer-aided drawing system. Figure 5C shows the bill of materials generated from the design object parts menu of Figure 5A after the operation of the bill of materials integration method of Figure 5A. Although the present invention has been disclosed as above with several preferred embodiments, it is not intended to limit the present invention. Anyone skilled in the art can make various modifications and decorations without departing from the spirit and scope of the present invention. Various changes and retouches made are within the scope of the patent application attached to the present invention.

Page 10 533362 Simple illustration of the drawings Simple illustration of the drawings Figures A and B show the conventional method of integrating bills of materials. The second figure shows a block diagram of an application environment according to the method of the present invention. The third figure shows the steps of integrating the bill of materials according to the method of the present invention. FIG. 4A is a schematic diagram showing a manner of integrating the bill of materials from a design object combination diagram according to the present invention. The fourth diagram B shows a design object assembly diagram. _ Figure 4C shows the bill of materials report generated by the method shown in Figure 4A. FIG. 5A is a schematic diagram showing a method for integrating a bill of materials from a design drawing of a part according to the present invention. The fifth diagram B shows a menu of design object parts. Figure 5C shows the bill of materials report generated by the method shown in Figure 5A. The main component number 1 0 The design department completes the assembly. Figure 11 Enters the part data 1 3 Creates the bill of materials 1 5 Enters the part data in the enterprise resource planning system 1 7 Enters the part data on the parts drawing 19 Enters the PDM part data 1 0 0 Design department Complete part drawing design

Page 11 533362 Simple illustration of the drawing 1 1 0 Assemble the part drawing and input the part data 1 3 0 Create the bill of materials 1 5 0 Enter the part data in the enterprise resource planning system 2 1 Computer-aided meeting drawing system 2 3 Bill of materials Integrated system 2 5 Enterprise resource planning system 3 1 Drawing creation step 3 3 Search comparison step 3 5 User interface execution step 3 7 BOM generation step 4 1 Combination drawing design completed 43 Enter parts data 45 Create BOM 47 Enter or Export the data of the enterprise resource planning system 4 9 Make the part drawing and load the part data 5 0 The part drawing design is completed 5 1 The part drawing collar number and bring the data into the frame 5 3 Enter the part data 55 Create the bill of materials 5 7 Input or output Information on Enterprise Resource Planning System

Claims (1)

533362 6. Scope of patent application 1. A method for integrating bill of materials by computer software, which is suitable for a computer system having a computer-aided drawing system and an enterprise resource planning system, so that the computer-aided drawing system and the enterprise resource planning system The material data can be interoperable and integrated. The method includes the following steps: A drawing production process is executed to load data into the computer-aided drawing system to form a drawing of a design object. The loaded data includes at least the composition The constituent elements of the design object and the identification information corresponding to each element, and the loading data is stored in a specific data structure, so that the component data in the drawing and the part data in the enterprise resource planning system database can be stored. Perform a comparison; perform a search comparison procedure, which is used to compare whether the component data in the drawing is the same as the part data in the enterprise resource planning system database based on the identification information, and if so, it will be stored in the enterprise resource The corresponding part data in the planning system is loaded into the computer-aided drawing system, Then proceed to the next step; execute a user interface program for processing the user's operation on the user interface, and input part data into the computer-aided drawing system according to the user operation, and execute the user The interface program imports the part data into the database of the enterprise resource planning system, so that the input part data corresponds to the components in the drawing that do not correspond to the part data; execute a bill of materials generation process, and use the design in the computer-aided drawing system The component data of the object drawing generates a BOM data file. 2. The method described in item 1 of the scope of patent application, wherein the design object of the drawing can be an assembly drawing of a mechanical entity. 3. The method described in item 1 of the scope of patent application, wherein the design of the drawing 533362 6. The scope of the patent application can be 4. If the special information is applied for parts 5. If the special planning system information is applied 6. If the special planning system information is applied 7. If the special planning system information is applied 8. If the special material file is applied The column is a part drawing of a mechanical entity. The method described in item 1, wherein the component is identified by a part number. The method described in item 1, wherein the part data in the enterprise resource database includes attribute information of the part. The method described in item 1 of the profit scope, wherein the part data in the enterprise resource database includes inventory information of the part. The method described in item 1 of the profit scope, wherein the part data in the enterprise resource database includes production information of the part. The method described in item 1 of the profit scope, wherein the bill of materials can be determined according to the needs of the user. Page 14