TWI662487B - Enterprise resource management system - Google Patents

Abstract

An enterprise resource management system, including: a data management module, which has at least one list, the list has at least one new key, the new key has a pull-down menu, and the drop-down menu has At least one product, after selecting the product, opening a product basic data table; and a cloud database, which is connected to the data management module, and the cloud database has at least one pair of product basic structural information And the corresponding production process information of the product, the basic information of the structure includes the original material information of the product and the multiple accessory information of the product. By selecting the product, the basic structural information and the production process information are transmitted and displayed in the The BOM basic data table can automatically generate basic structural information and production process information corresponding to the product, improving work efficiency.

Description

Enterprise Resource Management System

The invention relates to an enterprise management system, in particular to an enterprise resource management system applied to the printing and packaging industry.

Before any product is produced, any enterprise must first plan the requirements and plans for the parts. In addition to providing the basis for the procurement of parts and components by the production department, it also plans the scheduling of the parts and components.

The composition of the product is matched with various purchased materials and parts, and semi-finished products are produced through the production process, and then various semi-finished products are matched with the purchased materials to further produce semi-finished products or finished products. Therefore, it must be described in advance which materials and quantities are to be made into a product, and these materials are individually composed of those materials, so that the component structure of the materials is established layer by layer. The description and setting of these materials are generally called Bill of Materials (BOM). The material component composition table is the basis of the material component demand planning. After the product order is developed into the requirements of each material component through the material component composition table, the procurement of the material components and the production schedule can be determined.

The conventional material and component composition table and its filing method have the following disadvantages: 1. In the conventional material and component composition table and its filing method, it is necessary to produce all levels of sub-materials used in the production of each type of material. Creating files one by one makes the user's load very heavy when creating files. In particular, when changing the design, changing the composition table of materials, or changing the standard usage or depletion rate due to changes in materials design, characteristics, quality, etc., the entire material structure table must be identified and modified one by one. Very complicated and error-prone, which often causes considerable distress to staff. 2. In the conventional material component composition table and its filing method, multi-level coding must be performed on all levels of sub-materials used in the production of each type of material, and there is no distinction between which sub-materials are production materials. Which are purchased materials. For changes in the design, characteristics, quality, etc. of a certain material, which causes changes in the standard consumption or loss rate of the material when producing the master material, the logistics management within the enterprise must be recalculated for each sub-material , Its modification steps are equally complicated and error-prone.

In view of this, how to eliminate the above-mentioned shortcomings is the technical difficulty that the inventor intends to solve; however, based on years of experience in the related industry, the inventor of the present case has made painstaking efforts and researched for years to make improvements. Those who have successfully completed the case and made the present invention to improve the efficacy.

In view of the shortcomings of the above-mentioned conventional technologies, the present invention provides an enterprise resource management system, which includes: a data management module having at least one list, and the list has at least one new key, the new key There is a pull-down menu with at least one product in the drop-down menu. After selecting the product, a basic product data table is opened; and a cloud database that is connected to the data management module and the cloud data The library has at least one pair of basic information about the structure of the product and one pair of products' production process information. The basic information of the structure includes the raw material information of the product and the multiple accessory information of the product. The structure is selected by selecting the product. The basic information and the production process information are transmitted and displayed in the BOM basic data table, so that the structural basic information and the production process information corresponding to the product are automatically generated, which improves the work efficiency.

Referring to the first figure, the enterprise resource management system 1 of the present invention includes: a data management module 10 and a cloud database 20.

Please refer to the second figure, the data management module 10, which has at least one list 11 whose columns include serial number, customer, product ID, product name, product type, product specification, product unit price, product barcode , Unfolding specifications, finished product weight, unit, packing unit, disable and operation.

Please refer to the second to fourth figures. The list 11 has at least one new key 111, the new key 111 has a pull-down menu 112, and the drop-down menu 112 has at least one product 113. After the product 113, a product basic information table 12 is opened. The product basic information table 12 has a next button. The columns of the BOM basic information table include product specifications, product unit prices, product barcodes, expanded specifications, finished product weight, and errors Value, packing quantity, unit, packing unit, packing instructions, product remarks, outer box label barcode, insured specifications and whether to disable, provide user operation input, and click the next button after the input is completed.

After the user enters the product basic data table 12 and clicks the next button, a BOM basic data table 13 is generated. The columns of the BOM basic data table 13 include an accessory column 131 corresponding to the product 113 and a production process column. 132 and a parameter column 133.

Please refer to the fifth figure. The cloud database 20 is connected to the data management module 10. The cloud database 20 has at least one pair of product basic information 21 and a production process of the corresponding product 113. Information 22, the basic information of the structure 21 is commonly known as the bill of materials (BOM of bills of materials, abbreviation BOM), including the product's multiple original material information and the product's multiple accessories information;

The columns of the production process information include paper cutting, front printing, back printing, front glazing, rolling (die cutting) and papermaking.

Please refer to the fifth and sixth figures. The cloud database 20 imports the basic structural information 21 and production process information 22 of the corresponding product 113 into the BOM basic data table 13. The structural basic information 21 and the production process information 22 are respectively It is transmitted and displayed in the accessory column 131 and the production process column 132, which simplifies the work process and improves work efficiency.

In other words, the drop-down menu has at least one product (that is, the finished product type). After selecting the product 113, the system connects to the cloud database 20 according to the product 113 selected by the user to search for a BOM template that matches the product 113. The template has defined the semi-finished products required by the composition of the product 113 for the user and the corresponding production process. The user only needs to use the materials and their amounts used in the actual finished product, as well as the source of the procurement materials. Can produce complete BOM basic data sheet 13.

Referring to the seventh figure, the cloud database 20 of the enterprise resource management system 1 of the present invention is further connected to a back-end data processing module 30 for establishing or updating the structural basic information 21 and the production process information 22.

The above detailed descriptions are specific descriptions of the feasible embodiments of the present invention, but these embodiments are not intended to limit the patent scope of the present invention, and any equivalent implementations or changes that do not depart from the technical spirit of the present invention should be included in this case Within the scope of patents.

1‧‧‧ Enterprise Resource Management System

10‧‧‧Data Management Module

11‧‧‧List list

111‧‧‧Add key

112‧‧‧drop-down menu

113‧‧‧Products

12‧‧‧Product Basic Data Sheet

13‧‧‧BOM Basic Information Sheet

131‧‧‧Accessories

132‧‧‧Production process column

133‧‧‧parameter column

20‧‧‧Cloud Database

21‧‧‧ Structure Basic Information

22‧‧‧ Production Process Information

30‧‧‧Backend data processing module

The first figure is a schematic diagram of the architecture of the present invention. The second figure is a schematic diagram of a list of the present invention. The third figure is a schematic diagram of a pull-down menu of the present invention. The fourth figure is a schematic diagram of the basic data sheet of the product of the present invention. The fifth figure is a schematic diagram of the connection between the cloud database and the BOM basic data table of the present invention. The sixth diagram is a schematic diagram of the BOM basic data table of the present invention. The seventh diagram is another architectural intention of the present invention.

Claims (1)

An enterprise resource management system includes: a data management module, which has at least a list, and the columns of the list include a serial number, a customer, a product ID, a product name, a product type, a product specification, a product unit price, Product barcode, expanded specifications, finished product weight, unit, packing unit, disabling and operation, the list has at least one new key, the new key has a pull-down menu, and the drop-down menu has at least one product, By selecting the product, a product basic data table is opened, and the product basic data table has a next button, and after inputting, the next button is clicked to generate a BOM basic data table. The columns include an accessory column, a production process column, and a parameter column; a cloud database, which is connected to the data management module, and the cloud database has at least one pair of basic structural information and one pair of corresponding products Product production process information. The columns of the production process information include paper cutting, front printing, back printing, front coating, rolling (die cutting), and Paper-cutting, the basic information of the structure includes multiple raw material information of the product and multiple accessory information of the product. Select the product to transmit and display the basic structural information and the production process information in the BOM basic data table. The basic structure of the structure is The information and the production process information are transmitted and displayed in the accessory column and the production process column, respectively; and a back-end data processing module, which is connected to the cloud database to establish or update the basic information of the structure and The production process information.